OraSnap 2008.01.14
Quick Links
Mini Snapshot

General
(snap7/8/9/10gen.sql)

  • Database Information
  • Product Versions
  • Database Options
  • License Information
  • Init.ora Params
  • Undoc'd Init.ora Params
  • All Init.ora Params
  • SGA Information
  • Datafiles / Database Size
  • Database File Listing

    Tablespaces
    (snap7/8/9/10ts.sql)

  • Tablespace Information
  • Tablespace Quotas
  • Tablespace Coalesced Exts
  • Tablespace Usage
  • Users Default (SYSTEM)
  • Objects in SYSTEM TS
  • Freespace & Largest Ext
  • AutoExtend Information

    Rollbacks
    (snap7/8/9/10rbs.sql)

  • Rollback Segments
  • Rollback Contention
  • Rollback Growth
  • Rollback Users
  • Rollback Transactions

    Users
    (snap7/8/9/10user.sql)

  • User Objects
  • User Space Allocated
  • Invalid Objects
  • Object Modification
  • User Privileges
  • User Accessing
  • User Session Count
  • User Hit Ratios
  • Datatypes
  • Default Passwords

    Tables & Indexes
    (snap7/8/9/10ti.sql)

  • Table / Index Locations
  • Questionable Indexes
  • Tables With > 5 Indexes
  • Tables Without Indexes
  • Tables Without PK
  • Table Chaining
  • Disabled Constraints
  • FK Constraints
  • FK Index Problems
  • Inconsistent Datatypes
  • Object Extent Warning
  • Large Objects
  • Segs > 50% Of MaxExts
  • Segment MaxExtents
  • Analyzed Tables
  • Recently Analyzed Tables
  • Cached Tables

    Partitions
    (snap8/9/10part)

  • Partitioned Tables
  • Partitioned Indexes
  • Partition Key Columns
  • Table Level Partitioning
  • Index Level Partitioning

    Objects
    (snap7/8/9/10obj.sql)

  • Database Clusters
  • Database Jobs
  • Database Links
  • Database Procs & Pkgs
  • Database Sequences
  • Database Snapshots
  • Database Synonyms
  • Database Triggers
  • Database Views

    Hit & Miss Ratios
    (snap7/8/9/10hmr.sql)

  • Buffer Hit Ratio
  • Library Cache Hit Ratio
  • Data Dict Hit Ratio

    Disk I/O, Events & Waits
    (snap7/8/9/10dew.sql)

  • System Statistics (All)
  • System Events (All)
  • SGA Statistics
  • Wait Statistics
  • Sort Statistics
  • Datafile I/O

    Full Table Scans
    (snap7/8/9/10fts.sql)

  • System Statistics (Table)
  • Process Table Scans
  • Process Table Scans (Avg)

    Data Dictionary
    (snap7/8/9/10dd.sql)

  • Dictionary Cache
  • Latch Gets & Misses

    Cursor & SQL Processing
    (snap7/8/9/10csp.sql)

  • Disk Intensive SQL
  • Buffer Intensive SQL
  • Buffer SQL w/ Most Loads
  • Open Cursors By User
  • Running Cursors By User
  • Low Ratio Open Cursors
  • Low Ratio Running Cursors
  • Low Ratio Objects Access

    Locks
    (snap7/8/9/10lock.sql)

  • Lock Information
  • SQL Assoc'd With Lock(s)

    Session Statistics
    (snap7/8/9/10sess.sql)

  • Session Time
  • Session I/O By User
  • CPU Usage By Session
  • Resource Usage By User
  • Session Stats By Session
  • Cursor Usage By Session

    Shared Pool
    (snap7/8/9/10sp.sql)

  • Library Cache Statistics
  • Shared Pool Memory Usage
  • Shared Pool Loads
  • Shared Pool Executions
  • Shared Pool Details
  • Reserve Pool Settings
  • Pinned Objects

    Redo Logs
    (snap7/8/9/10redo.sql)

  • Redo Log Information
  • Redo Log Switches
  • Redo Buffer Statistics
  • Redo Log Buffer Contention

    Two Phase Commits
    (snap7/8/9/10tpc.sql)

  • Two Phase Pending
  • Two Phase Neighbors

    Miscellaneous
    (snap7/8/9/10misc.sql)

  • Database Growth
  • Checkpoint Interval
  • Write Request Queue
  • Lazy DBWR Indicators

    Readme
    Revision History
    Homepage
    Updates
    Yahoo! Group

    Stewart McGlaughlin
    Oracle DBA