| |
 |
|
NocOUG Summer Conference
2006
Oracle Tips by Burleson Consulting |
I will be speaking at the
NocOUG Summer
Conference at Chevron, San Ramon August 17, 2006
- 11:00 – 12:00 - "Oracle 10g SQL Tuning Secrets" by
Donald Burleson, Burleson Consulting, focus area: DBA:Developer
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.
- 1:00-2:00 "Creating a Self-tuning Oracle 10g Database"
by Donald Burleson, Burleson Consulting, focus area:DBA
Oracle started to create the mechanism for a self-tuning
database with Oracle 9i and has begun the automation of many
tuning actions in Oracle 10g. This exciting presentation will
show the Automated Storage Management (ASM) and Automated Memory
Management (AMM) tools and describe their internal mechanisms
for re-allocating RAM regions within the Oracle10g SGA. This
presentation also shows how you can extend upon these automation
features to make Oracle 10g even more self-managing. Using the
existing data from the Automated Workload Repository and
Active Session History tables, this presentation will show
you how to create sophisticated scripts to detect anomalies and
how to dynamically invoke the dbms_scheduler utility to
automatically repair the process. This is an indispensable
presentation for any Oracle professional who wants to know how
to automate their manual decision rules within the automation
framework of Oracle 10g. This presentation will show working
code from real-world Oracle 10g databases.
|
|
|
