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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
