RE: UNIX Performance Issues

Get a copy of Oracle High Performance Tuning with Statspack by Donald Burlson. He has many scripts on doing exactly what you are asking for.

Good Luck.

John Fedock
john.fedock_at_kline.com
-----Original Message-----

Sent: Thursday, February 14, 2002 10:43 AM To: Multiple recipients of list ORACLE-L

DBAs,

This might be littlebit (or completely!) UNIX related... But I am told to do the performance analysis of some 10-15 machines and generate some statistical data to find out bottlenecks and identify areas of tuning...

Operating System : Solaris 2.6

I have been using sar, iostat, top...
I actually plan to script these things and run these scripts at certain intervals and put the data in database (Oracle 8i) and then do the crunching...
Inputs are appreciated...

1. I/O What is current I/O status. Is there a lot of I/O going on?
2. Paging Is there lot of swapping / paging happening? Which processes are getting swapped in/out continuously? Are the I/O waits due to swapping / paging or regular stuff like DB waiting to read from DB files?
3. CPU What is the CPU utulization? Which processes are using lot of CPU?
4. Memory What is the current picture of Real and Virtual Memory? What processes are using how much memory? Which processes are in real memory and which are in virtual memory? Which processes are swapped in and out from/to real/virtual memory and how many times?
5. Network What is the percentage utilization of network pipe? What is the capacity (bandwidth) of the network device? What percentage of that bandwidth is getting used? Is the system waiting for data from outside network I/O? In short, is there any bandwidth problem with network device or network traffic.

Thanks,

      ___           ___        ___           ___           ___
     /  /\         /  /\      /  /\         /  /\         /  /\
    /  /::\       /  /::\    /  /:/        /  /:/        /  /:/
   /  /:/\:\     /  /:/:|   /  /:/        /  /:/        /  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
    |  |:|::/     \__\::|      \__\::/   \  \:\  /:/   \  \:\
    |  |:|\/       |  |:|      /  /:/     \  \:\/:/     \  \:\
    |__|:|         |__|:|     /__/:/       \  \::/       \  \:\
     \__\|          \__\|     \__\/         \__\/         \__\/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  INET: rvd_oracle_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Fedock, John (KAM.RHQ)
  INET: John.Fedock_at_KLINE.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).