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 table scripts and Oracle view and cluster scripts, Mike Ault shares secrets for navigating the Oracle data dictionary.

This fantastic download allows you to quickly find sample Oracle scripts using using dba_tables, v$datafile, dba_data_files, dba_tablespaces, dba_tab_columns, dba_views, dba_snapshot_logs, dba_snapshots, dba_clusters, dba_clu_columns, dba_constraints, dba_cons_columns, dba_segments, dba_free_space, dba_tab_subpartitions, dba_nested_tables, dba_partitions,  dba_objects, dba_triggers, dba_trigger_cols, dba_source, v$parameter, v$enabledprivs, v$sqltext, v$session, v$mystat, v$sqlarea, v$sesstat, v$statname, v$rollname, v$rollstat, v$lock, v$process, v$waitstat, v$locked_object, v$transaction, and v$filestat.

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:

• Oracle table scripts using dba_tables, dba_tab_columns, dba_objects, dba_triggers and dba_trigger_cols.

• Oracle nested table scripts using dba_nested_tables.

• Oracle partitioned table scripts using dba_tab_subpartitions and dba_partitions.

• Oracle datafile scripts using dba_tablespaces, dba_data_files, dba_segments, dba_free_space

• Oracle view scripts using dba_views.

• Oracle snapshot scripts using dba_snapshots and dba_snapshot_logs.

• Oracle memory structure scripts using v$parameter, v$enabledprivs, v$sqltext, v$session, v$mystat, v$sqlarea, v$sesstat, v$statname, v$rollname, v$rollstat, v$lock, v$process, v$waitstat, v$locked_object, v$transaction, and v$filestat.

About the Author: