|
|
Oracle v$ scripts Collection
included in the:
Advanced Oracle Monitoring and Tuning Script
Collection
The complete collection
- 681
working Oracle scripts - Includes 10g RAC & Grid
scripts - Certified for 11g
Only $79.95
|
|
|
Packed with over
600
ready-to-use Oracle scripts, this is the definitive collection
for every Oracle professional DBA. It would take man-years to
develop these scripts from scratch, making this download the best
value in the Oracle industry.
Written by one the
world's top Oracle script developers and author of 20 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 v$ views and Oracle
data dictionary tables, Mike Ault
shares secrets for navigating the Oracle data dictionary.
This fantastic
download allows you to quickly find sample Oracle scripts for all
Oracle internal v$ views using
v$bh, v$parameter, v$database,
v$waitstat, v$sysstat, v$rowcache, v$lock, v$session, v$sgastat,
v$buffer_pool_statistics, v$logmnr_logs, v$statname, v$sesstat,
v$circuit, v$shared_server, v$librarycache, v$locked_object,
v$access, v$sqltext, v$sqlarea, v$log_history, v$pq_sysstat,
v$dispatcher, v$queue, v$rollname, v$rollstat, v$bgprocess,
v$process, v$latchname, v$latch, v$instance, v$sga, v$sort_usage,
v$datafile and v$filestat.
Script examples cover all important
Oracle DBA data dictionary views including dba_blockers, dba_lock,
dba_extents, dba_objects, dba_constraints, dba_cons_columns,
dba_running_stats, dba_rollback_segs, dba_tab_privs,
dba_ddl_locks, dba_sequences, dba_jobs, dba_utilities, dba_temp,
and dba_waiters.
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 scripts for SGA usage
including v$bh, v$pgastat, v$sql_plan, v$datafile and
v$locked_object.
-
Oracle scripts for process details
from v$waitstat, v$sysstat, v$session, v$sgastat, v$sesstat,
v$locked_object, v$access, v$sqltext, v$sqlarea and v$process.
-
Oracle scripts for locks and
latches using v$database,
v$waitstat, v$sysstat, v$rowcache, v$lock,
v$buffer_pool_statistics, v$statname, v$sesstat, v$circuit,
v$locked_object, v$access, v$sqltext, v$sqlarea, v$pq_sysstat
and v$latch.
-
Oracle multithreaded server MTS
scripts using v$circuit, v$shared_server, v$dispatcher, v$queue,
and v$process.
-
Scripts for session detail using
v$session, dba_lock, v$locked_object, dba_ddl_locks and
dba_blockers.
-
Dictionary relationships revealed
with dba_tables, dba_indexes, dba snapshots, dba_clusters,
dba_db_links and dba_sequences.
About the Author:
|