Written by one the
world's most widely-read Oracle script developers and author of 14 best-selling Oracle books,
Mike Ault targets his substantial knowledge of Oracle data
dictionary scripts in this concise download. With
decades of experience using Oracle datafile scripts and Oracle
tablespace scripts, Mike Ault
shares secrets for navigating the Oracle data dictionary.
download allows you to quickly find sample Oracle scripts for
Working Oracle scripts using v$db_object_cache, dba_outline_hints,
dba_rsrc_plans, dba_rsrc_plan_directives and dba_users.
Caution - These are extremely powerful
Oracle data dictionary scripts. They should only be used by
a certified Oracle DBA, and after a careful review of the Oracle
data dictionary script functionality. These Oracle scripts
are not for beginners and knowledge of the Oracle data dictionary
is required to fully utilize these scripts. USE AT YOUR OWN RISK.
Provides SQL tuning information
from v$db_object_cache and dba_users.
Script for SQL resource usage from
dba_rsrc_manager_system_privs, dba_rsrc_plans, dba_rsrc_plan_directives and dba_users.
Stored outline scripts from
dba_outline_hints and dba_outlines.
About the Author:
has five Oracle Masters Certificates. Ault was the first popular Oracle author with his book "Oracle7 Administration and Management"
and he also
wrote several of the "Exam Cram" books.