IOUG in partnership with DOUG presents "AskTom Live"
September 11, 2007

Don't miss AskTom Live, presented by IOUG and DOUG, taking place September 11, 2007, at the SMU Campus in Plano, TX. This is a unique opportunity to receive in-depth, focused Oracle technical knowledge and network with fellow Oracle users near you. Benefit from top-notch education without spending a long time away from the office or having to travel across the county!

Prepare for a full day of expert education with Tom Kyte, one of Oracle's leading experts and the voice of AskTom.com. The seminar will take place from 8:30am - 4:30pm and will include breakfast, lunch, snacks and session handouts.

Location:
SMU, Plano Campus
5236 Tennyson Parkway
Building 4, Room 100
Plano, TX 75024 – 3544
http://www.smu.edu/legacy/contactus/directions.htm

Schedule of Events

8:30am - 9:00am	Breakfast
9:00am - 10:30am	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 bindis 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 day-to-day work.
10:30am - 12:00pm	The Tools Tom Uses This first session gives an overview of (and practical use examples of) the common tools every Oracle developer and database administrator should master. Using AUTOTRACE and DBMS_XPLAN, TKPROF, and StatsPack. Tom will show how these tools relate to functionality in Oracle 10 g Enterprise Manager DBconsole. Additionally, more in depth tools are covered, such as DBMS_PROFILER , a self developed tool for benchmarking ideas "runstats", and using JDeveloper as a PL/SQL developer.
12:00pm - 12:45pm	Lunch
12:45pm - 2:15pm	Efficient Schema Design Based entirely on chapter 7 of Tom's book "Effective Oracle by Design", this session takes you through the fundamentals of physical schema design. It demonstrates the various structures (hash clusters, B*-tree clusters, index-organized tables, ...) and tells when and where you want to use them. The session closes with indexing and compression techniques.
2:15pm - 2:30pm	Break
2:30pm - 3:30pm	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.
3:30pm - 4:30pm	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).

If you have specific questions about the event, please contact Megan Price via e-mail at mprice@ioug.org or (312) 245-1579.

Online registration for Ask Tom Live is now closed. If you are interested in attending this event, please call (312) 245-1579 or e-mail ioug@ioug.org for more information.

BIO:
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 ( 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 Programing (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.