Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FREE Oracle DBA Tool (UX-Based)

Re: FREE Oracle DBA Tool (UX-Based)

From: Will Stewart <internationalcomputers-tech_at_home.com>
Date: 2000/08/02
Message-ID: <3988514E.35807D2B@home.com>#1/1

   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
Received on Wed Aug 02 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US