• 2009
  • June General Meeting
  • March General Meeting
• 2008
  • December General Meeting
  • September General Meeting - NYC Metro Area User Group Meeting
  • June General Meeting
  • March General Meeting
• 2007
  • December General Meeting
  • October General Meeting - NYC Metro Area User Group Meeting
  • June General Meeting
  • March General Meeting
• 2006
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2005
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
• 2004
  • December General Meeting
  • September General Meeting
  • June General Meeting
• 2003
  • December General Meeting
  • September General Meeting
  • March General Meeting
• 2002
  • December General Meeting
  • September General Meeting
  • June General Meeting
  • March General Meeting
  • January General Meeting
• 2001
  • June General Meeting
  • March Training Day
• 2000
  • December Training Day
• 1999
  • December General Meeting
  • September General Meeting
  • February General Meeting

June 2009 General Meeting

• Keynote

• DBA Track

• Development Track

This presentation will discuss some of the important challenges and how to overcome these challenges while upgrading to Oracle Database 11g. Topics like SQL plan management and real application testing will be covered.

Ashish Agrawal has been working in the Information Technology field for more than 15 years, including the last 8 years with Oracle Support Services in different roles. He currently works as a Senior Principal Technical Support Engineer with the Oracle Center of Excellence. He is an Oracle Certified Professional (OCP 11g, 10g, 9i, 8i, 7.3.4) who specializes in Oracle Database Administration, performance tuning, Database upgrades, and systems architecture. Ashish holds a Bachelor of Engineering Degree in Electronics Design and Technology from Nagpur University, India.

Back to Top

DBA TRACK: Get More for Less: Enhance Data Security and Cut Costs

The faltering economy has not slowed the alarming rate of attempted and successful data theft. This session will review in detail the different options for data protection strategies in an Oracle environment and answer the question “How can IT security professionals provide data protection in the most cost effective manner?” The presentation includes anonymous case studies about Enterprise Data Security projects at several companies, including the strategy that addresses key areas of focus for file and database security in an Oracle environment. The session will also present methods to protect the entire data flow across systems in an enterprise while minimizing the need for cryptographic services. This session will also review approaches to protect the data that are based on secure encryption, robust key management, separation of duties, and auditing.

Ulf Mattson created the initial architecture of Protegrity's database security technology, working closely with Oracle R&D, creating several key patents in the area of database security. His extensive IT and security industry experience includes 20 years with IBM as a manager of software development, and a consulting resource to IBM's Research and Development organization in the areas of IT Architecture and IT Security. Ulf holds a degree in electrical engineering from Polhem University, a degree in Finance from University of Stockholm and a master's degree in physics from Chalmers University of Technology.

Back to Top

DBA TRACK: DBA Best Practices: A Primer on Managing Oracle Databases

Database administration does not have to be challenging, if done right. This session discusses best practices that are vital to good database management while debunking many myths that are prevalent today. Topics include database configuration, space management, performance tuning, and backup and recovery for Oracle Database 10g and 11g.

Mughees Minhas is responsible for the self-managing solutions of the Oracle Database with special interest in areas such as performance diagnostics, SQL optimization and tuning, space management and load testing. He has more than 13 years of experience working with Oracle databases and is currently senior director of product management in Oracle’s Server Technologies division

Back to Top

DBA TRACK: A Comprehensive Guide to Partitioning with Samples

This presentation discusses partitioning options for each currently available Oracle version, in particular Oracle11g. The focus is on implementing the new partitioning options available in 11g, while enhancing performance tuning for the physical model and applications involved. The presentation covers both middle-to-large-size and VLDB databases with significant implications for consolidation, systems integration, high-availability, and virtualization support. Topics covered include subsequent performance tuning and specific application usage such as IOT-partitioning and composite partitioning choices.

Anthony D. Noriega is a computer scientist and IT Consultant, OCP instructor and Adjunct Professor, who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony holds an MS Computer Science from NJIT, where he was also a doctoral candidate in the same field, an MBA from Montclair State University, and a BS in Systems Engineering from Universidad del Norte (Barranquilla, Colombia). He has been a Senior Consultant for several financial and industry-leading American and European corporations.

Back to Top

DBA TRACK: Migrating Database Character Sets to Unicode

To meet the needs of globalization, more and more companies are facing the challenge of migrating their existing database character sets to Unicode. Not understanding the issues and proper steps necessary to achieve this migration can lead to problematic outcomes. This presentation will show how to use csscan and csalter to convert database character sets to Unicode. It will also cover some of the issues, options, and resolutions that may be encountered during implementation.

Yan Li has been working with Oracle products for over 15 years as a DBA for different companies. She has been a member of NYOUG and benefited from her association with the group for many years. This is her first public presentation.

Back to Top

Oracle Data Mining, an Option to the Oracle Database EE, rapidly sifts through data to identify relationships, build predictive models, and discover new insights for many business and technical problems including: predicting customer behavior, finding a customer's next-likely-purchase, detecting fraud, discovering market basket bundles, developing detailed profiles of target customers, reducing warranty costs, and anticipating churn. This presentation will include an overview of data mining concepts and Oracle Data Mining features interspersed with several "live" demonstrations of ODM used as a "tool" and embedded inside Applications to make them Powered by Oracle Data Mining.

Charlie Berger is the Senior Director of Product Management, Data Mining Technologies at Oracle Corporation and has been with Oracle for ten years. Previously, he was the VP of Marketing at Thinking Machines prior to its acquisition by Oracle in 1999. He holds a Master of Science in Engineering and a Master of Business Administration from Boston University as well as a Bachelor of Sciences in Industrial Engineering/Operations Research from the University of Massachusetts at Amherst.

Back to Top

While data masking has become a popular control over confidentiality exposures in development and testing systems, implementing a sustainable program in a modern enterprise environment can be challenging, both organizationally and technically. This session recounts stories from the field of data masking in financial services corporations and reviews one vendor's most valuable lessons learned.

Ilker Taskaya is a data masking practice manager at Axis Technology, LLC specializing in financial services data security solutions. He manages the data masking solution offering for Axis, including services delivery and product development. Prior to 2006, he consulted in data warehousing for clients in financial services, insurance, and health care. Ilker began his career 15 years ago as a database analyst.

Back to Top

Oracle Application Express (Oracle APEX) is a robust, scalable and secure web application development and deployment tool that takes full advantage of the Oracle database. So when Oracle decided to build a new online store, Oracle APEX was the perfect choice to get up and running quickly. This presentation provides an overview of the techniques and processes employed in the development of the Oracle Online Store user interface. The live demonstration will walk to audience step-by-step through the creation of a new user interface design using Photoshop, deriving HTML mockups from the Photoshop files and converting the static HTML files into XHTML-compliant Oracle APEX themes and CSS style sheets.

Marc Sewtz is a Software Development Manager for Oracle Application Express in the Database Tools Group, part of the Oracle Server Technologies Division. Marc has over 15 years of industry experience, including roles in Consulting, Sales and Development and joined Oracle in 1998. Marc manages a global team of Oracle Application Express developers and product managers and is responsible for Oracle Application Express product features such as Oracle Forms to Oracle Application Express conversion, the Oracle Application Express Reporting Engine, Tabular Forms, PDF printing and the integration with Oracle BI Publisher. Marc has a Masters degree in Computer Science from the University of Applied Sciences in Wedel, Germany.

Back to Top

You need a VARCHAR2 field to hold data for a variety of purposes, e.g., for an extract, summary or generic view, perhaps as a base for a report or a foreign data import. How do you figure out an optimum length for that field/column, as well as determine how much data you can stuff into it? Unlike MS Excel/Access, table columns cannot "expand" (no matter the software, there are limits). How do you determine an optimum length for a field / column? How do you handle any exceptions? This presentation provides examples and ideas using statistical "analysis of variance" (ANOVA) principles to answer these questions.

Suzanne Michelle has been working with databases, database structures, and system interfaces since 1981 when she taught her MBA fellows how to use VisiCalc. She created her first relational system with Lotus123 in 1986 that fit on a floppy. Suzanne now works for NYC Transit where she created (in 1995) and still manages (and finds challenging) the "Unified General Order System" by which NYC Subways plans and manages track access work. Subway riders see the tip of the planning iceberg via Service Change signs fed by the Oracle 10g database (with a Forms6i front end) that Ms. Michelle and her colleagues design and support.

Back to Top

March 2009 General Meeting

• Opening:

  • Click to hear the President's opening remarks: March 2009 Opening Remarks

  • Opening Presentation
     

• Keynote

• DBA Track

• Development Track

Click to hear the Keynote: March 2009 Keynote

This presentation will look at which 11g new features should be investigated for use. There will be simple examples to show the basic functionality of the following new features:

• Memory Target
• Partition Advisor
• Security Enhancements
• DDL Lock Timeout
• The Invisible Index
• Automatic Diagnostics Repository
• SQL Plan Management
• Real Application Testing (Workload Capture and Replay)
• SQL Repair Advisor
• ADDM Enhancements • Interval Partitioning
• Optimizer Enhancements

Richard J. Niemiec
In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master , one of the first six so recognized around the world. In 2007, Rich authored Oracle10g Performance Tuning Tips & Techniques, a follow-up to Oracle9i Performance Tuning Tips & Techniques that he wrote four years earlier. Rich is former president of the International Oracle Users Group and currently serves as vice president for its Real Application Clusters special interest group. In addition, Rich is the current president of the Midwest Oracle Users Group. He previously was the executive editor of Exploring Oracle DBMS magazine and editor of the MOUG Newsletter. Rich has delivered hundreds of lectures about Oracle technology to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has also conducted numerous expert class presentations at OracOpenWorld and other major shows.

Back to Top

DBA TRACK: Tuning the Oracle Grid

This presentation will discuss the top ten tips when tuning your architecture for grid computing. Oracle has come a long way from when clustering was introduced. The tools continue to improve and the installation continues to get better and easier. This presentation will show many Grid Control screen shots so attendees can see the depth of the product. Topics to be covered are:

1. Know the basics; Introduction to RAC

2. Oracle Direction

3. Market direction - Consolidation

4. Grid Basics - Start with RAC

5. Grid Basics - Scaling it

6. Interconnect and block coordination

7. Tuning quick tips using Statspack & AWR Report

8. Use Grid Control to monitor

9. Grid Control for Multi-Node Systems

10. Use Grid Control to tune systems

See bio for Rich Niemiec above.

Back to Top

DBA TRACK: Honey, I Shrunk the Data Warehouse!

This presentation will examine use of the Oracle Database compression features to help shrink the size of data warehouses. Shyam will discuss SecureFiles used to reduce the storage needs for unstructured data. To complete the full solution, it is necessary to compress the metadata, dump files during the export using the Data Pump, and backup files. The last piece of the puzzle is the compression of data in motion over the network such as the redo logs. Some live examples and a case study of quantitative benefits on the compressed data alongside the uncompressed data will be shown. Examples of table/partitions, materialized view, and index compression will also be discussed along with the impact of compression on regulatory compliance and how this can help to achieve the industry-specific goals of increased retention of data in a tamper-proof environment.
 
Shyam Varan Nath is an Oracle BIDW professional with over 18 years of industry experience. Shyam is a part of Deloitte’s BI practice and formerly worked for Oracle Corporation’s BI consulting practice. Shyam is the founder of the BIWA SIG and is a regular speaker at NYOUG, Oracle OpenWorld, IOUG Collaborate, BIWA, ODTUG, and other regional user groups. He is a Certified DBA with hands-on experience in Data Warehouse architecture, OBIEE implementations, database tuining and optimization. He has worked on large data warehouse implementation projects. Shyam was awarded the Oracle IOUG Contribution Award in 2007.

Back to Top

DBA TRACK: Tuna Helper - Proven Process for Tuning SQL

Many DBAs and developers are faced with tuning poorly performing SQL statements. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: indexing strategies, use of histograms, SQL wait event data, column selectivity and several more that will help you succeed on future tuning projects.

Dean Richards has over 20 years of Oracle project development, implementation and strategic database architecting experience. Before coming to Confio, Dean held engineering positions at McDonnell Douglas and Daugherty Systems - an Oracle solution provider. Dean was also a technical director for Oracle Corporation managing all aspects of key telecommunications accounts including short and long-term technical planning and strategic alliances. As a highly successful liaison between management and technical staff, Dean has proven to be an effective collaborator implementing cutting-edge Oracle solutions.

Back to Top

DBA TRACK: Advanced Performance Diagnostics: What the GUI Doesn’t Show You

The presentation will review "Performance Methodology", "Review - AWR versus ASH", a few interesting reports, mining your data and a Case Study. Using Enterprise Manager it will be shown how to tune your system for a given workload, identify operations consuming most DB Time, identify resource/capacity related bottlenecks and how to reduce “DB Time” consumed for the workload.

Nicholas J. Donatone is a Grid Sales Consultant for Oracle Corporation. Nick has been working with Oracle software since version 4 (1986). Nick is one of the founders of the NJOUG and was president/co president of the NJOUG for more than 18 years. He is Vice President of the Philadelphia Area Oracle User Group (PHLOUG). Nick has presented at NYOUG, NJOUG, IOUG, ODTUG, SEOUC and Oracle OpenWorld.

Back to Top

Oracle’s free developer tools, SQL Developer and Application Express (APEX) can provide Oracle Applications developers with quick and easy reports designed for multiple platforms and multiple audiences. This presentation will show how to successfully build a free APEX-based, fast, and effective reporting environment and how to make reports BlackBerry accessible. Attendees will learn how develop sophisticated multi-platform (Web and BlackBerry) reports using Application Express and SQL Developer against an Oracle Apps 11.5.10 environment.

Brian Caunitz has been working with Oracle Applications for the last ten years as a DBA/Developer at Oracle Consulting, UPS and most recently, illy caffè North America. He has a B.S. in Computer Science from Siena College

Back to Top

DEVELOPER TRACK: Oracle Fusion Middleware - Tales from the Trenches

The Oracle Fusion Technology stack is large and complex, encompassing many components. Some parts are free or nearly so such as JDeveloper, whereas other portions carry large licensing fees (WebCenter). What portions of the Fusion Middleware stack are organizations really using? How have their projects fared so far? This presentation will discuss the results of a number of projects from organizations that are using one or more parts of the Fusion Middleware technology stack. This presentation describes the results of a semi-formal survey where I interviewed some of the leading Fusion Middleware developers and ask them about their projects. Since the results are anonymous, the appraisals of the technology are candid.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul has co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle ACE Director, SELECT Associate Editor, ODTUG Symposium chairperson, past IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year. Paul can be contacted at paul_dorsey@dulcian.com

Back to Top

As important as it is, security is almost always added to an application as a last step, if at all. Designing your APEX application with security in mind is critical and should not be overlooked. This session will discuss how to build secure APEX applications from the ground up so that a hacker cannot exploit them. Josh will also discuss how to segment functionality inside of an APEX application so that only authorized users can perform specific tasks. The presentation includes information about what can be done to secure the underlying data of an APEX application and outline a list of things that need to be secured in an installation of APEX, as well as the associated infrastructure components.

Josh Millinger is the President of Niantic Systems, LLC which he co-founded with Raj Mattamal in 2007. Josh focuses on delivering complex APEX applications to customers across verticals in the Higher Education, Healthcare and Commercial arenas He has Computer Science degrees from UW-Madison and Johns Hopkins University.

Back to Top

Many times during a project life cycle, new technology is introduced that presents first time challenges. This presentation includes information about a project using Oracle 10g XML DB. The presentation will discuss why XML DB was chosen, how XML DB was used and technical issues encountered. Coleman will provide several examples using XMLTYPE, CLOBs, XML DB methods, XMLAGG, XMLELEMENT and XMLFOREST. Additionally, namespace examples and an introduction to XML Schema Definition (XSD) will be presented.

Coleman Leviter is an IT Software Systems Engineer at Arrow Electronics. He has presented at IOUG's Collaborate 07 and 08. He is the NYOUG Web SIG chair and sits on the Steering Committee. He has worked in the financial services and aerospace industries where he developed Navigation, Flight Control and Reconnaissance software for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester Institute of Technology, an MBA from C.W. Post and an MSCS from New York Institute of Technology. He has recently completed OCP (Oracle Certified Professional) training. He can be contacted at cleviter@ieee.org

Back to Top

December 2008 General Meeting

• Keynote

