was held on

February 8, 2005

at Oracle

in Redwood Shores, CA


Rate this conference


8:00 - 9:00 Registration and Continental Breakfast - Refreshments Served
9:00 - 9:30 General Session and Welcome - Darrin Swan, NoCOUG President
9:30 - 10:30 Keynote: Oracle Application Server 10g Release 2 Overview – Thomas Kurian, Senior Vice President, Oracle Corporation
10:30 - 11:00 Break
  Application Development
Room 102
Database Administration
Room 103
Oracle by Oracle
11:00 - 12:00
Session 1
Logical E/R Modeling: The Definition of 'Truth' for Data by Jeffrey Jacobs, Jeffrey Jacobs & Associates It’s Time to Do ASH by Gaja Vaidyanatha, Essentials of Real Application Clusters by David Austin, Oracle Corporation
12:00 - 1:00 Lunch
1:00 - 2:00 Ask Oracle - Question and answer session with a panel of engineers from Oracle Corporation.
In the auditorium. Bring your questions!
2:00 - 2:15 Break
2:15 - 3:15
Session 2
Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN by Roger Schrag, Database Specialists Inc. Oracle 10g Backup and Recovery New Features by Daniel Liu, First American Real Estate Solutions Minimizing Risks Though Deployment Standardization by Sudip Datta, Oracle Corporation
3:15 - 3:45 Break & Raffle
In the auditorium.
3:45 - 4:45
Session 3
Beginning Oracle SQL: Common Idioms by Les Kopari, Independent consultant A Structured Approach to Database Administration Using the Principles of ITSM and ITIL by Iggy Fernandez, Intacct Corporation Oracle10g for Data Warehousing by Hermann Baer, Oracle Corporation
4:45 - ? Late breaking news!  Oracle Technology Network will be throwing a Linux Installfest at the conference.  Come join OTN and watch as they demonstrate installing Oracle on Linux, or bring your laptop and get help installing Oracle Database 10g ( Enterprise Edition).  Learn about the powerful new features of Oracle Cluster File System 2 direct from Wim Coekaerts, the lead for Oracle's Linux Engineering Team, and ask him your questions about Oracle on Linux.  Free evaluation enterprise Oracle on Linux media from Novell, Red Hat, and Oracle.  Pizza will be provided!



Speaker Abstracts for Winter Conference


“Oracle Application Server 10g Release 2 Overview” - Thomas Kurian, Senior Vice President, Oracle Corporation

This presentation provides a detailed technical overview of the new features in Oracle Application Server and Internet Developer Suite 10g Release 2, the benefits they offer customers, and how customers can upgrade to Release 2. The session covers new features for J2EE, Web services, enterprise portals, business process automation, security and identity management, wireless and RFID, forms and reports, and business intelligence and analytics. Understand how you can deploy and manage enterprise applications using grid computing technology and learn technical details of how to best utilize Release 2 with your Oracle Database. The session also provides best practices for deploying your Application Server on the Windows and Linux operating systems and in a Microsoft .NET environment.

Application Development
“Logical E/R Modeling: The Definition of 'Truth' for Data” – Jeffrey Jacobs

Logical Entity/Relationship models, also referred to as "conceptual" or "semantic" models, define the information requirements of the enterprise, independent of the resulting implementation. A well defined E/R model is the key to successful development of data oriented applications. Although most frequently associated with relational databases, the logical E/R model is equally applicable to object oriented and XML implementation. This presentation will provide an overview of the fundamentals of E/R modeling as the definition of the information requirements of the enterprise. It will focus on the underlying concepts and notations, with a strong emphasis on the semantic content of the E/R model.

“Speeding Up Queries with Semi-Joins and Anti-Joins: How Oracle Evaluates EXISTS, NOT EXISTS, IN, and NOT IN” - Roger Schrag

Optimizing the SQL usually gives the most significant results when DBAs are called upon to “make the system run faster.” Using tools like Statspack or Enterprise Manager, it is often easy to find the slow SQL. But how do you make the queries run faster? That is the challenge! In this presentation we will discuss the semi-join and the anti-join, two powerful SQL constructs Oracle offers for use in your quest for faster queries. In particular we will define these two terms, discuss when and why you might want to use the [NOT] EXISTS or [NOT] IN constructs, and demonstrate how you can use optimizer hints and make minor query changes in order to enable Oracle to use some very powerful and efficient access paths. For certain classes of queries, these features can dramatically reduce logical reads, physical reads, CPU time, and elapsed time. But beware! There are some pretty obscure (and not well documented) requirements that must be met in order for Oracle to deploy the semi- and anti-join access paths. If you fail to dot an I or cross a T, you could be banging your head against the wall for hours! Throughout this presentation we will look at SQL from a real project and demonstrate live the “before” and “after” versions of queries that ran orders of magnitude faster once semi-joins and anti-joins were implemented correctly. Attendees should be very familiar with execution plans and join methods in order to get the most out of this presentation.

