Oracle Training Oracle Support Development Oracle Apps

Free Oracle Tips


 E-mail Us
 Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote Support

 Remote Plans
 Remote Services
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote Support


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts







Rampant Oracle In-Focus Series

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

Buy Now

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:



    P. O. Box 511
Kittrell, NC, 27544