Purpose
Statistics of a table; empty blocks and leaf blocks
Statistics of a table, indexes; empty blocks and leaf blocks
Datafile backup
Row Cache statistics
Dictionary Cache statistics
Buffer Cache Hit Ratio statistics
Show the current executing SQL
Show the current executing Views
REPORT: SRL CASE ATTRIBUTE
Will reorganize a table that has chaining
Analyze the chaining of a given table
reports checkpoint related system statistics
Generate several space reports
REPORT: Script for ALL_INDEXES from index
Show statistics for all dba objects
Determine the data distribution of an attribute within a table
Defines who have locks and the type thereof
Determines who (sessions) have what types of locks
Defines sessions in a locking contention situation
REPORT: Sessions With The Highest I/O
session uga memory max
SQL driver to dump stats
script to show what activity is going on within database
Build the explain_plan table
polulate explain_plan table with query data
Format the explain plan syntax
Enhanced format the explain plan syntax
Produce the report of those users accessing the database
REPORT: Rollback Segment Report
Average records per block
Redo log file statistics
show the rollback segments, status and size for a database
Should the sga be increased?
Mathematical formulae to compute the shared_pool_size
scan for sort types and numbers
SQL statement activity
SQL statement for a specific statement identifier
SQL statements by user id
SQL statements ranked by disk I/O
Several statistical reports; hit ratio information
Load session wait information
Load session wait information for terminal
Session Wait Summary Report
beginning of standard statistic scripte
Ending of standard statistic script
Show statistics about v$backup
Show statistics about v$circuit
Show statistics about v$database
Show statistics about v$datafile
Show statistics about v$db-cache
Show statistics about v$dispatch
Show statistics about v$instance
Show statistics about v$lib_cache
Show statistics about v$latch
Show statistics about v$open_cursors
Show statistics about v$option
Show statistics about v$parameter
Show statistics about v$pq_stat
Show statistics about v$process
Show statistics about v$rollback
Show statistics about v$rowcache
Show statistics about v$session
Show statistics about v$sesstat
Show statistics about v$systat
Show statistics about v$waitstat
Measure the impact of removing "DB_BLOCK_BUFFERS"
Measure the impact of adding "DB_BLOCK_BUFFERS"
