| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: FREE Oracle DBA Tool (UX-Based)
I'm really sorry, but my ISP tells me that the nameserver vendor that they use is having problems (not the first time). I have changed nameservers, but it will take (or so they said) 24 hours for the new name to propigate. If it's not fixed by tomorrow night, I will mail you a copy. It is a Perl script with many different subcommands to accomplish various lists, tasks, ...
Don't take the trouble to bookmark this, but the IP address (will get you to the same place) is:
Boy do I have egg on my face! Thanks in advance for your patience.
Bill
-- Bill Border Agilent Technologies bb22_at_uswest.net Low-Cost, UX-Based Oracle/Informix Monitor: http://dbamon.com Kirt Thomas wrote in message ...Received on Wed Aug 02 2000 - 00:00:00 CDT
>Is it a shell script? Anyway, I can't even resolve dbamon.com or
>www.dbamon.com. I'd love to see it, feel free to email me a copy :)
>
>On Wed, 2 Aug 2000 11:46:24 -0600, "Bill Border" <bb22_at_uswest.net>
>wrote:
>
>>
>> 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>...
>>> 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
>>
>
 |
 |