OOUG Meeting Agenda October 10, 2006 print

  Featured Speaker: Tom Kyte  

Tom Kyte is a Vice President in Oracle's Public Sector 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. Kyte is also the author of the AskTom column in Oracle Magazine and the author of Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions (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.

Sponsored in part by:

Meeting Location:

5600 Post Rd
Dublin, OH 43017
(614) 410-4550

This facility provides free wireless internet access.

Registration:

Please register by Monday, October 2^nd, 2006 by sending email to membership@ooug.org.

If you need overnight lodging, see the list of local hotels.

Meeting Cost:

• Free for 2006 OOUG members
• $20 for non-member attendees

The meeting includes presentations, breakfast, lunch and snacks. Gift giveaways will vary but usually include drawings for Oracle books.  All attendees are automatically registered in the OOUG gift drawings. 

Occasionally, vendor representatives will offer additional gift drawings that require attendees to register directly with the vendor in order to be eligible to win a prize.  Registration for vendor gift drawings is entirely at the option of the attendee and is not governed by the OOUG's privacy policy.

Meeting Schedule:

Presentation Abstracts:

All About Binding

We'll briefly overview why it is extremely important with regards to performance, scalability and even security but quickly move into topics such as: Do I always want to bind? (Surprisingly, the answer is no.) What is bind variable peeking? Is it good or evil in disguise or a bit of both? So the developers don't bind; is cursor_sharing=force/similar appropriate system wide? (Emphasis will be on the reasons why setting cursor sharing at the instance level is not such a good idea.) What is the real difference between cursor_sharing=force/similar and which should we use under what circumstances? The presentation will be practical, with many examples and hard numbers you can use in your ay-to-day work.

J2EE: Black Box in the Oracle World

Traditional J2EE application performance monitoring tools that are intended to monitor, analyze, and resolve performance bottlenecks, generally fall short in its core mission. At issue is the inability to correlate collected system resource and server metrics to provide a clear resolution to performance problems within the J2EE web, application and database layers. Most Java performance tools lack visibility into the database and/or database tools lack visibility back into the Java layer(s). This session will cover how to extend Oracle Wait Time methodology to J2EE applications and gain end-to-end visibility from both the DBA and J2EE architects' perspective to help solve complex application problems.

Instrumentation 101

This session will talk about the importance of heavily instrumenting your code and explore the possible methods of instrumenting your code in an Oracle environment - concentrating on developed code both in the database (stored procedures) as well as outside the database (Java, C, VB and the like).

Performance Impact of the Log Errors Clause in 10gR2

This session will look at the new log errors clause available for use with BULK DML operations in the 10gR2 database. We will see what the clause does, investigate how it does what it does, explain limitations/restrictions inherent with using the clause and finally - compare the performance of slow by slow processing versus bulk DML with log errors - and maybe even compare bulk DML with and without log errors for performance.

Speaker Information:

Tom Kyte

Tom Kyte is a Vice President in Oracle's Public Sector 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. Kyte is also the author of the AskTom column in Oracle Magazine and the author of Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions (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.