Re: FREE Oracle DBA Tool (UX-Based)

 The htto://dbamon.com site is working now (sorry about the problems yesterday). And yes the "orastat" tool is free. When you get to the home page, just click on the

"Download Free Oracle Admin Tool: orastat"

URL right below the DBAmon logo. You will then see a page where you can click DOWNLOAD. You then see the actual Perl source that you can save.

 Bill Border
 bb22_at_uswest.net
 Low-Cost, UX-Based Oracle/Informix Monitor: http://dbamon.com

Luca Nobili wrote in message <8mbkmq$4gc$1_at_serv1.iunet.it>...
>It is not free : - (((
>Bill Border <bb22_at_uswest.net> wrote in message
>o5Zh5.284$0k6.101190_at_news.uswest.net...
>>
>> 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
  >>
  >>
  >
  >