• DBA Track

• Development Track

We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. In this keynote presentation, Steven will offer an intensive coding therapy session to help all attendees come to grips with their innate, unavoidable "issues," making it easier to write better code -- and help others on their team write better code.

Steven Feuerstein, one of the world's leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 15 years and serves as PL/SQL Evangelist for Quest Software.

Back to Top

This presentation discusses the standard and custom settings to size the Large Pool in conjunction with desirable outcome affecting backup size and duration. The speaker discusses a comparison between Oracle recommended values for the Large Pool and the specific effect of sizing the Large Pool with different values, and the outcome affecting the size of backup pieces, overall backup size, and overall backup and restore turnaround time. Several case studies will be included.

Anthony D. Noriega is a computational scientist and IT Consultant, OCP instructor, and Adjunct Professor, who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN/ebPortal, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony holds an MS Computer Science from NJIT, where he was also a doctoral candidate in the same field, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a Sr. consultant for Oracle University, IBM, AT&T, Bowne, Canon, Time, and Deutsche Bank.

Back to Top

DBA TRACK: Oracle Exadata - Extreme Performance

Data warehouses are tripling in size every two years and supporting ever-larger databases with ever increasing demands from business users to get “answers” faster requires a new way to approach this challenge. Exadata is the new hardware/software solution from Oracle targeted primarily at the data warehousing market. Oracle Exadata overcomes the limitations of conventional storage by utilizing a massively parallel architecture to dramatically increase data bandwidth between database and storage servers. This session will examine these limitations and demonstrate how Oracle Exadata delivers extremely fast and completely scalable, enterprise-ready systems.

Graham Wood is an architect in RDBMS Product Development at Oracle in Redwood Shores. After working in performance related areas for many years creating Statspack, ADDM, AWR amd ASH, Graham now works in the RDBMS Product Management group.

Back to Top

DBA TRACK: Take the Guesswork out of SQL Performance with SPA

Businesses want systems that are predictable, performant, and meet service-level agreements. However, SQL performance regression is the key cause of poor and unpredictable database performance. In this session, we will describe how you can demystify the working of the Oracle query optimizer and eliminate the unpredictability in SQL performance by using SQL Performance Analyzer (SPA), a feature of Oracle Database 10g and 11g. We will discuss the internals of SPA as well as best practices for its usage.

Mughees Minhas is responsible for the self-managing solutions of the Oracle Database with special interest in areas such as performance diagnostics, SQL optimization and tuning, space management and load testing. He has more than 12 years of experience working with Oracle databases and is currently director of product management in Oracle’s Server Technologies division.

Back to Top

DBA TRACK: Faster Cross-Platform Database Migration with RMAN

You can always move a database from one operating system to another with DATAPUMP or EXPORT and IMPORT, but these methods are time consuming. You can reduce the time needed to convert the datafiles by up to 88% or more when you use RMAN to parallelize the datafile conversions. There are some challenges with some versions of Oracle, but there are ways around these issues. Based on Oracle documentation, you might even get away with converting only a fraction of all the datafiles in the database. Attendees will learn some basics about RMAN, understand cross-platform migration issues, and learn to be flexible with Oracle tools.

John Larkin has worked as a DBA for the last 23 years, the last 15 with Oracle. He works for a major financial services company in Delaware and is currently working on a project to migrate 30 databases from AIX to a Veritas-clustered Solaris environment.

Back to Top

DEVELOPER TRACK: Automated Testing Options for Oracle PL/SQL

We all know we should test our code more thoroughly, but who has the time and patience, and isn't our code "good enough" anyway? Did you know that that is widely accepted that if you have a program of 500 lines, you should expect to write 5000 lines of test code? Ah, so that's why we don't test our code! If you are not satisfied with the number of bugs in your code or if you sometimes find yourself embarrassed demonstrating your software to users, then attend this session to learn how you can automate the testing process, reduce bugs in your code, and increase confidence in your applications. This session reviews the tools, from open source to commercial, that offer varying levels of testing automation.

Steven Feuerstein, one of the world's leading experts in the Oracle PL/SQL language, has studied PL/SQL for over 15 years and serves as PL/SQL Evangelist for Quest Software.

Back to Top

DEVELOPER TRACK: Introduction to Java - PL/SQL Developers Take Heart

If you know PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. It provides an overview of the language; reviews the concepts of object orientation; and describes the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 24 years of industry experience. Peter has presented at various Oracle users group conferences more than 230 times and has won numerous user group awards He is an Oracle Certified Master, Oracle Fusion ACE Director, and coauthor with Dr. Paul Dorsey, Avrom Roy-Faderman, and Duncan Mills of seven Oracle Press Books about Oracle development tools.

Back to Top

DEVELOPER TRACK: Advanced Report Printing with Oracle APEX

This session will provide an overview of the printing capabilities built into Oracle Application Express (APEX), discuss some of the printing enhancements introduced in APEX 3.1 and include a live demonstration of how to create custom RTF report templates. The presentation will also show charts and images and utilize the print API for scheduled generation and emailing of reports.

Marc Sewtz is a Software Development Manager for Oracle Application Express (APEX) in the Oracle Database Tools Group and is based on New York City. Marc manages a global team of APEX developers and product managers and is responsible for APEX product features such as Oracle Forms to APEX conversion, the APEX reporting engine, tabular forms, PDF printing and the integration with Oracle BI Publisher.

Back to Top

DEVELOPER TRACK: Forms Roadmap for Traditional Developers

This presentation discusses the evolution of Forms to meet the demands of customers and, in particular, for Forms to successfully integrate and join with the arrival of Web-based applications. Oracle has an updated plan (just released, October 2008) to integrate Forms into Web application architecture. Attendees of this presentation will get the most clear statement to-date of this plan. The extraordinary benefits of using an upgraded Forms deployment in a Service Oriented Architecture are the drivers behind the Oracle "Upgrade and Integrate" strategy for existing Forms deployments. The Oracle Application Server is highlighted as the central product platform chosen by Oracle as part of their strategy to unify Forms with newer Web-based services and SOA.

Gil Standen is Managing Partner of Stillman Real Consulting LLC, and more recently, joined the company founded in 1988 by Rich Niemiec, Joe Trezzo and Brad Brown, the well-known TUSC, in Chicago, where he has been a Senior Consultant for the past year. The author has supported a wide range of Oracle RDBMS and application products as a result of his wide-ranging consulting support of Fortune 50, government, and startup clients for many years. Gil has presented at local and national venues including several NYOUG general meetings and at the Australian National Conferences "Oracle with 20:20 Foresight" in both 2005 and 2007.

Back to Top

September 2008 General Meeting
NYC Metro Area User Group Meeting

• Opening Slides

• Keynote

• DBA Track

• Development Track

The technical decisions we make are based on things we know. But how did we get to know what we know in the first place? Did we learn it from trusted advisors? Technical forums? Experience? Word of mouth from peers? More importantly, how does the way we learned what we know affect the decisions we make every day? This presentation attempts to answer these questions.

Tom Kyte is a Senior Technical Architect in Oracle’s Server Technology Division. Before starting at Oracle, Kyte worked as a systems integrator building large-scale, heterogeneous databases and applications, mostly for military and government customers. Kyte spends a great deal of time working with the Oracle database and, more specifically, working with people who are working with the Oracle database. In addition, Kyte is the Tom behind the AskTom column in Oracle Magazine, answering people's questions about the Oracle database and its tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004), Beginning Oracle Programming (Wrox press, 2002/Apress 2004), and Effective Oracle by Design (Oracle Press, 2003). These are books about the general use of the database and how to develop successful Oracle applications.

Back to Top

A lot of time is spent by IT professionals studying best practices in the industry. This presentation turns that around and takes a look at some "worst practices," or the top things you can do to ensure failure, delays, and poor performance in your database applications. Instead of focusing on things to do in your database applications, the presentation looks at things you should never do. The presentation uses actual customer experiences to investigate the top 10 things done wrong over and over again, and how to avoid making the same mistakes yourself.

Tom Kyte is a Vice President in Oracle's Public Sector division (see full bio above)

Back to Top

Storage design and configuration in Oracle RAC environments are consistently the most challenging components in an Oracle RAC rollout. Attendees will learn about core storage concepts, how they apply in RAC environments, RAC-specific technologies, performance and availability considerations including examples of how real-world environments are leveraging them. The goal is to provide DBAs with enough information to make informed decisions to plan for storage in RAC environments, while providing a strong platform to continue learning on their own through experimentation.

Matthew Zito is an expert in large-scale infrastructures, with extensive experience in designing and deploying some of the world's largest system, network, and application architectures. Before joining GridApp, he worked at EMC, where he designed and implemented a variety of storage infrastructures. Prior to joining EMC, Zito served as Infrastructure Architect at Register.com, where he pioneered the use of centralized management and automation.

Back to Top

So you have heard about partitioning but don't know where to start, or you are familiar with it, but want to double check your design. In this session, Arup will explain when to partition tables and indexes, which partitioning options to choose depending upon the problem you are trying to solve (purge, performance, archival, backup, etc.), potential issues to watch out for, and so on. This presentation will NOT describe the syntax and commands for partitioning, but rather discuss how to decide which partitioning scheme to choose. The presentation also includes information about Oracle 11g.

Arup Nanda has been an Oracle DBA for more than 14 years. He is the lead global DBA at Starwood Hotels. An author of many articles and four books, he was awarded the Oracle DBA of the Year distinction in 2003.

Back to Top

This presentation discusses and demonstrates the methods for passively capturing, analyzing, and reporting the details of Oracle network traffic in real-time for use in end-to-end Oracle tuning and troubleshooting scenarios. At the end of this session, participants will gain a better understanding of the Oracle Network Protocol, learn how to detect network-related issues and be able to diagnose and solve network-related issues

Having administered, developed against, and consulted on all versions of Oracle since version 7, Jonah Harris has spent a considerable amount of time specializing in OCI, performance tuning, and researching Oracle Internals. When time permits, he provides support to the Database, Call Interface, Instant Client, ODBC, PHP, Linux, SQL, and PL/SQL community forums on OTN.

Back to Top

Attendees will gain insight into what is important to keep their database(s) up and running. Many errors encountered do not affect service; the trick is to pay close attention to a handful of issues that could affect database availability. This presentation focuses on a small set of errors that, if not trapped, can lead to application outages. Initiating a database connection, with/without SQL*Net, and aggressive detection of looming space deficiencies are at the heart of smart database monitoring. Michael’s mantra of paging the DBA is simple: “If it cannot and need not be fixed at 3AM, why would/should anyone be paged?”

Michael Abbey is a recognized authority on database administration, installation, application migration, performance tuning, and implementation. Working with Ian Abramson and Michael Corey, he has co-authored 16 books for McGraw-Hill's Oracle Press Series, including most recently: Oracle Database 11g: A Beginner's Guide. Active in the international Oracle user community, Michael is a frequent presenter and keynote at many user group events.

Back to Top

Oracle Database 10gR2 has continued to expand upon its extensive table partitioning capabilities, providing an arsenal of weapons targeting Very Large Data Warehouse (VLDW) environments. Major partitioning schemes such as Range, Hash, and List have provided architects of very large databases with the tools to effectively reduce search space size against large fact tables. In addition, indexing techniques such as bitmap partitioning (bitmap and btree), bitmap-join, and function-based, provide the ability to address high cardinality plans written against large fact tables with precise lookups. However, even with these robust capabilities, the problems of vulnerability for the very large data warehouse query space persist. This presentation will describe a method for eliminating this vulnerability using the technique of Virtual Partitioning.

Brian Dougherty is Chief Architect of Business Intelligence for CMA Consulting. He was lead architect for the 1999 Data Warehouse Institute's Best Practice award winner in the Very Large Data Warehouse Category. His solutions have been nominated or selected for various other national awards in the Oracle and Data Warehousing fields.

Back to Top

This presentation demonstrates techniques to analyze Automatic Workload Repository (AWR), and by extension, Statspack, reports to find problem areas, isolate bad SQL, and determine system memory settings. Using AWR data for trending will also be discussed. The use of wait time analysis, I/O timing analysis and memory trending will be shown using actual client AWR reports (names changed to protect the innocent).

Mike Ault has been working with Oracle since 1990 as a DBA, developer and manager. Mike is a frequent presenter at conferences at all levels and has written many Oracle books, articles and webcasts. Mike works as the Oracle Guru for Texas Memory Systems.

Back to Top

Threat trend data clearly shows an increase in breaches focusing on confidential information. The Information Security industry has now acknowledged that the enterprise perimeter is easily penetrable. Data leakage from structured and unstructured sources is a major pain point for organizations. A successful information protection strategy requires building layered controls, starting from the inside, closest to the data and must include compliance to baseline configuration, aggregated and correlated event monitoring from host, databases, network, and applications. This presentation explains the key challenges of database security and offers a pathway for establishing a strong strategy for accomplishing comprehensive database security.

Ajoy Kumar is a Security Manager at DTCC and has a deep interest in database and application security issues. He was a DBA for over 13 years prior to moving into the Information Security area.

Back to Top

This presentation demonstrates the highly-automated process of creating RIA using several Eclipse plug-ins. The first plug-in generates a CRUD application with Adobe Flex talking to POJO on the server, which in turn communicates with a DBMS. A second plug-in generates an ANT build script for this application. The third plug-in adds logging capabilities. Finally, Yakov will create and customize a fancy report based on the retrieved data. He will annoy you with not more than five PowerPoint slides and spend the rest of this presentation developing the application described above.

Yakov Fain is a managing principal of Farata Systems, a consulting, training, and product company. He has authored several Java books and dozens of technical articles including “Rich Internet Applications with Adobe Flex and Java: Secrets of the Masters.” Yakov was nominated for and awarded the Sun Microsystems title “Java Champion.” He also leads the Princeton Java Users Group.

Back to Top

Traditional perimeter network security is not sufficient to defend against dynamic threats to applications already residing on enterprise systems and accessible over the Internet. Web-accessed databases are especially susceptible, partially because of the appeal of their lucrative repositories of customer and sales data, and partially because IP entry affords hackers a broader range of methods with which to invade and gain access to database information. This presentation describes some of the sophisticated methods used in invading enterprise databases and proposes essential steps IT managers can take to securely install and configure databases to guard against malicious breaches. The session will also provide guidelines and best practices on how businesses can secure databases against unauthorized access.

Aaron Ingram is the author of Practical Oracle Security: Your Unauthorized Guide to Relational Database Security. He has fifteen years experience developing enterprise software, focusing on database systems and security applications. Most recently, Aaron merged his extensive database background with his security skills to manage the development of Application Security's real-time database intrusion detection and security auditing solution, AppRadar.

Back to Top

Sluggish web pages with poor refresh rates have become the new “industry standard.” Well designed web applications can provide performance that is just as fast as their older client/server counterparts, but this requires a rethinking of application tuning strategies. Poorly performing web applications are rarely or only marginally improved by tweaking the database and tuning the SQL statements. Instead, the focus of tuning activities must shift to minimizing data transmission from the application server to the database and from the database to the client. Both the amount of data transferred and the number of roundtrips must be minimized. This presentation will discuss techniques that can be used to identify and resolve many common performance issues that arise when developing web applications.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development and chief architect of Dulcian's BRIM® tool. Paul co-authored 7 Oracle Press books on JDeveloper, UML Modeling, and Oracle database tools as well as PL/SQL For Dummies. He is an Oracle ACE Director, SELECT Associate Editor, ODTUG Symposium chairperson, past IOUG and ODTUG volunteer of the year, ODTUG 2007 Speaker of the Year (Topic & Content) and an Oracle 9i Certified Master. Dr. Dorsey's submission of a Survey Generator built to collect data for The Preeclampsia Foundation was the winner of the 2007 Oracle Fusion Middleware Developer Challenge and Oracle selected him as the 2007 PL/SQL Developer of the Year.

Michael Rosenblum is a Development DBA at Dulcian, Inc. He is responsible for system tuning and application architecture. He supports Dulcian developers by writing complex PL/SQL routines and researching new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press, 2006). Michael is a frequent presenter at various regional and national Oracle user group conferences. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics.

Back to Top

