|
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:
Mike Ault |
Mike Ault
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. |
|
