| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: FREE Oracle DBA Tool (UX-Based)
My hosting company has been having name server problems. Sorry :( If you try just http://dbamon.com without the www it seems to be more reliable.
Sorry,
Bill
-- Bill Border Agilent Technologies bb22_at_uswest.net Low-Cost, UX-Based Oracle/Informix Monitor: http://dbamon.com Will Stewart wrote in message <3988514E.35807D2B_at_home.com>...Received on Wed Aug 02 2000 - 00:00:00 CDT
> It isn't available now,i.e.
> "Description: Unable to locate the server named "www.dbamon.com" ---
>the server does not have a DNS entry. Perhaps there is a misspelling in
>the server name, or the server no longer exists. Double-check the name
>and try again. "
>
>
>> Bill Border wrote:
>>
>> 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
 |
 |