Hi All,
There is a free tool called "orastat" which is available at:
http://dbamon.com/ .
It runs from the UX (would also work on Linux) command line and it
simplifies
various DBA tasks (listing datafiles, tablespaces, users, I/O activity,
...). Here
is some sample output:
orastat -ts (Tablespaces)
orastat | ORACLE SID=PD1 ORACLE HOME=/oracle/PD1
Tablespace NumDF Size(MB) Free(MB) Used(MB) Pct
-------------------- ----- --------- --------- --------- -----
PSAPBTABD 11 15319 2800 12519 81.7
PSAPBTABI 9 10594 2138 8456 79.8
PSAPCLUD 5 2636 735 1900 72.1
PSAPCLUI 1 500 120 379 75.9
PSAPDDICD 3 939 411 528 56.3
PSAPDDICI 2 525 266 259 49.4
...
orastat -pi (I/O By Datafile)orastat | ORACLE SID=PD1
ORACLE HOME=/oracle/PD1
Pct Of
1000's 1000's
1000's DB I/O
Datafile Reads Writes
R+W Total
- ====== ====== ======
/oracle/PD1/sapdata2/btabi 2/btabi.data2 63345 9
63354 38.08% ****
/oracle/PD1/sapdata2/btabd 1/btabd.data1 32739 5
32744 19.68% **
/oracle/PD1/sapdata5/btabi 4/btabi.data4 20648 54
20702 12.44% **
/oracle/PD1/sapdata5/btabi 1/btabi.data1 17678 119
17797 10.70% **
/oracle/PD1/sapdata5/btabi 5/btabi.data5 9444 17
9462 5.69% *
...orastat Subcommands -- View This Help File
- Check for PMON Running, Show Oracle Version, Instance Status
-c Configuration: View init.ora File
-ce Configuration: Edit 'vi' init.ora File
-cf List Control Files
-cp Configuration: View Contents of v$parameter
-de List All Datafiles, Online Redo Logs and Control Files (For
Destroying a DB)
-df List Datafiles
-dc List Datafiles in 'cp' commands to copy all datafiles elsewhere
-l List Archive Log Status
-lf List Redo Log Files
-lk List Current Locks
-m View Last 20 Lines Of Alert Log
-pi Performance: View Histogram of Datafile I/O
-pd Performance: View Data Block Buffer Hit Ratio
-rb List Rollback Segments
-rc List And SHRINK All Rollback Segments
-rc List And SHRINK All Rollback Segments
-rd List And ALTER MAXEXTENTS UNLIMITED All Rollback Segments
-ro List Roles
-rh List REDO Logs - History
-rl List REDO Logs - Files
-rs List REDO Logs - Status
-se List Active Sessions
-sg List SGA Usage
-st System Statistics
-su List Active Sessions - From Users Table
-ta List All Tables - From DBA SEGMENTS (Name, TS, Size, Extents,
Maxextents)
-tc Create Backup Schedule Template from List Of Tablespaces
-ts List Tablespaces
-tz List Tables - From DBA TABLES
-ud List Users With ORADBA
-us List All Users You will see the "orastat" URL just under the
DBAmon logo on the home page.
Enjoy,
Bill
--
Bill Border
bb22_at_uswest.net
Low-Cost, UX-Based Oracle/Informix Monitor: http://dbamon.com
--
Received on Wed Aug 02 2000 - 00:00:00 CDT