This presentation includes an end-to-end case study of Business Intelligence using the Oracle BIWA technology stack. It describes how a quick implementation can be done in a retail setting using Oracle components like OWB, Oracle Data Warehouse, OLAP, Data Mining and OBIEE in combination with Retail Industry Reference Data Model. Such BI accelerators allow faster implementations with reduced risk for the companies. This presentation discusses each of the technology layers and how it integrates with the other layers including a peek into the underlying data model, analytical model, and the workings of the advanced analytics that empower the end-user experience. The presentation will showcase all of the components in a demo to present the end-to-end solution stack.

Shyam Varan Nath is a hands-on DBA and Data Warehouse Architect, with over 17 years of experience. He has been an OCP since 1998 on 4 different Oracle RDBMS releases. He is President and Founder of the Oracle BIWA SIG (http://OracleBIWA.org) and winner of the Oracle Contribution Award 2007. Shyam was part of Oracle's BI and Advanced Analytics practice and now is a consulting Manager at Deloitte Consulting.

Forrest Snowden is a Sr. Mgr. at Deloitte Consulting with over 20 years of DW/BI experience. He specializes in high-level EDW architectures; defining client roadmaps; data encryption/fraud, BI Governance and data validation. Forrest won the 2002 NACHA Award for best design of an ACH system and led the design of the United Way of NYC Sept. 11 Website which processed over 500 payment transactions/sec collecting over $100MM in donations on a pro bono basis.

Back to Top

Debugging Application Express can be a conundrum. It's PL/SQL, but you can't step through it. View Source doesn't cover it. How does one know what is happening when, with what? This session will demonstrate a few options for tracking down APEX issues: APEX-supplied views and reports, the APEX debug session information, the Web Developer Toolkit, an overview of JavaScript debuggers, and remote debugging using SQL Developer to help resolve most APEX debug challenges.

Karen Cannell is a Principal with Integra Technology Consulting and editor of the ODTUG Technical Journal. She has analyzed, designed developed, converted, enhanced and otherwise tweaked database applications for over 22 years, focused on Oracle since 1994. Recent focus includes design and development of ETL processes, Application Express, Oracle Business Intelligence and migration of legacy applications to web technologies, leveraging the Oracle 10g/11g suite of tools.

Back to Top

This presentation will discuss the value difference between comparative infrastructures for Oracle solutions. Attendees will learn about "best practices" for sizing and implementing an advanced I/T Infrastructure for Business Intelligence and Data Warehousing Solutions with Oracle Database 11g.

Rick Kearns is a Solutions Consultant for IBM Systems and specializes in I/T infrastructure optimization for Oracle Solutions. With a long history at IBM, he has worked with hundreds of Oracle clients across North America to select and design infrastructures for Oracle projects.

Anirban Chatterjee is an IT Specialist at the IBM Executive Briefing Center in Austin, Texas. His primary role is to create and provide demonstrations of strategic POWER and AIX technologies to customers, industry analysts, press, and investors, both within the Center and around the country. Prior to his current assignment, Anirban developed firmware for IBM's POWER-based servers.

Back to Top

Attendees will learn how to create collections in Oracle, and how to use/interact with them in PL/SQL, SQL, Java and .Net. The presentation will include practical advice about when (and when not) to use this functionality. Debugging hints, a comparison of the solution discussed with a more traditional database implementation and the impacts on the database will also be discussed.

Travis Rogers is a Senior VP of Database Development for CDG Management LLC with over 15 years of software development experience including 10 years of Oracle development. He presented on Analytics at the NYOUG 2007 Winter General meeting.

Back to Top

Oracle Forms was. and still is. a very popular development tool, but many organizations are looking to modernize to a purely Web-based solution. Oracle Application Express, with its similar declarative nature and use of SQL and PL/SQL, has become a popular technology for Oracle Forms modernization. This presentation demonstrates the latest Oracle Forms migration tool being built directly into Oracle Application Express. Starting with the Forms Builder (.fmb) files, converted into XML, this presentation shows how you can migrate your Oracle Forms applications to Oracle Application Express applications, and generate reports, forms, tabular forms, and master-detail pages.

Marc Sewtz is a Software Development Manager for Oracle Application Express (APEX) in the Oracle Database Tools Group and is based on New York City. Marc manages a global team of APEX developers and product managers and is responsible for product features such as Forms to APEX migration, the APEX Reporting engine, Tabular Forms, PDF printing and BI Publisher integration.

Back to Top

June 2008 General Meeting

• Keynote

• DBA Track

• Development Track

KEYNOTE: Oracle e SOA Suite 11g - A Foundation Building Block for Oracle's Next Generation Fusion Applications

This session provides an overview of the upcoming SOA Suite, and introduces the concepts behind it, such as Service Component Architecture and how it simplifies the end-to-end lifecycle management of SOA composite applications. Application designers can now design, package, version, and manage their SOA composite applications (Web services, BPEL, Enterprise Service Bus flows, and the like) as one single entity, making it easily available for reuse. This session will also discuss the challenges associated with data and component integration while building Fusion applications and explain concepts needed to get ready for Fusion.

Clemens Utschig works for the SOA Product Management team at Oracle Headquarters, CA. As a native Austrian, he started his career years back at the local consulting branch, helping customers define their next generation J2EE and SOA architectures. Later, he founded the local Java Community to spread knowledge and help consulting teams with the uptake of Java for new projects. During his consulting years, he spent a year in Switzerland doing crisis management for a large scale program, in Dubai helping on ADF BC issues for the government and giving workshops all around Europe. Since his transfer some 2 years ago into the Product Management group, Clemens is responsible for cross product integration and is now the advisor for SOA to Oracle Fusion Applications development, helping to build the next generation standard software suite. Clemens is also an advisory member of the Applications Architecture Board. He is a frequent speaker at worldwide conferences (Oracle Open World, JAX, OOP, ODTUG) and has published countless articles in known industry journals on SOA and related challenges.

Back to Top

DBAs are not responsible for just databases any more. Most DBAs are also responsible for the entire production application performance including the middle-tier. Often they are challenged with the performance problems caused by the Java middle-tier. DBAs do not have enough tools to gain visibility into the production applications to identify the root cause of performance problems. To resolve performance problems, they depend on developers and architects who reproduce and diagnose the problems in the development environment. Reproducing problems in non-production environments is difficult, time consuming and increases the problem resolution time drastically.
This session focuses on diagnosing application problems in production. It shows how to diagnose database problems caused by the middle-tier and how to perform expert level Java diagnostics without much Java or application knowledge.

Rajagopal Marripalli is a principal product manager in the Oracle Applications and Systems Management division. His primary focus has been in the area of application performance management. He has more than 12 years experience in the software industry in product development and product management. He has published papers and articles as well as presented technical seminars at conferences and user groups

Back to Top

This presentation will cover some of the less obvious issues that arise while using Dynamic SQL, including: defining required privileges, preventing code injections, targeting performance tuning efforts, understanding resource utilization, handling object dependencies, etc. Examples will demonstrate when, why, and how to use Dynamic SQL in real-world situations in conjunction with other advanced features such as objects, object collections, ref cursors, and bulk operations.

Michael Rosenblum is a Development DBA at Dulcian, Inc. He is responsible for system tuning and application architecture. He supports Dulcian developers by writing complex PL/SQL routines and researching new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press, 2006). Michael is a frequent presenter at various regional and national Oracle user group conferences. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics.

Back to Top

At my organization, we make extensive use of DataGuard, including an international implementation (between two of our European locations). This presentation will describe the practical use of DataGuard focused on the differences between DataGuard and Standby databases. Time permitting, the presentation will also include a discussion of Cold Failover Clusters (aka, "a poor-man's RAC").

Jonathan Intner has been working with Oracle for over 17 years and started in the dark days before the CREATE CONTROLFILE command -- even before there were tablespaces! He is not only an Oracle Certified Professional but also a Certified Information System Security Professional and (now) ITIL V3 Foundation Certified. He currently heads the US DBA Group for one of the top generic pharmaceutical companies.

Back to Top

Oracle Real User Experience Insight (UXInsight) enables enterprises to maximize the value of their business critical applications by delivering insight into real end user experiences. It can help identify lost revenue from frustrated users, reduce support costs by lowering call center volumes, accelerate problem resolution of poorly performing applications, and help businesses adapt to changing needs by providing insight into business trends and user preferences. This presentation will explain how to manage end users’ experiences with your applications, using Enterprise Manager products, identify performance issues with your applications, as well as identify missed revenue opportunities because of end user problems.

Nadu Bharadwaj is a Principal Product Manager in the Applications and Systems Management group at Oracle HQ, with over seven years at Oracle in various roles- from Consultant, DBA, Developer and presently as Product Manager. He specializes in the areas of SOA Management and User Experience Management. He has presented at several Oracle events representing the Enterprise Manager suite of products.

Back to Top

The iBATIS Data Mapper framework makes it easier to use a database with Java and .NET applications. iBATIS couples objects with stored procedures or SQL statements using an XML descriptor. Simplicity is the biggest advantage of the iBATIS Data Mapper over object relational mapping tools. This presentation discusses how to use iBATIS with Java in an Oracle environment. It discusses topics of interests to both Java and Oracle developers.

Richard Ji is a Senior Manager, database engineering from RealNetworks. He architected databases that handle over a billion transactions per day and 27TB in size. He is also a past presenter at NYOUG on "How to Build Your own Instantclient".

Back to Top

This presentation will introduce advanced concepts of the SOA platform, from transaction handling and fault policies to usage patterns of BPEL, ESB and the service registry. The goal is to provide attendees with a solid understanding of how the transaction model in BPEL works, and how it can best be leveraged. Clemens will show how the Service Registry can be used to dynamically discover and bind to services at runtime, rather than hard-wiring the service consumer with the provider. The presentation will also discuss common usage patterns for BPEL and ESB, which is a topic often requested by those new to the platform. Finally, Clemens will include an overview of what developers can expect from the upcoming 10.1.3.4 release, what features are recommended to use it efficiently, and its new diagnostic features.

Clemens Utschig works for the SOA Product Management team at Oracle Headquarters, CA. (see full bio above)

Back to Top

This presentation discusses the desupport of Oracle JInitiator in the context of the widespread deployment of JDeveloper. The presentation references several position papers from Oracle from the summer and fall of 2007 which describe the way in which Forms will participate in the BPEL-SOA landscape. Attendees will learn how to reconfigure forms to use the generic Sun JRE instead of JInitiator, and also will be presented with a comprehensive upgrade strategy designed to leverage their existing Forms environment through use of PL/SQL wrappers for Java and through forms which can register an interest in a BPEL event.

Gil Standen is the Founder and Managing Partner of Stillman Real Consulting. Gil more recently has joined Rich Niemiec's company, TUSC, in Chicago, IL as a Sr. Consultant. Gil has 12 years experience supporting large Oracle enterprise deployments on all flavors of UNIX, Windows, OS/390 and VAX/VMS and Novell OS platforms, including all versions of Oracle beginning with Oracle 7.1.3.2.3 through 10gR2.

Back to Top

Recent updates to the Federal Rules of Civil Procedure (FRCP) have placed an increased burden on IT organizations to produce data as part of a civil or criminal “e-discovery” request. If your company received an e-discovery request today, would your IT organization have the capability to retrieve the appropriate information and supporting evidence to comply? Would you be able to meet the timeframes dictated by law and civil procedure? With the rise of the “new data center” and “paperless” application environments, most corporate data is managed electronically. Improving the way in which you manage information and being prepared for e-discovery simply makes good business sense. This presentation provides an overview of the potential challenges that new eDiscovery rules and regulations could pose for them their IT organizations. It explores best practices to support data retention and ensure compliance requirements for accessibility and production of data within deadlines, and some case studies of how others have succeeded and failed in implementing them.

Eric Offenberg, CIPP and Product Marketing Manager at IBM, has established himself as a thought leader on data governance, database archiving, enterprise data management and data privacy. With nearly 10 years of technology marketing experience across industries, Eric is a regular speaker in live Webinars, industry events and with media and analysts on behalf of IBM. He holds an MBA with a concentration in marketing from Rider University and a BA degree in communications with a concentration in public relations from Rutgers University.

Back to Top

March 2008 General Meeting

• Keynote

• DBA Track

• Development Track

KEYNOTE: PL/SQL Enhancements in Oracle Database 11g

• Transparent and “knob-controlled” performance improvements;
• New language features that you use in your programs to get better performance;
• New language features that bring functionality which you earlier couldn’t achieve, or could achieve only with
cumbersome workarounds;
• New language features that improve the usability of programming in PL/SQL.

Bryn has made an unashamedly personal selection of some of these features to describe in fair detail in this
presentation. He used two criteria: his instinct-based ranking according to their relative importance for customers;
and his judgment of whether attendees might appreciate some background that they’re unlikely to find in other
accounts. For completeness, Bryn will finish by just listing the other features and giving a skeletal account of each.

Bryn Llewellyn is the PL/SQL Product Manager, Server Technologies Division, at Oracle HQ. He has worked in
the software field for 30 years. He joined Oracle UK in 1990 at the European Development Center in the Oracle
Designer Team. He transferred to the Oracle Text Team and then into Consulting as the Text specialist for Europe.
He relocated to Redwood Shores in 1996 to join the Oracle Text Technical Marketing Group. He has been the
Product Manager for PL/SQL since 2001. It’s hard for Bryn to remember his life before Oracle. He started off doing
image analysis and pattern recognition at Oxford University and then worked in Oslo, Norway, in the public sector
and in a startup. Bryn programmed in Simula (its inventors were his close colleagues). This language was the
inspiration for Smalltalk and C++.

Back to Top

DBA TRACK: The Secret to a Successful Upgrade: Using Database Replay to Guarantee Success

Extensive testing is usually performed to validate system changes such as database upgrades. However, unforeseen
problems such as performance regressions often occur when the production database is finally upgraded. This
presentation describes how you can significantly improve your chances of a successful upgrade by using Database
Replay, a new feature introduced in Oracle Database 11g. Mughees will describe, in detail, the internal architecture
of this feature, give practical examples of its usage, as well as discuss general best practices for using Database
Replay.

Mughees Minhas is responsible for the self-managing solutions of the Oracle Database with special interest in
areas such as performance diagnostics, SQL optimization and tuning, space management and load testing. He has
more than 12 years of experience working with Oracle databases and is currently director of product management
in Oracle’s Server Technologies division.

Back to Top

DBA TRACK: Overview of TimesTen

TimesTen is a very popular, fast-growing product in the Oracle suite. This presentation will walk through the
TimesTen feature set and discuss the path to implementation. Shig will cover the cover the product features,
function, and implementation required for TimesTen as well as discuss success stores and case studies.

Shig Hiura is a Senior Sales Consultant with Oracle in the Embedded Global Business unit, serving embedded and
ISV partners who want to leverage Oracle technologies in their solutions. He has over 15 years of experience in the
IT industry and has worked with the Oracle database since version 7. Much of his experience includes work in the
Financial Services sector and work with Fortune 500 companies.

DBA TRACK: DUDE, Where’s my Data?

It's a DBA's worst nightmare--the loss of data. Sure, your backup scripts were well-tested and had some real cool
exception handlers in them. But now the time has come to recover your data, and guess what? Those exception
handlers weren't so cool after all. Datafiles are missing, you're missing archives, and hey, where did that system
tablespace go anyway? This presentation describes several real life situations where Oracle database recoveries
went terribly wrong, resulting in a situation where using a data unloader was the only option left to extract data.
The second part of the presentation provides an overview of how data unloaders work. By briefly looking at the
block internals, it will show you how data can still be recovered, even when the system is gone or the database can't
be opened. The data unloader “DUDE” is used as a case study.

Having administered, developed against, and consulted on all versions of Oracle since version 7, Jonah Harris has
spent a considerable amount of time specializing in OCI, performance tuning, and researching Oracle Internals.
When time permits, he provides support to the Database, Call Interface, Instant Client, ODBC, PHP, Linux, SQL,
and PL/SQL community forums on OTN.

DBA TRACK: Protect Privacy with Data Masking

The Data Masking Pack for Databases helps organizations share production data in compliance with privacy and
confidentiality policies by replacing sensitive data with realistic but scrubbed data based on masking rules. This
presentation discusses the two primary use cases for the Data Masking Pack:
1. DBAs want to take a copy of production for testing purposes and use the Data Masking Pack to replace all
sensitive data with innocuous but realistic information and then make this database available to developers.
2. Organizations want to share production data with 3rd parties.
This presentation will include a demo to show how to Mask data and maintain referential integrity.

