New Version 2.48 of orastat

  There is a new orastat command "orastat -dh" which will show the high-water-mark for used blocks in every datafile. orastat is a shareware tool that can be downloaded from: http://dbamon.com/orastat . Here are all of the available orastat commands:

2003/02/08-08:45:45 orastat | oraver=8.1.7 oraver3=8.1 sqlcmd=sp arg=-- arg2=
2003/02/08-08:45:45 orastat | ORACLE_SID=DBA ORACLE_HOME=/opt/oracle/product/8.1.7
2003/02/08-08:45:45 orastat | Version=2.48 Host=bigdog Company=agilent orastat | Version 2.48 Usage:

• View This Help File
  • Check for PMON Running, Show Oracle Version, Instance Status
    -ab List Archive Log RMAN Backups [Option Archive Log Sequence Number]
    -ad List Archive Destinations (v$archive_dest)
    -af List Archive Log Directory Contents
    -al Show All Archived Logs
    -an Analyze Table COMPUTE STATISTICS - 'orastat -an
    TABLE-OWNER.TABLE-NAME'
    -ar Show Current DB Activity Rate
    -au Show DB Audit Status
    -az Show Current DB Activity Rate - Log to
    /opt/oracle/adm/cronlog/db_activity_rate_.txt
    -ba List Contents of dbamon.backup_age Table
    -bc List Contents of buffer pool
    -bi List RMAN backup inventory -- [ALL|SINCE|BETWEEN]
    -bm List Tablespaces and Datafiles in Backup Mode (from v$backup)
    -bp List running RMAN backup sessions (if any)
    -br Backups: List all media written to since the last RMAN LVL0 backup
    -bs Create DDL to take datafiles that are in backup mode out of backup
    mode
    -c Configuration: View init.ora File
    -ce Configuration: Edit 'vi' init.ora File
    -cf List Control Files
    -ck List Time of Last Checkpoint (from v$datafile_headers)
    -cp Configuration: View Contents of v$parameter
    -ct Coalesce TEMP tablespace
    -cv Generate syntax to recompile INVALID Objects
    -dc List Datafiles in 'cp' commands to copy all datafiles elsewhere
    -de List All Datafiles, Online Redo Logs and Control Files (For
    Destroying a DB)
    -df List Datafiles - Optional FSCHECK 2nd parm to bdf filesystem
    -dh List Datafiles and their 'Used Blocks' High-Water-Mark
    -ec Configuration: Edit 'vi' config.ora File
    -er Display contents of DBA_ERRORS
    -ex Select from plan_table
    -fs Free Space in Each Datafile
    -ht Hot Tables
    -in List Indexes
    -iv List INVALID Objects
    -l List Archive Log Status
    -la Latch Details (from v$latch)
    -lf List Redo Log Files
    -lh Lock Holders/Waiter
    -li List Resource Limits (v$resource_limit)
    -lk Locks - Current TX (Non-Row) Locks
    -ln List DB Links
    -lo List Current Table Locks
    -ls Listener Status
    -lv List LVOL's / Usage
    -m View Last 20 Lines Of Alert Log
    -ma Cat entire Alert Log
    -mf Tail -90f Alert Log
    -mv 'vi' (read-only mode) Of Alert Log
    -nl List NOLOGGING Tables and Indices
    -ob Objects - With Decimal and Hex Object ID
    -op OPS: View V$PING - Lock Conversions
    -pb Performance: Current Data Block Buffer Hit Ratio - RIGHT NOW
    -pd Performance: View Data Block Buffer Hit Ratio
    -pf Performance: View Total Cumulative Free List Waits
    -ph Performance: Hot Blocks - Block With Latch Sleeps
    -pi Performance: View Histogram of Datafile I/O
    -pi Performance: I/O Service Times
    -ps OPS (Parallel Server) Status
    -pw Performance: Show segment names for tables with buffer waits
    -qs SQL Statment Count
    -ra List Rollback Segment Activity
    -rb List Rollback Segments
    -rc List And SHRINK All Rollback Segments
    -rd List And ALTER MAXEXTENTS UNLIMITED All Rollback Segments
    -rh List REDO Logs - History
    -rl List REDO Logs - Files
    -ro List Roles
    -rp RMAN Long Operation Progress
    -rs List REDO Logs - Status
    -ru Rollback Usage - By Session
    -sa Session Statistics - All Sessions
    -sb Standby DB - Show log gaps
    -sc Sessions - By Session CPU Time
    -sd Sessions - Details - Sessions, Running SQL and Waits
    -se Sessions
    -sg List SGA Usage
    -sh Shared Pool Usage & Tuning Recommendations
    -sl SELECT * from table - name supplied as 2nd parameter
    -sn SNAPSHOT - Run systemstate trace 3 times (for Oracle diagnostics)
    -so List sorts by user
    -sp List StatsPack Snapshot Data
    -sq Run SQL - Pass SQL as argument in single quotes
    -sr View Running SQL - 'orastat -sr SESSION_NUMBER'
    -ss List default storage clause for all TABLESPACES
    -st System Statistics - from v$sysstat
    -su List Active Sessions - From Users Table (Under Construction)
    -sw Session Wait Statistics
    -ta List All Tables - From DBA_SEGMENTS (Name, TS, Size, Extents,
    Maxextents)
    -tb Count Tables - By Schema
    -tc Create Backup Schedule Template from List Of Tablespaces
    -td describe table - name of table supplied as 2nd parameter
    -ti Table Info - 'orastat -ti TABLE-OWNER.TABLE-NAME [-count]'
    -tm List Temporary Segments
    -tp List Objects (from DBA_SEGMENTS) By BLOCKS and BUFFER_POOL - Show
    buffer pool stats
    -tr List Transactions
    -ts List Tablespaces
    -tt List 8i+ TEMPORARY Locally Managed Tablespaces
    -tu Temp space usage by user
    -tz List Tables - From DBA_TABLES - Shows ANALYZE data/timestamp
    -ub List the byte count of data, by User
    -ud List Users With ORADBA
    -ug List Users Table Grants (Much Output) - 2nd Parm is optional
    grantee name
    -un Display 9i UNDO Statistics
    -us List All Users
    -ut List the byte count of data, by User and Tablespace
    -v List Oracle version and whether it is 32-bit or 64-bit
    -vs List All Views
    -vw Count Views - By Schema
    -wr Wait Reasons - By User and Wait Type
    -ws Wait Stats - from v$waitstat