Notes
Performance
Snapshot
Home

Version & Initialization Parameters
  1. Database Info
  2. Installed Product Version
  3. Init.ora Parameters
  4. Undocumented Parameters
  5. System Datafiles
  6. DB File Listing

Disk I/O, Events & Waits
  1. System Statistics (ALL)
  2. System Events
  3. SGA Statistics
  4. Hit Statistics
  5. Wait Statistics
  6. Datafile I/O

User Information
  1. User Creations / Dependencies

Full Table Scans
  1. System Statistics (Table)
  2. Process Table Scans
  3. Process Table Scans (Avg)

SORT Operations
  1. Sort Statistics

Rollback Segments
  1. RollBack Segments
  2. Rollback Transactions
  3. Rollback Contention
  4. Rollback Contention 2
  5. Rollback Extends and Shrink's

TableSpace's
  1. Tablespace Parameters
  2. Tablespace Coalesced Extents
  3. Tablespace Free Space
  4. Users Default To System Tablespace

Data Dictionary Info
  1. Dictionary Cache
  2. Latch Gets & Misses

Contention & Locking Problems
  1. Session Contention
  2. Object Contentions
  3. Transaction Lock Contention
  4. Locking Problems

Buffer Cache
  1. Buffer Cache Usage
  2. Buffer Objects Count
  3. Buffer CleanOut Frequency

Cursor & SQL Processing
  1. Disk Intensive SQL
  2. Buffer IntensiveSQL
  3. Buffer SQL w/Most Loads
  4. Cursor Processing
  5. Open Cursors By User
  6. Running Cursors By User
  7. Low Ratio Open Cursors
  8. Low Ratio Running Cursors
  9. Low Ratio Objects Access

Session Statistics
  1. Session I/O By User
  2. CPU Usage By Session
  3. Resource Usage By User
  4. Session Stats Grouped By Session
  5. Current Cursor Usage By Session
  6. User Hit Ratios

Shared Pool
  1. Library Cache Statistics
  2. Shared Pool Memory Usage
  3. Shared Pool Loads
  4. Shared Pool Executions
  5. Shared Pool Quick Check

Table  & Indexes
  1. Tables w/Questionable Indexes
  2. Tables With No Indexes
  3. Foreign Constraints Index Problems
  4. Inconsistent Column Names
  5. Object Extent Warning
  6. Segments with More than 5 Extent

Stored Procedures & Triggers
  1. List Triggers
  2. Pinned Packages

Redo Log Buffer
  1. Redo Buffer Statistics
  2. Redo Log Buffer Contention

Miscellaneous Reports
  1. Reserve Pool Settings
  2. Invalid Objects
  3. Checkpoint Interval Summary
  4. CheckPoint Intervals
  5. Parallel Server Statistics
  6. Write Request Queue Size Avg.
  7. Lazy DBWR Indicators
  8. Scheduled Jobs
  9. Table Clusters
  10. Database Links
  11. Database Snapshots