Nicholas J. Donatone is a Grid Sales Consultant for Oracle Corporation. Nick has been working with Oracle
software since version 4 (1986). Nick is one of the founders of the New Jersey Oracle Users Group (NJOUG) and
was president/co president of the NJOUG for more than 18 years. He is Vice President of the Philadelphia Area
Oracle User Group (PHLOUG). Nick has made presentations at NYOUG, NJOUG, IOUG, ODTUG, SEOUG and
Oracle OpenWorld.

DEVELOPER TRACK: Doing SQL from PL/SQL: Best and Worst Practices

The PL/SQL developer has many constructs for executing SQL statements, and the space of possibilities has
several dimensions: embedded SQL versus native dynamic SQL versus the DBMS_Sql API; bulk versus non-bulk;
implicit cursor versus parameterized explicit cursor versus ref cursor; and so on. Deciding which to use might seem
daunting. Moreover, as new variants have been introduced, older ones sometimes have ceased to be the optimal
choice. Oracle Database 11g has kept up the tradition by bringing some improvements in the area of dynamic
SQL.This presentation examines and categorizes the use cases for doing SQL from PL/SQL, takes the Oracle
Database 11g viewpoint, and explains the optimal approach for the task at hand.

Bryn Llewellyn is the PL/SQL Product Manager, Server Technologies Division, at Oracle HQ. (See full bio above)

DEVELOPER TRACK: Forms to Fusion

This presentation reviews the current Forms landscape and options Forms users have in regard to their existing
investment. Ernst will review when to upgrade or convert, what role ADF plays in Forms applications, and what
technologies will come into play in an SOA environment. This presentation will also discuss how to understand your
current state environment and map it to a practical, workable, future state. This session will provide insight into
making thoughtful decisions regarding the advancement of a Forms application.

Ernst Renner is CEO of Vgo Software, a leader in the modernization of client/server applications. In addition to
leading Vgo, Ernst is managing partner at NEOS, a services company he started in 2000, specializing in enterprise and
information architecture services. He brings over 15 years of high-technology experience to the table in database and application technologies.

DEVELOPER TRACK: Value of Embedding Oracle Technologies

95% of Oracle user do not know that they could potentially embed Oracle technologies saving them money and
implementation effort. Participants will learn the value of embedding, how to embed, and which Oracle products are
“embeddable.” Mel will cover the basics of embedding and the implementation required. The presentation will
include descriptions of case studies and success stories.

Shig Hiura is a Senior Sales Consultant with Oracle in the Embedded Global Business unit. (See full bio above)

DEVELOPER TRACK: Two 30-minute presentations

A. Oracle Instant Client for Windows
Oracle Instant Client allows you to run your applications without installing the standard Oracle client, while using
significantly less disk space than before. Even SQL*Plus and ODBC can be used with Instant Client. This
presentation demonstrates the easiest way to connect to a remote Oracle database, requiring light installation of small
libraries on Windows using Oracle Instant Client on Windows XP.
Eunhee Lee is a Senior Database Architect at ReturnPath Inc. in New York City with over 10 years of Oracle
Database and software development experience. She earned her Master's Degree in Computer Science and
Engineering at HongIk University, South Korea and New York University.

B. Consensus and the Collaboration Method
Accessing data is a core aspect of any n-tier software system. From a traditional software development lifecycle
point of view, there are three popular ways in which the application developer works with the emerging
schema/database:
1. The Developer may have carte blanche to dictate the type of tables/views to be built and/or accessed.
2. The database tables/views have already been fully implemented via the Data Architect and the DBA. Therefore,
the developer must do his or her best to work with what has been put into place.
3. Collaboration and consensus between the Application Developer(s), the DBA and the Data Architect, working
together towards a common goal.

This presentation discusses the risks and rewards of using the different methodologies. Ultimately, the findings
substantiate the claim that using the Collaboration/Consensus method produces the most benefits.

Joshua Feinstein-Plummer is a Data Systems Architect at Standard and Poor's. He has over 10 years of practical
experience in financial information systems and currently serves as a member of the S&P Technical Architecture
Group. He lives in Brooklyn with his wife, Eva-Maria C. Plummer.

December 2007 General Meeting

• Keynote

• DBA Track

• Development Track

• UCM Track

What with new-fangled this and new-fangled that, many of the issues that surfaced 20-25 years ago were supposed to "disappear" with the influx of new more powerful hardware and more database self-management techniques. The major players in the database arena are proud of the advancements they have made in the throughput of query processing. Whether companies go the "open source" MySQL route, or choose a more industrial strength vendor such as Oracle, so many problems that surface are reminiscent of the 80's and, in many cases, have little or nothing to do with the software.

IT management and the "human factor" are still the major dictators, influencing what works and what does not. Management decisions made 20 years ago still affect what's going on today. Once vendors get their claws into corporate IT infrastructures, companies are stuck with what they have in order to protect their investments and product knowledge gleaned from years of product use.

This presentation will discuss database management in the first decade of the 21st century, and offer some suggestions about what may be the "best" route to take. As the baby-boomers approach retirement, this may be the only chance we have to turn things around and not keep repeating the mistakes that we made in the 80's.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 14 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of events for and serves on the board of directors of the Independent Oracle Users Group (IOUG). He is a frequent speaker and keynoter at user group and vendor conferences and has appeared at such events as IOUG Live!, COLLABORATE, Oracle Open World, the European Oracle User Forum, and UK Oracle User Forum.

Back to Top

System Administrators have to manage a larger number of critical systems and deliver a higher quality of service. At the same time, decision-makers require more insight into business agility in order to meet service performance goals. This presentation will show how to automate your IT systems to improve quality of service and lower data center management costs. Learn how Oracle Enterprise Manager manages IT services and the system infrastructure in Grid computing and service-oriented environments, thereby reducing costs and risks, maximizing productivity, and aligning your IT objectives with your business.

Sandra Cheevers has been with Oracle for over 18 years, and has worked in Customer Support, Customer Education and Product Management. She handles product management in the development organization for the Oracle Enterprise Manager product, and is a frequent speaker at Oracle conferences.

Back to Top

Arup Nanda is the lead DBA at Starwood Hotels. He has been an Oracle DBA for more than 12 years. He writes for many Oracle related technological magazine, speaks at many Oracle conferences and has co-authored four books. He paints watercolors when is not doing all of these activities. He was Oracle Magazine's DBA of the Year in 2003 and is an OTN ACE Director.

Back to Top

Database archiving allows sites to streamline the application upgrade process, minimizing costly business disruption and improving performance. This presentation explores how managing enterprise application data can help:
1. Reduce time to upgrade and “go live” into production, while minimizing downtime during the conversion.
2. Control costs associated with application upgrade time, resources and maintenance
3. Increase your ability to satisfy data retention compliance requirements, ensuring that historical reference data remains accessible, even after applications have been upgraded.

Attendees will learn how some sites have cut downtime by over 50 percent while boosting the performance of key functional processes.

Steve Johnston is an experienced marketing and technology professional who has spent more than 10 years working in and around the technology industry. Steven has spoken at numerous conferences, user groups and associations on topics ranging from data privacy and compliance to the management of the effects of data growth in enterprise databases, the implementation of compliance-driven data management strategies, and the implementation of solutions to secure data in test and development environments. His background and experience includes successful work with EPCglobal US, GS1 (formerly the Uniform Code Council), Apptix, RealMedia, Penn Mutual and currently Princeton Softech.

Back to Top

There are probably close to as many ways to investigate a database slowdown as there are DBAs in attendance at most user group events. We all have a suite of methods and techniques in our toolkits to troubleshoot the performance hiccoughs that systems experience from time to time. When the call comes or the pager sounds off, this presentation will suggest one track to follow when trying to figure out what role the database is playing in these service interruptions (if any!). This presentation discusses my favorite places to go in the data dictionary and offers a handful of queries that may end up assisting the Oracle professional in getting to the bottom of application bottlenecks.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 14 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of events for and serves on the board of directors of the Independent Oracle Users Group (IOUG). He is a frequent speaker and keynoter at user group and vendor conferences and has appeared at such events as IOUG Live!, COLLABORATE, Oracle Open World, the European Oracle User Forum, and UK Oracle User Forum.  

Back to Top

Bob Wicklund is a Consulting Technical Senior Director at Oracle Corporation

Back to Top

Inderpal S. Johal has been working as a lead database administrator and architect for more than 10 years. He is currently working as principal consultant for Data Softech Inc., a New Jersey based company that specializes in providing complete database support solutions and training to various clients. He has written various Oracle technical articles for journals and magazines including Oracle Magazine and has spoken at Oracle Open World, IOUG, UKOUG, NYOUG, NJOUG and DBA Online. He has a Master's Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.

Back to Top

DEVELOPER TRACK: If you’re not using Analytics, shame on you!
In this presentation, will explain why you should be using analytics along with the minimum knowledge needed to get started. The presentation will also include some easy-to-understand, yet effective examples.

Travis Rogers is a Senior VP of Database Development for CDG Management LLC with over 15 years of software development including 10 years of Oracle development.

Back to Top

If your application users span time zones, dates should be relative to the user and transformable to different time zones. Oracle offers a complete set of options serving different requirements. Daylight savings time and the dynamic policies that determine it, must also be accounted for. What are the options and trade-offs? What are the relationships of the session, database, and server? This presentation will answer those questions and further discuss all the ancillary functions and their use. Detailed examples will explain the differences between SYSDATE, SYSTIMESTAMP, CURRENT_DATE, LOCALTIMESTAMP, etc. And finally the bugs.

Edward Kosciuszko started at Oracle Corporation in 1981 and since leaving in 1986 has been consulting, teaching SQL courses and designing Oracle tools. Ed created the first SQL optimization product, which was later sold to Platinum Technologies. 

Back to Top

This presentation discusses various scenarios to successfully approach Oracle testing based on the workload/workflow characterization, involving forms, reports, SQL, PL/SQL, and object-oriented programming languages among others. Independent from the methodology used, the presentation will also challenge opinion discrepancies among approaches such as CMM/CMMI and XP models, and traditional, object-oriented, and iterative software engineering methodologies. Best practices in testing Oracle front-end, back-end and middleware development at any stages will be covered. Finally, cases discussing strategies to both front-end, middleware, and back-end testing with an assessment as to whether a successful or failed outcome was related to the methodology utilized will be presented.

Anthony D. Noriega is an IT consultant and computer scientist who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms spending most of his time as a database architect, DBA, database analyst, and developer. Anthony holds an MS Computer Science from NJIT, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a Senior Consultant or Associate for Bowne & Co., IBM, Time Warner, AT&T, Reed-Elsevier, MCS Canon, Time, FMC, and Deutsche Bank.

Back to Top

October 2007 General Meeting
NYC Metro Area User Group Meeting

• Keynote

• DBA Track

• Development Track

• Fusion Track

Linux installs are still growing rapidly and many companies are deploying new systems with Linux as the preferred operating system. However even today, there is a lot of concern around Linux, its future and reliability/scalability in big datacenters. This presentation will discuss some of the new features coming up and see what companies like Oracle are doing to help ease the concerns. Linux is a very viable deployment platform and we want to make sure everyone feels comfortable with it.

Wim Coekaerts is vice president of Linux Engineering for Oracle, reporting to Chief Corporate Architect, Edward Screven. He is responsible for managing Oracle's Unbreakable Linux strategy with a dedicated focus on ensuring large enterprises can adopt Linux quickly. Mr. Coekaerts has spent more than 7 years building a large-scale development and support organization and has fostered comprehensive customer and partner relationships, which helps drive the company's evolution of Linux. Additionally, his group develops and makes on-going contributions to the Linux community, including the first Cluster File System to be accepted into the Linux mainline kernel in 2006.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

June 2007 General Meeting

KEYNOTE: Secure Your Data Transparently

Most applications developed in last decade were not designed to meet today's challenges around compliance (SOX, PCI), privacy, and insider threats. While security technologies such as encryption have existed for many years for protecting Personal Identifiable Information (PII), incorporating these technologies has proven to be a costly, risky, and time consuming exercise. This presentation will discuss how the transparency of security technologies is critical in making significant progress in securing today's data and applications. Mr. Samar will show how Oracle Database Vault, Oracle Audit Vault, Transparent Data Encryption (TDE), and Oracle Label Security can be applied to existing deployments to dramatically increase security, and lower the costs for compliance. In addition, the key security features of the next database release from Oracle will be discussed.

Vipin Samar is Vice President of the Database Security group at Oracle, and is responsible for all database-related security technologies as well as several Oracle security products including Database Vault, Audit Vault, Label Security and Advance Security. Starting his career in Sun's OS and networking group, he has been in the security space for 12+ years, and has worked in the areas of OS security, PAM, secure RPC, PKI, single-sign-on, and Identity Management. He is a local boy having completed his Master's Degree in Computer Science at SUNY Stony Brook many years ago.

Back to Top

Corporate databases contain the crown jewels of an organization, and data theft by hackers or insiders can cost millions in fines, lawsuits, and customer attrition. The good news is there are 10 commonly used methods to attack databases. Defend against these, and your databases will be virtually impenetrable. Using real-world examples, this presentation will describe each of the top 10 database security threats as well as demonstrate the probable attack mechanisms. The potential damage will be illustrated, along with detailed information regarding best practices in mitigation and defense techniques and tools.

Idan Soen is a Senior Security Engineer for Imperva. He has been in the IT security market for over 9 years. After spending two years at HP and five years at Check Point he joined Imperva three years ago as a senior security engineer covering Asia, EMEA and most recently the New York metropolitan region. Idan is well versed in web application and database security and has been involved in security implementations at many of the fortune 500 companies. Idan has a BA in business with a minor in IT and he is a CISSP.

Back to Top

Attendees will learn about the functionality that Oracle Application Express provides by exploring the three main working areas of Application Express. This brief presentation will serve to introduce Oracle professionals to the Application Express environment. It will show attendees how they can rapidly create intra and internet based applications that reference existing Oracle data. Attendees will also be shown how they can rapidly integrate spreadsheets, PDFs and various business related documents into their database and web application.

Karen Hackett is an IT professional with over 25 years experience. She has been working with Oracle for over 5 years at SkillBuilders. She is webmaster of www.skillbuilders.com which uses Oracle and Coldfusion. She also designed, developed and maintains www.RIOUG.org and www.RIRenewableEnergy.com

Back to Top

This presentation covers the high availability capabilities in Oracle Database 11g, which are designed to help organizations maintain a highly available, scalable infrastructure that meet users' quality of service expectations. Tim will detail many of the Maximum Availability Architecture (MAA) and availability capabilities in Oracle Database 11g such as:
• Utilizing standby databases for real time query purposes
• Enabling standby databases to be easily used for testing purposes
• Significantly reducing recovery downtime with Data Recovery Advisor to automate problem investigation and intelligently determine a recovery plan
• Applying patches to an Oracle database instance with zero downtime
• Further automating human error recovery using Flashback Transaction
 

Tim Chien is a senior product manager with Oracle's High Availability and Storage Management Group.
He is an 8 year Oracle veteran and has extensive product management and product marketing experience includes server systems, application server, and database products.

Back to Top

This will be a detailed presentation using an RMAN script where participants will learn step-by-step how to clone a new database and refresh an existing database’s data. The author has used the RMAN feature in production for several years. He will share his experience and script to show step by step to clone or to refresh databases in same or in different machines. Many production details will be talked such as refresh archived production database to no archive develop database. The script will enable the attendees to use just one command to do the entire job automatically. HP OMNI Performance tips will also be introduced.

Yongan Cui has been an Oracle certified DBA since version 7.3. He has presented at IOUG and authored a SELECT Journal article.

Back to Top

Participants will learn how to secure their Oracle databases and some of what Novartis has done globally to implement Oracle Database Security. Jonathan will discuss specific activities that DBAs and application teams should perform to secure their databases. In addition, some specifics of what Novartis has done to harden their database environment, including an "Oracle Database Security Roadshow" will be presented.

Jonathan Intner has been an Oracle DBA for more than 15 years. In addition to being a 9i OCP, he is a CISSP (Certified Information Systems Security Professional).

Back to Top

