RE: [Fwd: UNIX Performance Issues]

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
<http://www.orafaq.com> 
-- 
Author: Rahul Dandekar
  INET: rvd_oracle_at_hotmail.com <mailto: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 <mailto: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: Post, Ethan
  INET: Ethan.Post_at_ps.net

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).