Written by some of the world's most widely-read Oracle script developers and authors of best-selling Oracle books, They target substantial knowledge of Oracle data dictionary scripts in this concise download.  Benefit from decades of experience using Oracle datafile scripts and Oracle tablespace scripts,  share the secrets for navigating the Oracle data dictionary.

This fantastic download allows you to quickly find sample Oracle scripts for Working Oracle scripts using v$db_object_cache, dba_outline_hints, dba_outlines, dba_rsrc_consumer_group_privs, dba_rsrc_consumer_groups, dba_rsrc_manager_system_privs, 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.

Key Features:

• Provides SQL tuning information from v$db_object_cache and dba_users.

• Script for SQL resource usage from dba_rsrc_consumer_group_privs, dba_rsrc_consumer_groups, 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.