| |
 |
|
Oracle Tips by Burleson |
The Future of database 10g Self-tuning in
Oracle10g
As people get more sophisticated in their
self-tuning endeavors, many more Oracle metrics may become
self-tuning. In Oracle10g we see even more self-tuning capability, and
it becomes even easier to write detection scripts and schedule tasks
to adjust Oracle based on the processing needs. While there are many
new Oracle10g features that make automated tuning easier, the most
immediate features are the new dbms_advisor PL/SQL package and
the Java pool advisory utility:
-
Java
Pool Advisory utility – This helps predict the benefit of adding or
removing RAM frames from the java_pool_size memory region.
-
SQLAccess advisor utility - This is an exciting new Oracle10g
feature of the new dbms_advisor package that allows you to
get advice on the creation, maintenance and usage for indexes and
materialized views.
-
The
tune_mview advisor utility - This is a great new component of
the Oracle10g dbms_advisor package that allows you to get
expert advice on what materialized views can be used to hypercharge
your SQL queries.
 |
For more details and scripts, see my new book "Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
|
|
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