“Beginning Oracle SQL: Common Idioms” - Les Kopari

There are many common constructs—frequently used forms of SQL—for the common tasks that we are faced with on a day-to-day basis. For the beginning Oracle developer or DBA, this presentation will list some of these common idioms and the questions they answer. That may help beginners get a quick start.

Database Administration
“It’s Time to Do ASH” - Gaja Vaidyanatha

Oracle 10g promises to provide many new diagnostic capabilities for the performance enthusiast. Active Session History (ASH) is one such diagnostic feature that provides insight into the behavior of active sessions that are connected to the database. By retrieving information about active sessions over a period of time, it is now possible to truly determine the "true nature" of what one or more given sessions in the database is doing. This presentation will provide an overview of ASH, its architecture and setup.

“Oracle 10g Backup and Recovery New Features” - Daniel Liu

This presentation introduces two new features in Oracle 10g backup and recovery: ExtendedFlashback Functions and RMAN Enhancements. When user errors and logical corruptions occur in the 10g database, flashback functionality provides fast and flexible data recovery. The new flashback features include Flashback Database, Flashback Drop, Flashback Table, Flashback Version Query, and Flashback Transaction Query. When physical or media corruption occurs in the database, RMAN delivers an improved and simplified recovery method.

“A Structured Approach to Database Administration Using the Principles of ITSM and ITIL” - Iggy Fernandez

Change the IT world! Join the ITIL revolution! No amount of technical brilliance can substitute for a disciplined and structured approach to database administration. In the language of the Capability Maturity Model (CMM), most IT organizations rely on "individual heroics". The application of ITSM and ITIL principles generates a structured approach to database administration that is repeatable, defined, managed and optimizing. Come learn why ITSM and ITIL are being adopted by Fortune 500 companies such as Genentech and eBay. We will also discuss Oracle 10g support for ITSM processes.

Oracle by Oracle
“Essentials of Real Application Clusters” - David Austin

This presentation describes the basic architecture of a Real Application Clusters (RAC) installation. The RAC software components are placed in the context of the underlying cluster architecture and various disk storage options. The presentation also contains a brief comparison of RAC and Grid architectures. The presentation explains how to use some of the key features of a RAC database including virtual IP addresses, service assignments, plus the general benefits of a clustered database such as high availability and scalability. In addition, the presentation contains guidelines for the installation, configuration, and monitoring of RAC databases.

“Minimizing Risks Though Deployment Standardization” - Sudip Datta

As the data center grows, it becomes increasingly challenging to manage. This could potentially lead to more software resources and moving parts that are difficult to manage. This also compounds additional risks of non-compliance and vulnerabilities that may lie undetected in the enterprise. This presentation discusses the implementation of a standardized approach to deployment that helps put some discipline in management and hence minimizes the risks.

“Oracle10g for Data Warehousing” - Hermann Baer, Oracle Corporation

Oracle10g introduces a plethora of new features to improve the performance, scalability and manageability of data warehouses. This presentation discusses emerging market trends and its influence on key design criteria - from a system as well as Oracle perspective - for a successful implementation and discusses the key features and the benefits specific features provide for a selected architecture and schema implementation.


If you have suggestions for future meetings or would like to offer feedback on previous conferences, then please complete our online survey or send us an email.

Directions to the Oracle Conference Center

350 Oracle Parkway, Redwood Shores, California. Phone: 650-633-8300 Fax: 650-633-8399

Take Highway 101 South (toward San Jose) to the Ralston Ave./Marine World Parkway exit. Take Marine World Parkway east which will be left at the light. Make a left onto Oracle Parkway. 350 Oracle Parkway will be on the right.

Take Highway 101 North (toward San Francisco) to the Ralston Ave./Marine World Parkway exit. Take the first exit ramp onto Marine World Parkway. Make a left at the first light onto Oracle Parkway. 350 Oracle Parkway will be on the right.


Copyright © 2005 NoCOUG. All rights reserved.