Rahul,
For a start go to
ixora.com.au and run Steve Adams response_time_breakdown.sql script against each
of your databases. Paste the contents into a document with a little
commentary and you have a nice summary of any potential issues. I have
automated the process and get a daily diff of the script in a report each day
via email. Lets me know where my waits are occuring. If I see
something terribly unusual I investigate.
Another easy thing
to do is implement automated Statspack snapshots during peak periods and you
might spot some trouble there. This will at least qwell any fears of
performance trouble for the time being (or help you spot some). SAR
reports aren't a bad idea either because they are also easy to
automate.
- Ethan
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 i
n 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).
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 i
n 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).