Oracle released Database Vault in August of 2006 to address rapidly emerging security requirements around the world for restricting access to sensitive data by privileged users, overcoming a long-standing security problem. Along with such first-of-its-kind access control capability, Database Vault also introduced custom access policies based upon environmental, execution, as well as user factors to control how existing databases, applications, and data are accessed. This presentation takes a look inside Oracle Database Vault, its architecture, security threat model, and how new controls were added to the Oracle Database kernel so that privileged users and DBAs are restricted from accessing sensitive data, but can still perform all of their authorized maintenance and tuning activities. Mr. Samar will discuss the operational model and how it offers separation-of-duty capabilities. In addition, a case study of how a financial services company plans to leverage Database Vault to address its compliance and security requirements for its world-wide operations will be presented.

Vipin Samar is Vice President of the Database Security group at Oracle, and is responsible for all database-related security technologies as well as several Oracle security products including Database Vault, Audit Vault, Label Security and Advance Security. Starting his career in Sun's OS and networking group, he has been in the security space for 12+ years, and has worked in the areas of OS security, PAM, secure RPC, PKI, single-sign-on, and Identity Management. He is a local boy having completed his Master's Degree in Computer Science at SUNY Stony Brook many years ago.

Back to Top

CLOBs/BLOBs/BFILEs (commonly called “large objects”) have been around for a long time, but only recently have they become critical tools for database systems. Handling large database objects requires in-depth understanding of their proper handling. This presentation will provide a starting point by explaining when, why, and how to use large objects in real-world situations.

Michael Rosenblum is a Development DBA at Dulcian, Inc. He is responsible for system tuning and application architecture. He supports Dulcian developers by writing complex PL/SQL routines and researching new features. Mr. Rosenblum is the co-author of PL/SQL for Dummies (Wiley Press, 2006). Michael is a frequent presenter at various regional and national Oracle user group conferences. In his native Ukraine, he received the scholarship of the President of Ukraine, a Masters Degree in Information Systems, and a Diploma with Honors from the Kiev National University of Economics.

Back to Top

March 2007 General Meeting

KEYNOTE: How Oracle Came to Rule the Database World

This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Richard J. Niemiec is chief executive officer and principal of TUSC. He is respected around the world as a master in database administration. In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master -- one of the first six so recognized around the world. In 2003, Rich authored Oracle9i Performance Tuning Tips & Techniques, one of more than two dozen books TUSC has written for various publishers and features a compilation of more than 20 years of hands-on experience and real-life issues. Some Fortune 500 accounts he has managed include M&M Mars, McDonald's Corp. and Pepsico. His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is a former president of the International Oracle Users Group and currently serves as vice president for its Real Application Clusters special interest group. In addition, Rich is the current president of the Midwest Oracle Users Group. He previously was the executive editor of Exploring Oracle DBMS magazine and editor of MOUG Newsletter. Rich has delivered hundreds of lectures on Oracle to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has conducted numerous expert class presentations at Oracle OpenWorld and other major conferences.

Back to Top

Database creation, because of better GUI tools, has become an increasingly overlooked area of Oracle. In this presentation, Sean pulls back the covers, revealing what Oracle is doing at each stage. Why do we have startup nomount, mount, restrict, and open? What OS resources is Oracle using at each step? How do we issue CREATE DATABASE? What is the simplest init.ora file? How many file descriptors does Oracle use and why?

