Tuesday, September 9 -- Tom Kyte!

Here is where we post UNYOUG events. The latest three entries show up on the right side of the main page for registration.
Post Reply
Jer
Site Admin
Posts: 40
Joined: Tue Jan 09, 2007 11:49 pm
Location: Rochester, NY
Contact:

Tuesday, September 9 -- Tom Kyte!

Post by Jer »

UNYOUG is hosting Tom Kyte for an all-day seminar!

When: Tuesday, September 9, 2008 8am - 5pm
Where: MCC - Brighton Campus - R. Thomas Flynn Campus Center - Monroe A & B (Map)
Cost: FREE for UNYOUG Members
(can become a UNYOUG Member the day of the event - fee for membership is $20, use PayPal here or please bring a check or cash)

REGISTER NOW

IMPORTANT NOTES:
- Registration prior to the event is REQUIRED
- Space is limited and registrations will be taken on a first-come first-served basis
- Breakfast and lunch will be provided
- FREE parking in Lot M

Seminar Details:
*  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 day-to-day work.

*  Effective Indexing
Indexing is a large and somewhat ignored topic.  We all know that “indexes are good”, but what kind of index is appropriate, and under what circumstances?  How does the type of index affect us?  What are the considerations you want to be thinking of when coming up with your indexing scheme.  This session will explore those topics as well as explore the physical structures underlying each discussed index type.

*  Storage Techniques
How data is stored on disk by Oracle directly affects the speed at which we can retrieve that data (and modify it, and create it and so on).  This session will look at the physical structures available to us, discuss when to use each (and when not to!).  Techniques such as clustering, index organized storage, partitioning and compression will be investigated.

About Tom Kyte:
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.


Platinum Sponsors:
Image
Image

Gold Sponsor:
Image

Silver Sponsors:
Image
Image
Last edited by Jer on Tue Jun 24, 2008 10:03 pm, edited 2 times in total.
Post Reply