Format information about the browser users
Row Cache statistics
Dictionary Cache statistics
Buffer Cache Hit Ratio statistics
Show the current executing SQL
Show the current executing Views
REPORT: COES - Count Of Extents For DB Objects
Show all information about all objects
Display info about all the rollback segments and their status
Display information about: free space
Display tsps size, space utilization and extent growth
Display information about object size/growth patterns
Display stats after analyzing table/indexes
Database space and storage statistics
Routine to show status of Rollbacks
REPORT: DBAEXT - Table and Index Extents(w/o system)
REPORT: DBAEXTSYS - Table and Index Extents
REPORT: DBAFILES - DATA FILES REPORT
REPORT: DBAIND - Index Column Report
REPORT: DBAIND2 - Index Column Report
REPORT: DBAINDEC - Table and Index Extents
REPORT: DBAINDMFG - Index Column Report
REPORT: DBAUSERS - DBA User Report
REPORT: DCSTATS - Dictionary Cache Stats
Script to describe "all" tables
active data files
Oracle Database Utility Procedure
Script to backup the tablespaces
Count Of Extents For Database Objects
Extent and Tablespace Report
REPORT: Segments that exceed extent cnt
Extent and Tablespace Report:
check various database files
Print the size of the AP (financial) files
detailed data file I/O statistics (BM)
Fragmented TableSpace
Generate several space reports
REPORT: FREE200 - TS Free Space Report
REPORT: Detailed Free Space
REPORT: Total Free Space
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
REPORT: Orders imported from MOE system
UNIX script to see what Oracle tools are installed
script to show what activity is going on within database
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
Show how many rows-per-block are actually being stored
Segment Sizing
Shows the stats for a given session
show space prblms
Several statistical reports; hit ratio information
Load session wait information
Load session wait information for terminal
Session Wait Summary Report
REPORT: SYSALLOC - System Space Allocated
REPORT: SYSFREE - TS Free Space Report
Table Usage Parameters
Table Utilization
Summarize tablespace usage by segment type and user
Database Freespace Summary
Total Free Space Available
REPORT: TSQUOTA - DBA TS Quotas Report
Tablespace Per Segment Type Per User Summary
REPORT: Database Tablespace per User Summary
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