Sean Hull is the founder of and senior consultant at Heavyweight Internet Group in New York. He has worked as a database consultant and expert for ten years, in the areas of Oracle and various Open Source technologies. He is the co-author of Oracle and Open Source (2001, O'Reilly & Associates) as well as various Open Source database tools, scripts, and applications. Sean has also written articles for various online and print publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

Attendees will learn how to build their own versions of Instant Client with tools not included in Oracle's Instant Client. Oracle Instant Client is a power tool that is easy to install and set up, but it only comes with SQL*Plus. This presentation shows how to include other Oracle tools like SQL*Loader and exp/imp to make your own instant client bundle.

Richard Ji is a Senior Principal DBA Manager at WiderThan Corp. He has been working with Oracle databases since 1996. Richard had architected high performance, large scale databases that perform in the range of several hundred million transact

Back to Top

What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are easy ways to solve many of your performance issues that plague your system. This presentation will show how to use Statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file I/O issues. Attendees will also learn how Statspack compares to AWR Report and some of the additions that AWR Report provides over Statspack, even though 80% of the information is the as that in Statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events.

Richard J. Niemiec is chief executive officer and principal of TUSC. He is respected around the world as a master in database administration. In 2001, Rich was named by Oracle Corp. as an Oracle Certified Master -- one of the first six so recognized around the world. In 2003, Rich authored Oracle9i Performance Tuning Tips & Techniques, one of more than two dozen books TUSC has written for various publishers and features a compilation of more than 20 years of hands-on experience and real-life issues. Some Fortune 500 accounts he has managed include M&M Mars, McDonald's Corp. and Pepsico. His experience in data processing ranges from teaching to consulting, with emphasis in database administration, performance tuning, project management and technical education. Rich is a former president of the International Oracle Users Group and currently serves as vice president for its Real Application Clusters special interest group. In addition, Rich is the current president of the Midwest Oracle Users Group. He previously was the executive editor of Exploring Oracle DBMS magazine and editor of MOUG Newsletter. Rich has delivered hundreds of lectures on Oracle to users around the world. Past accomplishments include top presenter honors at international Oracle users conferences. He has conducted numerous expert class presentations at Oracle OpenWorld and other major conferences.

Back to Top

Security_Practices.zip

Participants will learn how the JAZN service of the Oracle Application Server OC4J runtime provides solid security services for J2EE web applications. They will also learn about the JAZN ability to access user credentials stored in XML files and in LDAP repositories. They will hear about and see how to set up and code security hooks into an application using JDeveloper 10g so they can restrict and permit user access and operations to valuable enterprise data.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

The use of column histograms can have a very positive impact on the Cost-Based Optimizer's operation, but there is still much uncertainty about when and how to take advantage of this functionality. This presentation discusses how histograms are used, how to identify columns for which they are appropriate, how to create them, and how to confirm their use. Participants will learn how to determine if a column is a candidate for histogram generation, how to create the histograms, and how optimizer behavior changes in their presence.

Paul Baumgartel has been an Oracle DBA for many years, and currently works as an independent consultant in the New York City financial industry. He specializes in performance optimization, database server architecture, and training.

Back to Top

This paper and presentation with discuss important applications in finance, marketing, research and development and other important areas of management science, forecasting, and data mining. The key aspects of this presentation, unlike most business intelligence analytics, is that it is driven by Oracle10g SQL Model’s ability to achieve successful forecasting utilizing traditional and scientific business models based on the dimensions, measures, and rules implemented.

Anthony D. Noriega is an IT Consultant who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN, Anthony spends most of his time as a database analyst, architect, and developer, and DBA. Anthony has attained an MS in Computer Science from NJIT, an MBA from Montclair State University, and a BS in Systems Engineering from University of the North. He has been a consultant for IBM, AT&T, M&M Mars, Tosco, Allied-Signal, and an associate for Deutsche-Bank, Bowne & Co, Reed-Elsevier, MCS Canon, and FMC. Anthony is fluent in Spanish and French.

Back to Top

December 2006 General Meeting

KEYNOTE: Soft Skills….Can’t Live Without Them
I don't care if you played bass guitar for the Quarrymen before Paul McCartney or if you were a ghost writer for Dickens ... if your going to sit in your cubicle all day, pound away at your keyboard, and bark at colleagues who stray into your space ... you're not getting the job! Even though you have Oracle skills second to none, it's not all about the software.

• Are you a team player?
• Can you compromise?
• Hows your grammar and spellnig?
• Ever heard of a deadline?
• The phone ... yes we do still use them here.

Soft skills .. often as important, if not more important, than your technical skills. In this keynote, Michael will share some of his experience of his north of 20 years in the industry and highlight some experiences we have all gone through which, when happening, were painful, but in hindsight are nothing but comical. Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 12 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of conferences for and serves on the board of directors of the Independent Oracle Users Group (IOUG)

Back to Top

DBA TRACK (single session): 11gR1 PLSQL New Features

A 60 minute overview of some of the many new SQL/PLSQL features including much improved native compilation, result caches, more granular dependency management, new trigger types and more.

Back to Top

DBA TRACK:  Introduction to Automatic Storage Management

This presentation is and introduction to Oracle's new integrated file system and volume manager, ASM. Demonstrations will illustrate the basic use of ASM, including creating disk groups, migrating to and from ASM and using ASMCMD to manage ASM files.

Dave Anderson has more than 24 years of hands-on experience in the I.T. industry.  His last 10 years have been spent working with Oracle - as a programmer and administrator.  Dave speaks regularly at Oracle conferences including IOUG, NYOUG, CTOUG, VOUG, NOUG and SEOUC (where he won “Best of Conference” for his RMAN presentation).  In 1992 Dave founded and is still employed by SkillBuilders, an Oracle Partner specializing in Oracle sales, training and consulting.

Back to Top

Oracle has long offered tools that assist with deploying applications; its current focus is with the Java IDE, JDeveloper. JDeveloper 10g (release 10.1.3) offers a new set of features, libraries, and methods -- ADF Faces -- which greatly simplifies Java development tasks and takes advantage of the popular J2EE (Java EE 5.0) technology JavaServer Faces. The tools that JDeveloper provides to work with ADF Faces allow development of J2EE web applications in an environment that is closer to Oracle Forms than anything previously released.
This presentation describes Application Development Framework (ADF) and ADF Faces and how they can assist with development of a Java-based application. It also shows the various tools in JDeveloper that support the "ADF development method" and how they ease the task of connecting Java front-end code to the database. In addition, the presentation provides an overview of the JHeadstart plugin and shows how its declarative environment might rival that of Oracle Forms Builder. Finally, the presentation offers insights about what type of development shop will benefit the most from ADF, ADF Faces, and JHeadstart and whether it really is possible to achieve the productivity of an Oracle Forms environment by using ADF Faces with JHeadstart.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

So many DBAs are postponing the move to Recovery Manager due to its seemingly time-consuming learning curve. In this presentation, attendees already fluent with backup and recovery strategies using Oracle's toolset will see how the transition is nowhere near as time consuming as anticipated. This presentation will cover the infrastructure setup to support catalog-based RMAN, and present some scripts to get started. Michael will discuss the three main backup scenarios and look at the recovery phase of an RMAN restore exercise as well as cover the pesky management of and backup of archived redo as well as a primer on catalog cleanup. With a kick-start through the lessons learned in this presentation, the move to RMAN is one of the least complicated hurdles DBAs will be asked to overcome.

Michael Abbey is a recognized authority on database administration, installation, development, application migration, performance tuning, and implementation. Working with Michael Corey, he has co-authored 12 books for McGraw-Hill's Oracle Press Series, including most recently Oracle Database 10g: A Beginner's Guide. Active in the international Oracle user community, Abbey is the director of conferences for and serves on the board of directors of the Independent Oracle Users Group (IOUG)

Back to Top

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has over 22 years of industry experience. Peter has presented at various Oracle users group conferences more than 170 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, the ODTUG Volunteer of the Year, and NYOUG Editor's Choice. He is an Oracle Certified Master, Oracle Fusion Middleware Regional Director, and coauthor of the Oracle Press Books: Oracle JDeveloper 10g for Forms & PL/SQL Developers (with Duncan Mills), Oracle JDeveloper 10g Handbook and Oracle9i JDeveloper Handbook (with Dr. Paul Dorsey and Avrom Roy-Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook (all with Dr. Paul Dorsey).

Back to Top

Matthew Williams is a Senior Oracle Programmer at LexisNexis Corporation, and specializes in matching techniques to unite unrelated data sources. He has a cat.

Back to Top

September 2006 General Meeting

KEYNOTE: Fusion Middleware Technical Overview and Roadmap

Oracle Fusion Middleware is not only the fastest growing Oracle product.  It is also innovating rapidly.  The keynote will first address the major technologies and components of Fusion Middleware supporting SOA, Identity Management, Business Intelligence, and Workplace.  Vijay will also describe the release themes and some high-level features anticipated for Oracle Fusion Middleware 11.  Lastly, for customers who have PeopleSoft, JD Edwards, and Seibel Applications, he will highlight how they can leverage Fusion Middleware today.

Vijay Tella is the chief strategy officer for Oracle Corporation's middleware platform product, Oracle Application Server 10g. He is responsible for shaping the technical and strategic direction of the product, ensuring Oracle's continued leadership in the application platform suite (APS) market. Mr. Tella has more than 15 years of experience innovating and delivering market leading products in the middleware space. His expertise includes Enterprise Application Integration, Business Process Management, Business Activity Monitoring, B2B Integration, Web Services Infrastructure and Enterprise Portals. Prior to joining Oracle, Mr. Tella was senior vice-president of engineering at TIBCO Software Inc, delivering its business integration products: Active Enterprise, Active Exchange and Active Portal. Mr. Tella holds a B.Tech. degree in Computer Science from the Indian Institute of Technology and an M.S. degree in computer science from University of California, Los Angeles .

Back to Top

DBA TRACK: An Extensible Materialized View Architecture

This presentation describes an extensible architecture modeled after Oracle materialized views that has many of the features of Oracle materialized views without many of the limitations. Most notable among its features are its ability to support fast log-based refreshes of arbitrarily complex materialized views under circumstances where an equivalent Oracle materialized view would require a complete refresh. One such circumstance is the restoration of a materialized view after a media failure on either the master or materialized view database. The architecture allows us to resynchronize the materialized view with the master(s) without performing a full refresh.
 
Claudio Fratarcangeli has 20 years of experience using Oracle (since V4) in application development, software product development, and database administration. In recent years he has also been involved in Java J2EE architecture and development. He has presented at various regional and national conferences and has authored articles in various database trade magazines and academic journals.

Back to Top

DEVELOPER TRACK: Customizing a Packaged Application for a J2EE Environment: A Case Study

How does a Forms and Designer expert (relatively) adjust to life in a Java and J2EE world? The author is finding out while customizing a J2EE-compliant application to the requirements of several clients. This presentation details some of the issues to be faced in making this transition. Topics include the use of multiple technologies (including CSS, HTML, JavaScript, and ColdFusion) to customize the user interface; development and deployment using both proprietary and open source tools and servers; integrations with external systems using XML and XSLT; and the learning curve in mastering Java and JavaScript in a real-world environment.

Leslie Tierstein is a Principal Technical Architect for newScale, Inc, a Silicon Valley-based company which provides IT Portfolio Management and Service Catalog applications.  Her responsibilities have included customizing newScale’s J2EE-compliant RequestCenter product suite for client implementations and delivering and developing technical training materials on a wide range of topics, including application integration, JavaScript programming, data warehousing, and user interface customization.  Before joining newScale, Leslie had over 20 years of IT industry experience which has included leading the implementation of mission-critical applications built using Oracle database technology.  She is an award-winning speaker at conferences including NYOUG, Oracle Development Tools User Group (ODTUG), and IOUG.

Back to Top

DBA 101 TRACK: Do-It-Yourself Monitoring with OTop

The Oracle Wait Interface has become the one-stop shop for diagnosing bottlenecks in your database. However querying it directly remains somewhat laborious, and many a commercial tool just don't quite fit the bill. Enter OTop, a PERL-based monitoring and diagnostic tool based on the popular Unix top utility, and the MySQL mtop. In this presentation, attendees will learn about the OWI, how to identify some typical bottlenecks, what wait events to look out for, and how OTop can display that information for you.

Sean Hull is the founder of and senior consultant at Heavyweight Internet Group in New York. He has worked as a database consultant and expert for ten years, in the areas of Oracle and various Open Source technologies. He is the co-author of Oracle and Open Source (2001, O'Reilly & Associates) as well as various Open Source database tools, scripts, and applications. Sean has also written articles for various online and print publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

DEVELOPER 101 TRACK: Oracle 10g for Developers

Attendees will be introduced to new and improved features of Oracle10g that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or improve deployment. Attendees will be better-equipped to create applications that take full advantage of Oracle10g.

John King is a Partner in King Training Resources, a firm providing instructor-led training since 1988 across the United States and Internationally. John has worked with Oracle products and the database since Version 4. John develops and presents customized courses in a variety of topics including Oracle, DB2/UDB, SOA, Java, XML, .NET, and C++. John presents frequently at various industry conferences.

Back to Top

ORACLE FUSION TRACK: Securing Your Enterprise: Oracle Security &  Identity Management

This session will focus on how Oracle's comprehensive Identity and Access Management Suite helps organizations enhance enterprise-wide compliance, lower operational costs, and strengthen security. We’ll give a high level overview of the features and benefits of each of the components of the suite to show how both Fusion and non-Oracle applications benefit from using these best in class products.

DBA TRACK: Introduction to DBMS_METADATA

DBMS_METADATA, introduced in Oracle9i, was a breakthrough for DBAs and developers, eliminating the need to write tortuous SQL statements in an attempt to construct DDL from data dictionary contents.  This presentation reviews DBMS_METADATA's extensive capabilities, and presents a fully-developed example to illustrate how to use the package's API. Participants will learn how to use the powerful DBMS_METADATA package to extract and apply DDL programatically or save it for later use. 

Paul Baumgartel has been an Oracle DBA for over fifteen years.  He specializes in performance optimization, training, and utility development.  His consulting clients have included Oxford Health Plans, TIAA-CREF, BMG, United Parcel Service, and Credit Suisse.

Back to Top

DEVELOPER TRACK: Six Steps to Unit Testing Happiness

This presentation will discuss the overall state of software quality -- and the impact of low quality code. Steven will review high-level principles for unit testing, introduce the concept of "test-driven development", offer a simple methodology ("six simple steps") for integrating testing into development, and demonstrate that process with automated unit testing software.
 
Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as PL/SQL Evangelist for Quest Software. His Oracle PL/SQL Best Practices column is one of the most popular pages on the Oracle Technology Network, he writes regularly for Oracle Magazine, and was awarded both the Best Presentation Content/Topic and Editor's Choice Awards at the ODTUG (Oracle Development Tools User Group) 2004 conference. He can be reached at steven@stevenfeuerstein.com.

Back to Top

DBA 101 TRACK: You Probably DO Need RAC

Several years ago, Mogens Norgaard wrote a paper entitled, "You probably don't need RAC".  RAC is a powerful and exciting technology for database environments of all sizes.  In this session, Matthew will speak on the history of RAC, the challenges surrounding RAC in terms of application design and tuning, and why organizations should be moving to RAC.

Matthew Zito is an expert in large-scale infrastructures, with extensive experience in designing and deploying some of the world's largest system, network, and application architectures. Before joining GridApp, Mr. Zito worked at leading information storage company EMC and Register.com, where he designed and implemented a variety of storage infrastructures and pioneered the use of centralized management and automation to run large production application infrastructures.  Matthew Zito has worked with Linux for almost 10 years, testing, contributing, and advocating Linux as the future of the enterprise datacenter.

Back to Top

DEVELOPER 101 TRACK: An Introduction to BPEL

BPEL (Business Execution Language) is becoming the standard for connecting a set of disparate and discrete services into an end-to-end process flow. BPEL can reduce the cost and complexity of integration. The Oracle BPEL Process Manager is very easy-to-use. Oracle BPEL Process Manager is an infrastructure for creating, deploying and managing BPEL business processes. This presentation will give attendees an understanding of the Oracle BPEL tool, show how a developer might use BPEL (live demo), and what a DBA needs to be aware of.

Nicholas J. Donatone is the Vice President of Database Services for MFG Systems Corporation. He is one of the founders of the New Jersey Oracle Users Group (NJOUG) and has been president/co-president of the NJOUG for more than 16 years. He has made presentations at NJOUG, IOUG, ODTUG, VOUG and Oracle OpenWorld.

Back to Top

ORACLE FUSION TRACK: Betting Big on JavaServer Faces: Components,  Tools and Tricks

This presentation highlights all of the areas where Oracle has bet big on JSF, including illustrating the breadth and depth of the ADF Faces JSF component library, previewing our Web 2.0 AJAX components, showing support for Telnet devices and PDAs. Demos will highlight some of the additional JSF productivity features Oracle's own developer's leverage like declarative data binding, more sophisticated tables and tree controls, translatable prompts and format masks, declarative validation, declarative security, declarative method invocation and page lifecycle control, and centralized error reporting.

Steve Muench is is a consulting product manager for Oracle JDeveloper and an Oracle ACE. In his more than 16 years at Oracle, he has developed and supported Oracle tools and XML technologies and continues to evangelize them. Muench coauthored the Oracle ADF Developer’s Guide for Forms/4GL Developers (Oracle, 2006) and wrote Building Oracle XML Applications (O’Reilly Media, 2000).

Back to Top

DBA TRACK: Changing Servers with Little or No Downtime

Downtime ... a big bad word that creeps up when looking at moving an environment from one server to another. This presentation will present a tested routine to accomplish a server move with close-to-zero downtime, assuming the operating system is not changing. Using Oracle's physical standby database technology for the transfer of the database itself, this need not be a daunting task. This presentation will discuss issues such as file and crontab synchronization, backups on the new site, and the transfer of the recovery manager catalog database.

Michael S. Abbey is a regular presenter at user group and some vendor functions, having first cut his teeth with Oracle version 3 in the mid 80's. He is part owner of Ntirety LLC in Boston MA, vending Oracle and SQL Server support services to a hungry install base. He is the Events Director for the Independent Oracle Users Group, responsible for the delivery of COLLARORATE 07 in Las Vegas in April 2007.

Back to Top

DEVELOPER TRACK: "Thick Database" Approach for Web Development

The J2EE architecture is very robust and mature but is also very complex. There is a dizzying array of development alternatives which, in and of itself, can almost guarantee project failure. Even when a project succeeds, the resulting applications are often impossible to maintain by anyone other than the original architect. This presentation outlines a development methodology that results in applications that are functionally sophisticated but are architecturally very simple. They are easy to build and maintain by moderately skilled developers. The techniques demonstrated in this presentation go far beyond merely placing all of the logic into the database. Applications are architected using a standard/reusable set of APIs that call database routines.  Applications built using this methodology scale well and provide good performance.

Dr. Paul Dorsey is president of Dulcian, Inc. an Oracle consulting firm specializing in business rules and web-based application development. He is the chief architect of Dulcian's BRIM^® tool. Paul is the co-author of seven Oracle Press books.  Paul is an Oracle Fusion Middleware Regional Director, President of NYOUG, an editor of IOUG’s SELECT Journal, founder and chairperson of the ODTUG Best Practices Symposium and the Fusion Java Development SIG. He has been IOUG and ODTUG volunteer of the year and an Oracle 9i Certified Master. 

Back to Top

DBA 101 TRACK: Oracle 10g's A's: AWR, ADDM, ASM, ASH

This presentation will explain these features and their architecture as well as the benefit of these important terms for your environment and how it can be managed using SQL as well as thru EM. The presentation will provide technical details about AWR, ADDM, ASM, ASH, Advisories and other Oracle automatic features to help you learn how to utilize them in your 10g environment.

Inderpal S. Johal has been working as Database manager, Lead Database Administrator and architect for the last 10 years. He has written Oracle technical articles for Journals and magazines including Oracle Magazine. He has also spoken at Oracle OpenWorld, IOUG, UKOUG, NJOUG, NYOUG and DBA online. He has a Master's Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire.

Back to Top

DEVELOPER 101 TRACK: SQL Tuning for Developers 101

This presentation will cover the techniques and generic tools available for developers to utilize when tuning SQL code during development efforts. Techniques such as proper use of bind variables, proper indexing and proper PL/SQL techniques will be discussed. Tools such as those available in SQLPLUS and from the command line will be covered as well as limited demonstrations of the techniques and tools presented.

Michael Ault has been working with Oracle for 16 years. Before Oracle, Mike worked with both Ingres and Informix databases for a total database experience level of 20 years. Mike has written over two dozen books related to Oracle monitoring and tuning and the use of Real Application Clusters. Mike is a frequent presenter at conferences and is the author of numerous white papers, articles and classes on Oracle related topics.

Back to Top

ORACLE FUSION TRACK: Intro to the Oracle Business Intelligence Platform

This presentation will focus on Oracle as an integrated Business Intelligence platform rather than a collection of tools for data warehousing, reporting, OLAP, data mining and other data exploration tools. The presentation will use a demo-like overview of the BI technology and also discuss how Siebel Analytics - Real Time Decisioning helps to extend this platform for real-time analytics. The speakers will also highlight the growing importance of real time analytics in a world where the advertising and campaigns are undergoing paradigm change due to DO NOT CALL lists, spam blockers, digital media recorders etc. This presentation will also cover how Extraction, Transform and Load (ETL) can be done in the Oracle database, leading to data for advanced reporting, analytics such as data mining, OLAP, etc. for the automation of critical decision making in a business organization which results in actionable tasks.

Richard Solari is the Senior Director of the Business Intelligence and Reporting Consulting Practice at Oracle and is responsible for data mining implementations worldwide. For more than 13 years Mr. Solari has led or contributed to dozens of statistical and data mining projects for clients which include the Internal Revenue Service, Blue Cross Blue Shield, Fannie Mae, Department of State, New York City Comptrollers Office, World Bank, Wells Fargo, Equifax, Anderson Consulting, Deloitte & Touche, MCI, Bell South, Pacific Bell, US West, British Telecom, Omnitel, and Columbia Health Care.  Project areas have included customer acquisition and retention, marketing and cross selling, network analysis, and fraud detection in the telecommunications, financial, insurance, and health care industries. 

Shyam Varan Nath is a Principal Analytical Consultant of the BI Group at Oracle Corporation. He chairs the Special Interest Group on DW & BI. He as been an OCP since 1998 (version 7.3 of database) and has presented at Oracle OpenWorld, IOUG/Collaborate, NYOUG and several other industry related events.

Back to Top

DBA TRACK: Data Pump - Not Just for Data Movement

Oracle Data Pump, introduced in Oracle 10g, has been touted as tool for data movement across databases; but it’s so much more than that. It can be used as a source code control system to achieve regulatory compliance as in SOX; to publish offline data securely; to design a better backup and archival tool, etc. In this presentation, attendees will learn about advanced operations (including performance enhancements), using external tables, enabling metadata movement, creating user objects, and creating a backup of user source code to satisfy compliance, using data pump APIs for sending data to a remote database not connected online and much more.

Arup Nanda has been an Oracle DBA for more than 12 years working in all aspects of database management from modeling to performance management and disaster recovery. He is the author of books Oracle PL/SQL for DBAs (O'Reilly 2005) and Oracle Privacy Security Auditing (Rampant 2003). He was awarded the DBA of the Year by Oracle in 2003.

Back to Top

DEVELOPER TRACK: Introducing Oracle Queuing/Messaging Technology

This presentation will introduce Oracle Queuing and Messaging Infrastructure from an administrative and development integrative perspective from the DBA viewpoint and the resource availability from the PL/SQL and Java perspectives. It will introduce concepts such as peer-to-peer and broadcasting queues. It will expand on intelligent agent and gateway architecture technologies including MQ Series streams and relate Oracle messaging technology to other technologies such as JMS and DCOM.  The transparent benefits enhancements proposed by queues on both privacy and security issues will be emphasized. In addition, the presentation will briefly discuss advanced features such as transformation mechanism and symmetric and asymmetric encryption (PKI) and introduce the Oracle Database and Architecture framework, explicitly the OPMN-based technology.

Anthony D. Noriega is a Senior Oracle Consultant and computer scientist who has focused his efforts in Oracle database technology, network computing, software and network engineering, and object-oriented programming paradigms.  Anthony spends most of his time as a database analyst, architect, and developer, and DBA. He is a Senior Oracle DBA/Developer and a member of IOUG and NYOUG.

Back to Top

DBA 101 TRACK: Reporting from the RMAN Repository

Oracle Recovery Manager provides some limited reporting with the LIST and REPORT commands, but how about answers to some of the really important questions, such as:  Can I recover to a specific point-in-time?  How long will it take me to restore and recover?  How much space are my backups taking?  This presentation will describe the both repositories used by RMAN, in the control file (i.e. NOCATALOG) as well as the "recovery catalog", and how to report from them.

DEVELOPER 101 TRACK:  Tired of Oracle's SQL*Plus? Try SQL Developer!

SQL Developer is a new, free graphical tool from Oracle that allows anyone to graphically view or change any database object. For example, you can easily see all of a table's data in a spreadsheet-like view. From the spreadsheet like view you can easily update specific fields or delete entire rows with the click of a mouse button. All this can be done without writing one bit of SQL.  SQL Developer is Oracle's answer to 3rd party products like TOAD or SQL Navigator. Participants will learn about Oracle's new SQL Developer product and see a live, full demo of SQL Developer.

Chris Grabowy is a database architect with Lockheed Martin in Valley Forge, PA.  He has over twenty years of experience in the computer industry, including ten years with Oracle.  Chris has presented at IOUG, local user groups and at company events.

Back to Top

ORACLE FUSION TRACK: Data Mining for Real Time Analytics

This presentation will discuss data mining and its usefulness for businesses. It will focus on how data mining couples with the Oracle RDBMS. In view of the paradigm change in marketing, the growing importance of real time decisions for businesses will be covered as well as how analytics can drive these real-time decisions. Preparing the database and the data for such analytical use will be discussed along with how DBAs can learn about data mining and assist in this process.

Shyam Varan Nath is a Principal Analytical Consultant of the BI Group at Oracle Corporation. He chairs the Special Interest Group on DW & BI. He as been an OCP since 1998 (version 7.3 of database) and has presented at Oracle OpenWorld, IOUG/Collaborate, NYOUG and several other industry related events.

Back to Top

June 2006 General Meeting

Back to Top

Alok Pareek brings over 10 years of database development experience from Oracle’s Recovery/High Availability area.
Currently he is a software solutions architect for GoldenGate Software’s High Availability and Disaster Tolerance
offerings. He was responsible for the redo generation component of the Oracle database from 8i to 10.2, and his
contributions at Oracle include the development of Cross Platform Transportable Tablespaces (Oracle 10g), Multithreaded redo generation (9i), Multiple block size cache support (9i), and Whole database transport (10.2). He has
presented technical sessions at Oracle OpenWorld and regional Oracle User Group chapters, and holds a graduate degree

Back to Top

Faruk Cay is a Principal Consultant at Oracle working on data mining. He has been with Oracle for six years and
previously worked in Oracle Data Mining development team. He has over 13 years of experience in software industry.
Shyam Varan Nath is a Principal Consultant at Oracle as part of the Data Mining group. He is an Oracle certified DBA
since 1998. Shyam has worked in the health care and telecommunication industry. His consulting projects have been in
the law enforcement and finance industry. He has worked with Oracle data mining for building customer churn models
and intrusion detection models for enhancing security. He has presented at Oracle Opeworld, IOUG/Collaborate and
several other similar events on topics related to database administration and data mining

Back to Top

Kirtikumar Deshpande works for Verizon Information Services as a Senior Oracle Database Administrator. He has over 25 years of IT experience in various capacities, including over 11 years as an Oracle DBA. He coauthored two Oracle Press books, Oracle Performance Tuning 101 and Oracle Wait Interface - A Practical Guide to Performance Diagnostics & Tuning. He is a frequent speaker at various Oracle conferences in the U.S. and abroad.

Back to Top

Jeff Bernknopf is a team leader at Morgan Stanley. Jeff has over 25 years of experience in developing
applications and has recently concentrated on technologies like Java/J2EE, C#, HTML DB, XML/XML DB and
Web Services. Jeff is the Vice President of NYOUG where he handles Vendor Relations. Jeff is also a
Contributing Editor of SELECT Magazine, on the Editorial Board of Oracle Magazine and the Contributing
Editor of the ODTUG Technical Journal's Tool Talk column.

Back to Top

Matthew Zito is an expert in large-scale infrastructures, with extensive experience in designing and deploying some of
the world's largest system, network, and application architectures. Before joining GridApp, Mr. Zito worked at leading
information storage company EMC, where he designed and implemented a variety of storage infrastructures and
conducted research on deployed security models used within EMC technology.Prior to joining EMC, Mr. Zito served as
Infrastructure Architect at Register.com, where he pioneered the use of centralized management and automation to run
large production application infrastructures.. His expertise in technologies such as Oracle, distributed clustering, and
infrastructure performance optimization allowed Register.com's infrastructure to scale cost-effectively and far beyond its
original life expectancy.His code is running in a number of open-source software projects and he is currently writing the
O'Reilly "animal" book on Enterprise Storage. He attended New York University.

Back to Top

Bruce Mathis has been using Oracle products for 10 years, since database release 7. He is now concentrating on using
Application Express to its fullest potential.

Back to Top

Sean Hull is the founder and senior consultant at Heavyweight Internet Group in New York. He has worked as a database consultant and expert for ten years, in the areas of Oracle, and various Open Source technologies. He is the co-author of Oracle & Open Source (O'Reilly, 2001) as well as various open source database tools, scripts, and applications. Sean has also written articles for various print and online publications such as the Oracle Technology Network. He can be reached at shull@iheavy.com.

Back to Top

Coleman Leviter is currently employed as a Programmer/Analyst at Arrow Electronics. He has worked in the financial
services industry and the aerospace industry where he developed Navigation, Flight Control and Reconnaissance software
for the F-14D Tomcat at Grumman Aerospace. Coleman has a BSEE from Rochester Institute of Technology, an MBA
from C.W. Post and an MSCS from New York Institute of Technology. He can be contacted at cleviter@ieee.org

Back to Top

2006 March General Meeting

Back to Top

Back to Top

Average Active Sessions - A New Tuning Paradigm - Average Active Sessions is a natural extension of Oracle's now famous and revolutionary wait interface. Now with Oracle 10g, Enterprise Manager (EM) has a clear, easy presentation of waits via the average active session measurement. Average active session is used as the pillar from which all other tuning decisions are made in Oracle's EM 10g. Learn how this new feature works, how it relates to the wait interfaces, how it revolutionizes tuning, how it can be used for SLAs, charge back, and load balancing, and how it can be extended in the industry to other databases, operating systems, and application code.

Kyle Hailey has been in the industry for a decade and a half.  Working at Oracle for over 13 years, he spent time in support, porting, benchmarking, and kernel development. Kyle has created tools to improve high-end performance monitoring, such as direct SGA attach and interactive graphic displays of performance data. He recently redesigned the Oracle Enterprise Manager 10g performance pages to be graphically oriented and wait interface centric. He currently works at Embarcadero Technologies and is responsible for their suite of performance tuning and monitoring tools

Back to Top

Back to Top

Data Warehouse Design for OLTP Data Modelers - Logical and physical data modeling for a data mart or data warehouse require a set of skills which intersect with those skills generally used by OLTP data modelers. What skills carry over from one realm to the other? What do OLTP modelers need to "unlearn" to be proficient data mart designers? And what new skill sets are required? Logical data mart design builds on some principles of normalized database design but requires practitioners to contradict others. On the physical design level, the developer needs extensive database tuning and configuration expertise to build a data warehouse that performs adequately, as well as objects such as materialized views, partitions, and bitmap indexes. The design must take into account both the time required to process queries and produce reports, and the use of the maintenance window during which the warehouse's contents can be refreshed.

Leslie Tierstein is a Professional Services Technical Architect with newScale, Inc., a company headquartered in Foster City, CA which provides packaged solutions for IT Service Portfolio Management and IT Service Catalog Management. She has over 15 years of IT experience, including the development of large-scale OLTP applications as well as data warehouses using the Oracle database. She has presented at conferences including NYOUG, IOUG-A, ODTUG, and MAOP-AOTC.

Back to Top

Mastering Grid Computing - The focus of this presentation is to provide a comprehensive set of expert tips and techniques to optimize the usage of Oracle10g Enterprise Manager Grid Control and its components from installation to production and maintenance approaches. It will also include a discussion of emctl, opmnctl, and dcmctl command lines and a method for adding a target to the grid using the Oracle10g SNMP Intelligent Agent. The focus will be on optimizing usage of administration, performance, and metrics handling on hosts, databases, application servers, high availability, and other significant. The presentation includes both a study of the Grid GUI and command line interfaces and relevant process in interaction with different targets involved. It will emphasize the convenience of using grid control over other IT resource management tools. Overall grid deployment and an ARIMA-based mathematical tuning model is proposed and briefly outlined.

Anthony D. Noriega is a computer scientist who has focused his efforts in database technology, network computing, software engineering, and object-oriented programming paradigms. At ADN/ebPortal, Anthony spends most of his time as a database analyst, architect, and developer, and DBA.  Mr. Noriega is an OCP-DBA and he holds an MS Computer Science from NJIT, an MBA from Montclair State, and a BS in Systems Engineering from University of the North. He has been a consultant for AT&T, M&M Mars, Tosco, Honeywell (Allied-Signal) and an associate for Deutsche-Bank, Bowne & Co, Reed-Elsevier, MCS Canon, and FMC. He is the author of several technical papers and a presenter and exhibitor at IOUG LIVE, Oracle Open World and NYOUG events. He is fluent in Spanish and French. He is a Senior Oracle DBA/Developer.

Back to Top

An Introduction to Oracle 10g SQL Enhancements - This presentation will give you an introduction to and a working example of the SQL features introduced with Oracle 10g. This includes the following features: Regular Expression support, Case-Insensitive Sort and Search, Partition Outer Joins, MODEL Queries, CONNECT BY Enhancements and more.

Dave Anderson has 25 years of hands-on experience in the I.T. industry. The last 10 have been spent working with Oracle - as a programmer, administrator and instructor. Dave speaks regularly at Oracle conferences including NYOUG, ODTUG, CTOUG, VOUG, NOUG and SEOUC (where he won “Best of Conference” for his RMAN presentation).

Back to Top

SQL Developer: Oracle's Graphical Database Development Tool - There are many tools that allow you to interact with an Oracle database available in the market today.  These range from command line tools to rich GUI tools.  SQL Developer, Oracle’s newest graphical alternative to SQL*Plus, allows the database Developer a convenient way to perform basic tasks. With SQL Developer you can manage objects in Oracle databases.  You can browse, create, edit, and delete (drop) database objects; create, edit, and debug SQL statements and PL/SQL code; manipulate data; export and import database objects; and create reports.   Using a combination of presentation and hands on, this presentation walks through various aspects of the new tool, including editing and debugging PL/SQL, creating user defined reports and more.

Craig Silveira joined Oracle back in 1997. For the last 7 plus years, he has covered some of the largest financial services customers on Wall Street. His areas of specialization include Real Application Clusters, Replication, High Availability, Migrations and competitive benchmarks. Craig has focused on migration of non-Oracle databases to Oracle since the beginning of his career. He has performed over a dozen migrations from databases such as IBM UDB, Sybase, Informix and Microsoft SQL Server. He is regarded as an authority in this area and participates in spec reviews with the migration development team. Craig has also been involved in one of the largest open system data warehouse benchmarks as part of an effort to prove Oracle technology for the JPMC Credit Card Services group. Craig has worked with heritage JPMorgan Chase throughout his career.

Back to Top

Back to Top

2005 December General Meeting

3 Major Trends in the Oracle World - Over the past five years there are three major trends that seem to be molding the future of the Oracle database:
 The first is the adoption of clustering and an accelerating trend toward grid computing.
 The second is a movement toward Linux for smaller and mid-sized systems.
 The third is the pendulum swing first toward offshoring database work and then a shift away from offshoring and toward a new mixed model.

All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs.  This presentation shows how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

Essential Performance Forecasting - At a basic level, forecasting Oracle performance is absolutely essential for every DBA to understand and perform.  When performance begins to degrade, it’s the DBA who hears about it and is supposed to fix it.  It’s the DBA who has the most intimate knowledge of the database server, so shouldn’t he/she be able to forecast performance?  When a bunch of new users are going be added to a system, it’s the DBA who is quickly asked, “That’s not going to be a problem, is it?”  Therefore, DBAs need the ability to quickly forecast performance.  Low precision forecasts can be done very quickly and are a great way to get started with forecasting Oracle performance. This presentation will prepare a DBA to perform performance forecasting using basic queuing theory math.  It will also introduce more advanced forecasting methods.

Craig Shallahamer has 18-plus years experience in IT. As the president of OraPub, Inc., his goal is to empower Oracle performance specialists by "doing" and teaching them to "do" whole system performance optimization (reactive and proactive) for Oracle-based systems.  In addition to course development and delivery, Craig is a consultant who is involved in product development, technically reviews Oracle books and articles, and keynotes at Oracle conferences.

Back to Top

Performance Monitoring and Tuning RAC/Grid - This presentation will answer your questions about how database tuning is different in a RAC or Grid environment.  It will also cover some common things to watch for in your RAC/Grid environment. It includes many RAC/Grid scripts, what to look for in statspack when you have RAC/Grid and a quick look at 10g Enterprise Manager.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

Oracle 10g New Job Scheduler - This presentation explains how the Job Scheduler works within the Oracle 10g architecture. It will discuss the benefits of the new Scheduler in comparison to the old DBMS_JOB as well as how you can convert existing DBMS jobs to the Job Scheduler. A demo will be included to show how to create new jobs as well as how to move existing DBMS jobs to the Scheduler, troubleshoot, and manage the new Scheduler. It will also explain how to create a chain of jobs and how to prioritize and allocate the resources to the jobs.

Inderpal S. Johal has been working as Database manager, Lead Database Administrator and architect for the last 10 years. He has written Oracle technical articles for Journals and magazines including Oracle Magazine. He has also spoken at Oracle OpenWorld, IOUG, UKOUG, NJOUG, NYOUG and DBA online. He has a Masters Degree in Computer Science from Punjabi University and worked as a Lead DBA for AT&T, UPS, Chase Bank, Citicorp, and Prnewswire. Indy can be reached at indy.johal@prnewswire.com

Back to Top

The J2EE Server: The Black-Box in the Oracle World? - Conventional performance management and database tuning lead to finger pointing between owners and developers of Oracle and Java systems.  This is due to the lack of visibility into the exact causes of bottlenecks on the tiers of Web, J2EE and Oracle servers.  Conventional technologies monitoring the Java server treat the database as a black box without identifying details of how Oracle impacts Java processes.  They also leave the DBA with no visibility into J2EE applications.  This session will cover how Wait Time methods can be used to track detailed end-to-end transaction performance in a multi-tier system, showing the interaction between Oracle databases and the Java applications they serve.

Don Bergal is the Chief Operating Officer at Confio and is responsible for overseeing all of the company’s sales, marketing, product management and business development initiatives. Don has over 15 years experience in the software, services and data communications industries, most recently with software developers Jabber, Inc. and Antepo, leading companies in the XMPP Instant Messaging market. He served as Vice President of Business Development for Antepo, launching the company’s US operations. As Vice President of Marketing at Jabber, Inc., he led the product marketing, demand generation and communications programs, and established and executed the technology partnerships and positioning for Jabber, servicing the enterprise, ISP and mobile network marketplaces.

Back to Top

Oracle 10g's Expression Filter Uncovered - In an age where we are increasingly moving towards data warehouse environments, being able to store information about your business’ customer buying trends, demand analysis, task assignment, and information distribution, is becoming more valuable than ever. Reporting on this type of information can be greatly enhanced with the use of Oracle 10g’s Expression Filter. Expressions help developers/users describe interests in expected data. Developers can store, index, and evaluate conditional expressions in one or more columns of a relational table. Data of interest is identified when Expression Filter matches incoming data with stored column expressions. Complex relationships can be derived when expressions in one table are matched with data in another table. Additionally, Expression Filter enables reuse of conditional expressions in business rules by storing them in the database and separating them from the application. This presentation provides an introductory overview of this feature. 

Melanie Caffrey is a lead consultant for Proximo Consulting Services, Inc. in New York City, providing front-end and back-end Oracle solutions for the business needs of various clients. She is co-author of several technical publications including Oracle Web Application Programming for PL/SQL Developers, The Oracle DBA Interactive Workbook, and Oracle Database Administration: The Complete Video Course, all published by Prentice Hall. Additionally, she instructs students in Columbia University’s Computer Technology and Applications program in New York City, teaching courses in advanced Oracle database administration and PL/SQL Web development tools, and she is a frequent Oracle conference speaker, having most recently presented at IOUG - 2005.

Back to Top

Reducing and Eliminating “Planned Outages” when Moving to Oracle 10g - Drawing on 10 years of experience with Oracle in database development and within the data recovery/high availability group, this technical presentation is designed for those planning or evaluating a move to Oracle 10g, including RAC and ASM.Oracle 10g offers a wide variety of new features and enhancements, ranging from superior performance and availability to security. In 10g, Real Application Clusters (RAC) increase reliability for your mission-critical applications and offer better manageability using Automatic Storage Management (ASM). But as with any upgrade and migration project, moving to Oracle 10g requires a well-planned approach that mitigates risk, minimizes downtime, and poses the least amount of complexity. Traditionally, database upgrades and migrations have always required planning a lengthy outage. With stringent service level commitments, many companies may delay moving to Oracle 10g to avoid the impact of service outages. This presentation serves to accomplish two goals:
(1)   Technically compare and contrast different approaches and solutions that may be considered for moving to 10g
(2)   Review a step-by-step process and configuration using “transactional data management” solutions that can provide near-zero or zero downtime for such projects.

Different migration scenarios will be considered, including 8i to 10g, 9i to 10g, cross platform, RAC, ASM, and non-Oracle to 10g.

Alok Pareek is a solutions architect for GoldenGate Software’s High Availability and Disaster Tolerance offerings, bringing more than 10 years of database development experience from Oracle’s Recovery/High Availability area. He was responsible for the redo generation component of the Oracle database from 8i to 10.2, and his significant (patent-filed) contributions at Oracle include the development of Cross Platform Transportable Tablespaces (Oracle 10g), Multi-threaded redo generation (9i), multiple block size cache support (9i), and whole database transport (10.2). He has presented technical sessions at Oracle OpenWorld and regional Oracle user group meetings, and holds a graduate degree in Computer Science from Stanford University.

Back to Top

Back to Top

2005 September General Meeting

Along with updates from the previous week's Oracle OpenWorld in San Francisco, Ken will discuss the evolution of the related concepts of Grid Computing and Service Oriented Architecture.  He'll discuss recent developments in Oracle's Database and Fusion Middleware product families.

 

Ken Jacobs - VP Product Strategy, Oracle Server Technologies
Since helping to establish the first Oracle office in Washington, DC in 1981, Ken has been a prominent spokesperson for Oracle and an advocate inside the company for customers' interests.  He has held a number of technical and management roles for Oracle, including consulting, support, product management and product marketing. Ken is also often a featured speaker at Oracle conferences and events and is known as "Dr. DBA" to thousands of Oracle Database administrators.   He is the Oracle liaison and a member of the board of directors of the International Oracle User Group (IOUG).

Back to Top

Best Practices for Managing Databases

The complexity of managing databases has increased so significantly some are considering Outsourcing as their only relief.  New regulations are driving IT Governance that further increases the pressure on IT as ways are sought to reduce costs and still effectively manage the myriad of databases supporting business. Auditors, consultants, ITIL, COBIT, ISO, Six Sigma - what is a DBA to do? This presentation focuses on the new business challenges, best practices approach to managing relational databases, and where and how database administrators should be educating themselves and spending their time to be successful in business.

Steve Lemme Steve Lemme is a Director of Product Management at Computer Associates International, Inc. (CA) for the Unicenterâ Database Management product solutions. Mr. Lemme joined CA in 1993 upon its acquisition of Platinum Technology International, Inc. where he was responsible for product management and marketing for distributed database tools. Mr. Lemme is author of the book Implementing and Managing Oracle Databases. He serves as a Director on the International Oracle Users Group board and is Vice President of the Arizona Oracle Users Group. He is a regular speaker at IT industry conferences worldwide and a monthly columnist for Database Trends and Applications Magazine.

Back to Top

Improve Performance & Comply with SOX

Sarbanes-Oxley, Gramm-Leach-Bliley, Basel II requirements effect almost everyone in IT including data professionals. Using data compliance audit and enforcement tools from Oracle and other software providers can deliver important performance, productivity and data management benefits, in addition to meeting compliance demands. Learn how companies use some of these compliance tools to increase performance and business value.

 Chris Doolittle is Vice President of Product Management and a founder of Teleran Technologies, a database and application usage management software company. He has over 25 years of experience in the IT industry working in data intensive application environments including data warehousing, financial analysis and business intelligence.  Mr. Doolittle has held technical management positions at companies such as General Electric, Pepsico, Information Builders and Metaphor.

Back to Top

Oracle’s new Automatic Workload Repository (AWR) component automatically places important Oracle performance data right at your fingertips.  The data structures are remarkably similar to the STATSPACK utility. This presentation will show attendees how to easily write custom AWR reports to gather important time-series performance information. Attendees will get a better understanding of the AWR table structures, see the similarities between AWR and STATSPACK, learn how to write AWR scripts and see how to create time-series exception reports

Donald K. Burleson is considered one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems. A former Adjunct Professor Emeritus, Burleson has written over 30 books, published more than 100 articles in national magazines, and serves as Series Editor for Rampant TechPress.

Back to Top

This presentation will discuss what JavaServer Face (JSF) is all about - components. It will give attendees a new perspective on application development and what can be done with the new standard - JavaServer Faces. The session will also cover Oracle's extensive component library for JSF - ADF Faces, and Oracle JDeveloper 10.1.3 JSF design time support.

Jonas Jacobi is a Principal Product Manager and Evangelist for Oracle JDeveloper and is responsible for the JSF and ADF Faces development features within JDeveloper. Before Joining Oracle, he worked at several software companies in Europe, covering many roles ranging from support, consulting, development and project team leader. Jonas holds a Bachelor's of Science in Computer Based Pneumatics with a specialization in Computer Science. Jonas is currently authoring a book Pro JSF: Building Rich Internet Components for Apress.

Back to Top

Attendees will learn how to lower the cost of secure information availability through automated database management functionality. Topics covered will include:

1. New features for backup and recovery using RMAN 

2. New Features for Security 

3. Self Manageability Features

4. New Features for Data Guard 

5. Miscellaneous other features of 10gR2 

Ranbir Singh, Sr. is a Principal Instructor for Oracle University. His areas of expertise include: High Availability Oracle Solutions (Real Application Clusters), Data Guard, Adv Replication, Performance Tuning, SQL Tuning and RMAN). Ranbir has 20 Years of IT industry experience in Education, Health Care, Publishing, 12 of those with Oracle and 5 years as a DBA and SA.

Back to Top

You wrote an explicit cursor? You declared a variable using the VARCHAR2 datatype? You raised an exception to skip over unnecessary lines of code? You used a cursor FOR loop to process data one row at a time? If slip-ups like these sound familiar (or if you don't know why these are mistakes), this presentation will show you how to correct such mistakes to improve the maintainability and performance of your application.

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written nine books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all from O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992) and serves as a Senior Technology Advisor to Quest Software. His latest projects include Qnxo, the world's first active mentoring product (www.qnxo.com) and Oracle PL/SQL Programming 2005, a conference on and celebration of the PL/SQL language (www.oracleplsqlprogramming.com). You can reach Steven at steven@stevenfeuerstein@com.

Back to Top

Upgrade Completed Successfully! Has it Really?

This presentation will look at what should be done pre-upgrade, planning for an unfortunate need to back out, and development of a bullet-proof checklist to assist the process. It will discuss what tests to perform at the infrastructure level (e.g., constraints and triggers) as well as looming character set issues that can creep up if not attended to. Items as detailed as object counts before and after (outside of the data dictionary) are crucial for ensuring that an upgrade was truly 100% successful. This presentation will cover the bases, and address issues that are all too often neglected during a database upgrade process.

Michael S. Abbey is a frequent and popular presenter at Oracle user group and vendors forums, having assembled a following in the software community over the past 17 years. He helps facilitate the IOUG's annual event, a cooperative effort for 2006 with the Oracle Applications User Group and Quest, in Nashville next April 23-27.

Back to Top

Project Fusion is the consolidation of the technology stack between the Oracle E-Business Suite, PeopleSoft, and JD Edwards. This session will present the technology upon which Project Fusion is based, focusing mainly on JDeveloper and the Oracle Application Development Framework (ADF). A technical overview and roadmap of the architecture (Oracle ADF, JavaServer Faces) will be discussed along with how customers can already take advantage of these open standard technologies to simplify and increase productivity for their J2EE development.

Lynn Munsinger is a Principal Product Manager in the Java Tools Development group at Oracle, specializing in EJB, TopLink, and ADF.  She has been working at Oracle since 1998, initially in product support, and then as a Curriculum Developer for JDeveloper courses.  She is the author of many Oracle University courses, including, "Oracle10g: Build J2EE Applications.”

Back to Top

This presentation is a "How Oracle works at the block level" presentation. It will cover how to do block dumps and read them.  Attendees will also learn how Oracle moves things at the block level, how blocks move from disk to memory, how they become Current blocks, how they become Consistent Read (CR) versions and other interesting tidbits of information that only keep you from achieving the business goals of the company.  Rich will also discuss some of the cool x$ tables out there that you should stay away from including many that begin with x$ksm  (like x$ksmsp - kernel storage memory SGA heap) what they'll reveal to you, as well as why the move toward 64-bit technology, memory resident databases and RAC/Grid makes this even more important to understand.

Rich Niemiec is CEO and co-founder of TUSC.  TUSC is an Inc. 500, Chicago-based systems integrator of Oracle-based business solutions. Rich is the past President of the International Oracle Users Group (IOUG) and also the current President of the Midwest Oracle Users Group.  In 1999, Rich authored the Oracle Press bestseller “Oracle Performance Tuning Tips & Techniques,” and in 2003 he authored “Oracle9i Performance Tuning Tips & Techniques.”

Back to Top

This presentation describes how Oracle 10g Portal can be configured to authenticate users based on an organization’s existing Active Directory tree.  Deployment details are provided for the Oracle Directory Integration and Provisioning component, the Active Directory External Authentication Plug-in, and the Windows Native Authentication scheme.

Craig Warman is Chief Technical Officer at Computer Resource Team, Inc., a consulting practice in Virginia.  He has presented at Oracle venues that include Oracle OpenWorld, IOUG-A Live, ODTUG, UKOUG, OAUG, NYOUG, SEOUC, and VOUG.

Back to Top

This presentation will highlight some of the most valuable techniques & features for monitoring databases and managing scheduled jobs with OEM 10g R2.  It will also discuss some scripts & scripting methodology for creating jobs to manage data.  Enhancements to OEM in 10g including R2 will be highlighted and the presentation will end with time for Q&A.

Lucas Lukasiak is a Senior DBA with Verizon Wireless and has been working with Oracle since version 7 in 1998.  He co-founded the Connecticut Oracle Users Group (http://www.ctoug.org/) in 2003 and is currently serving as President.  Lucas also leads a team of Decision Support Systems  professionals to deliver enterprise reporting, multi-dimensional data, and OLAP applications.

Back to Top

Attendees will learn what the view layer is; the popular alternatives for creating view layer code in JDeveloper 10g -- JSP, UIX, and JSF; how to create these styles of code in JDeveloper 10g. This presentation explains these view layer technologies and describes how to develop them using Oracle JDeveloper 10g. It reviews the principles of the MVC design pattern as a context for the view layer discussion. The presentation also discusses JSP, UIX, and JSF architectures, code libraries, coding styles, benefits and drawbacks, key features, and  intended uses. In addition, it provides conclusions about which style is best for specific situations. Additionally, the presentation will  demonstrate how to develop a web application using JDeveloper.

Peter Koletzke is a technical director and principal instructor for the Enterprise e-Commerce Solutions practice at Quovera, in Mountain View, California, and has 20 years of industry experience. Peter has presented at various Oracle users group conferences more than 130 times and has won awards such as Pinnacle Publishing's Technical Achievement, Oracle Development Tools Users Group (ODTUG) Editor's Choice, ECO/SEOUC Oracle Designer Award, and the ODTUG Volunteer of the Year. He is an Oracle Certified Master and coauthor of 6 Oracle Press books.

Back to Top

Participants will learn exactly what data mining is and what types of business problems it is meant to solve.  Through short examples, they will learn to recognize the types of business questions that can be answered by using data mining techniques, as well as their limitations.  Finally, the presentation will include a brief overview of Oracle's Data Mining solution.

Carol Brennan Baldan has worked with Oracle for nearly ten years as a developer, DBA, and technical manager.  She is an Oracle9i Certified Database Administrator and a recent recipient of a Master of Business Administration degree from the Stern School of Business at New York University, where she specialized in Statistics and Operations Research.

Back to Top

Attendees should come away with some knowledge of how to put RMAN® to use in their companies and how to accomplish basic RMAN® tasks including recovery, point-in-time recovery and cloning.  Scripts will be provided. This presentation will review some of the reasons for choosing RMAN® and show how our old friend has become even better with age including implementation strategies and options you can select to customize an RMAN® implementation to fit your company’s needs. The presentation will include the once ominous but now so important task of cloning (duplicating) databases.

Ruth Gramolini has been an Oracle DBA for 7+ years with the State of Vermont Department of  Taxes.  Ruth had been system manger and DBA for an HP3000 system running the proprietary Image Database for 14+ years before this. Prior to this, she was a research and statistic analyst.

Back to Top

Participants will be introduced to Oracle HTML DB 1.6 beginning with an overview of the architecture. Discussion will include the various steps involved in building a database-centric Web application with reporting and form building capability. Application items, buttons and page processing will also be explored. Workspace administration and security implementation through authorization and authentication schemes will also be discussed and, time permitting new features in Oracle HTML DB 1.6 vs. HTML DB 1.5 will also be covered.

Wayne Abbott is a manager at Oracle University with credentials that include senior principal instruction in the area of languages and tools. Wayne has 12 years tenure at Oracle with previous experience working with  hardware vendors including Unisys.

Back to Top

2005 June General Meeting Presentations

Back to Top

Back to Top

DBA TRACK

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

Back to Top

2005 March General Meeting

DBA TRACK

Aaron Newman
Application Security, Inc.

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

Tanel Põder - integrid.info

Back to Top

Back to Top

Back to Top

2004 December General Meeting

DBA TRACK

Back to Top

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Back to Top

2004 September General Meeting

DBA TRACK

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

DEVELOPER TRACK

Nick Donatone - MFG Systems

Back to Top

Back to Top

Back to Top

Back to Top

APPS TRACK

Back to Top

Back to Top

Back to Top

Back to Top

2004 June General Meeting

KEYNOTE: Wouldn’t It Be Nice if Things Worked That Way? - This presentation pokes a bit of fun at ourselves and Oracle. In the midst of our hectic day-to-day world, Michael always finds a way to lighten up the perspective and offer new ways of looking at ourselves and this wonderful software we call Oracle.

Michael S. Abbey is a frequent presenter at technical events in North America and Europe. He has accumulated an avid following in the Oracle user group community, having served on the board of directors of the IOUG from 1992 until 2000. Michael was re-elected to the Board in the 2002 election process, and was responsible for the delivery of Live! 2004 in Toronto. Michael is co-author of 12 successful works in the Oracle Press series, the most recent being Oracle Database 10g: A Beginner's Guide. Since 1999, he has been the technical lead for the remote DBA team at the Pythian Group in Canada's capital.

Back to Top

Back to Top

Neat Things to Help Manage Partitioned Objects - When we embark on a course involving management of partitioned objects, we are all so keen and eager to implement all of the theory we have in our heads. Once we get started, we find a plethora of syntactical limits that interfere with the way in which we planned to implement our approach. This presentation will examine some tricks used during partition maintenance operations that, for example, do not invalidate global indexes. In addition, this presentation will offer assistance in building locally partitioned indexes and naming the containers with the same convention adopted for your tables. It will cover the author’s approach to naming conventions, and show attendees why partition object management is fraught with many obstacles, most of which are not difficult to circumvent.

Back to Top

I Love the Java Jive: J2EE Overview for Oracle Technologists - Lately, Oracle has been spending a large amount of time and resources implementing concepts published in the Sun Microsystems Java 2 Platform, Enterprise Edition (J2EE) specifications. Oracle customers must have a handle on the technology and options available in this relatively new world if we are to take advantage of current and future technologies. J2EE offers a myriad of possibilities and dizzying number of new acronyms. This presentation is aimed at explaining these to the Oracle technologist who well understands the "traditional" world of relational database design, development, and administration but who needs a quick tour of the Java J2EE landscape and a simple explanation of its terms and features. The presentation puts J2EE in perspective with Microsoft's offering .NET and discusses web deployment alternatives such as servlet and JSP pages as well as Java client alternatives. Finally, Oracle's product offerings in the Java space are outlined.

Peter Koletzke is a Technical Director and Principal Instructor for the Enterprise e.Commerce practice at Quovera, in Redwood Shores, CA (http://www.quovera.com.) Peter is a technical content manager for the IOUG web committee. He has presented over 120 times at various Oracle users group conferences and has won awards and acknowledgements such as Pinnacle Publishing's Technical Achievement, ODTUG Editor's Choice, the ECO/SEOUC Oracle Designer Award, ODTUG Volunteer of the Year, top-rated presentation at IOUG Live!, and is an Oracle University Oracle Certified Master. He is coauthor, with Dr. Paul Dorsey of the Oracle Press (Osborne McGraw-Hill) books: Oracle9i JDeveloper Handbook (also co-authored with Avrom Faderman), Oracle JDeveloper 3 Handbook, Oracle Developer Advanced Forms and Reports, Oracle Designer Handbook, 2nd Edition, and Oracle Designer/2000 Handbook. http://ourworld.compuserve.com/homepages/Peter_Koletzke

Back to Top

2003 December General Meeting

Back to Top

Oracle 10g HTML DB - HTML DB is targeted at opportunistic application developers, sometimes called power users who typically work on projects that need to be completed quickly and with small development teams. Learn how to rapidly build applications on your Oracle 9iR2 or 10g database using HTML DB.  This presentation will demonstrate how you can develop, secure, skin, and scale a data centric web application. Oracle database features including LDAP, Oracle Text, regular expressions, and of course SQL will be covered as well as the types of applications our customers are currently using HTML DB for.

Back to Top

Oracle 9i Streams: The Fast Information Sharing Technology - This presentation will discuss the architecture behind Oracle 9i Streams and focus on some of its practical application areas, compare it to other Oracle High Availablity/Failover options such as RAC, Advanced Replication, and standby databases. Some changes added to Oracle 10g will also be discussed.

Back to Top

New 10g PL/SQL Features & PL/SQL Programming Tips - This presentation will give an overview of the top new PL/SQL 10g features including performance improvements, support for regular expressions, as well as sparse array bulk binds.  Tips about writing HTML DB may help improve the performance of your PL/SQL code.

Back to Top

Oracle Change Data Capture (CDC) - Sometimes you need to know what information has been changed in your database.  It may be for reports or as a part of an elaborate ETL process. If the database wasn't designed with this in mind, you may have to develop a custom solution. This can be a costly and error-prone process including triggers and big inefficient queries.  The alternative is to use Oracle's 9i feature - Change Data Capture (CDC). This is a nice solution and completely independent from the rest of the database design.  However, there is still the problem of Tmaking sense of the Oracle documentation. This presentation will demonstrate some of the benefits of using CDC.

Back to Top

Oracle Spatial: Enabling Locational Analysis in Oracle - Locational analysis is an important component of most business applications. Such analysis ranges from visualizing customer and business locations on maps, identifying potential customers in store neighborhoods, identifying potential sites for new businesses, computing routes for delivery trucks to customer addresses to analyzing raster images of weather patterns etc.

Traditionally, such analysis using locations of objects has been possible only through proprietary tools from GIS vendors.  Oracle Spatial offers a rich set of functionality for analysis based on object locations: it provides efficient mechanisms for storing, managing, querying, analyzing and visualizing data objects using their locations inside an Oracle database. In this talk, we give an overview  of the existing spatial functionality in Oracle 9i and the new functionality in Oracle 10G.  We illustrate how to integrate such functionality in existing applications running on Oracle database and describe some customer applications using Spatial.

Back to Top

Experience the GRID Today - This presentation discusses the benefits, challenges, and results of deploying applications on Oracle 10g Real Appllication Clusters (RAC), with a focus on implementation using generic Intel-based hardware and Linux environments.

Back to Top

2003 September General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2003 March General Meeting

Back to Top

How to Set Up Apache and JSERV w/Oracle XSQL, JSP, and Developer - This presentation examines the steps needed to set up the Apache Web Server so that it is fully integrated with Oracle8i web products.

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 December General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 September General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 June General Meeting

Back to Top

2002 March General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2002 January General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2001 June General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

2001 March Training Day

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

2000 December Training Day

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

1999 December General Meeting

Back to Top

Back to Top

Back to Top

1999 September General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

1999 February General Meeting

Back to Top

Back to Top

Back to Top

Back to Top

Back to Top

General Information - Developer

Back to Top

Back to Top