Please Register by emailing the following information to: Harry Conway 

• Your Name
• That you are a NCOUG member.
• Type of Industry (i.e. pharmaceuticals, telecom, textiles, etc.)

1:00 PM - Steve Karam (OCM) "Top Features of Oracle 10g"

Oracle 10g is truly a huge leap in the evolution of database engines. The jump to Oracle 10g is well worth the effort; and now, with extremely low downtime upgrades, it makes the upgrade even more enticing. This exciting presentation has a focus on the most important of the Oracle 10g grid new features for the DBA and developer.

2:45 PM  - Don Burleson - "Oracle 10g SQL Tuning Secrets"

This presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle10g features. The topics will include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, re-writing SQL queries in more efficient forms and the use of advanced techniques such as Materialized Views, replacing SQL with PL/SQL, the new automated CBO statistics collection, and using the new Oracle10g CPU costing approach.

Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.

Key Points:

- Learn about CPU costing vs. I/O costing
- Understand the new automated CBO statistics collection
- See how SQL profiles are better than stored outlines
- See the new 10g hints
- Look at the new SQL Tuning Advisor
 

 

     

                                         

NCOUG - The North Carolina Oracle Users Group

P.O. Box 511
Kittrell, NC 27544

e-mail contact:  Harry Conway, Executive director
Web site sponsored by Burleson Consulting (BC)