Re: FREE Oracle DBA Tool (UX-Based)

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
  >