RE: [Fwd: UNIX Performance Issues]

2002-02-19 Thread Post, Ethan
Title: Message



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 toldto do the performance analysis of some 10-15 machines and 
generatesome statistical data to find out bottlenecks and identify areas 
oftuning...Operating System : Solaris 2.6I have been using 
sar, iostat, top...I actually plan to script these things and run these 
scripts at certainintervals and put the data in database (Oracle 8i) and 
then do thecrunching...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-5051San Diego, California    -- 
Public Internet access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling 
of 'ListGuru') and inthe message BODY, include a line containing: UNSUB 
ORACLE-L(or the name of mailing list you want to be removed from).  You 
mayalso send the HELP command for other information (like 
subscribing).


RE: [Fwd: UNIX Performance Issues]

2002-02-19 Thread James Morle
Title: Message



Hi Rahul.
 
Interesting, as ever!
See below
 
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
of "Scaling Oracle8i - Building Highly Scalable OLTP System 
Architectures" 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 
  19 February 2002 15:49To: Multiple recipients of list 
  ORACLE-LSubject: Re: [Fwd: UNIX Performance 
  Issues]
  James,
   
  Getting interesting, isn't it? I have added my 
  response...
   
  - Original Message - 
  
From: 
James Morle 
To: Multiple recipients of list ORACLE-L 

Sent: Tuesday, February 19, 2002 8:58 
AM
    Subject: RE: [Fwd: UNIX Performance 
Issues]

Rahul,
 
Here's what I would do. 
1) I would use "mpstat" for the processor statistics. 
This breaks the usage up by processor in SMP configurations. This can be 
useful to see the relative loading of each CPU, in particular the breakdown 
of kernel and user time.
2) Memory: Concentrate on Page Outs and Free Memory 
more than anything else. That will give you plenty of clues about memory 
starvation, and the relevence of your VM tuning.
3) I/O: User "sar -d". It's a bit annoying on a system 
with a lot of disks, because it returns a row for every device, even if no 
I/O occurred in the sample period. However, it makes it easier to parse. ;-) 
Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), 
and the queue depth. The utilisation is a function of these (queuing 
theory), but you can store that too as a shortcut. You can give sar any 
sample period, so your 5 minute averages are no 
  problem.
  How can I get the current I/O load on the system? I don't know 
  exactly what metric I am looking for.
  But I want to establish some baseline metric for each machine 
  and then hunt for spikes from the
  gathered data. The metric can be "I/O load on system bus in 
  Mb/sec" (like the netstat info packets
  input and output). I don't want individual disk statistics. I 
  just want a overall number, which I
  can snapshot. 
   
  I know what you're after, but it's just not going to work that way! A 
  network adapter is a single serial resource with a finite limit. An I/O 
  subsystem is an arbitrarily complex *set* of resources with a 
  finite capacity on each! For example, 
  if you were to just measure the aggregate I/O rate across your SAN (or 
  whatever), that may well return a good number. However, one disk in there 
  could be assuming 50% or more of the load due to hotspots. This disk would 
  probably be providing multi-SECOND response time, and because it's the hot 
  disk, will be slowing nearly everything down. Your aggregate stats would not 
  show this. You need per-disk, per-controller, and if you've got a very busy 
  system you might want to start worrying about backplane capacity. There's no 
  easy way to measure that one, 
however.
  
4) Network: "netstat 5" will report a row for every 5 
seconds (for example), showing how many packets went in and out of each 
interface. Your question below is easily answered - you have two columns in 
your output; the first is for the named interface (hme0), the 100baseT 
network card. The second is a total of all cards - looks like you only have 
one. This total can also include the loopback interface (lo0), so look out 
for that.
  
  If I have only one card then why the 
  total and hme0 data are different (by about 10%)? 
   
  I suspect it is reporting the lo0 interface in the total, but not showing it individually. Check 
  out the options for netstat (I don't have Slowlaris in front of me right 
  now).
  
Good luck, you're doing the right thing. I've been 
working on some software to do just this for a couple of years. I'd love to 
hear how it goes!
  +Rahul
  
Regards
 
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
of "Scaling Oracle8i - Building Highly Scalable OLTP System 
Architectures" 

  
  -Original Message-From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul 
  DandekarSent: 19 February 2002 12:59To: Multiple 
  recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance 
  Issues]
  James,
   
  Interleaved, please find my 
  reply
   
  +Rahul
  
- Original Message - 
From: 
James Morle 
    To: Multiple recipients of list 
    ORACLE-L 
Sent: Tuesday, February 19, 2002 
6:03 AM
Subject: RE: [Fwd: UNIX Performance 
Issues]

Rahul,
 
Did you get a response on this? I'm not sure 

Re: [Fwd: UNIX Performance Issues]

2002-02-19 Thread Rahul Dandekar
Title: Message



James,
 
Getting interesting, isn't it? I have added my 
response...
 
- Original Message - 

  From: 
  James Morle 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, February 19, 2002 8:58 
  AM
  Subject: RE: [Fwd: UNIX Performance 
  Issues]
  
  Rahul,
   
  Here's what I would do. 
  1) I would use "mpstat" for the processor statistics. 
  This breaks the usage up by processor in SMP configurations. This can be 
  useful to see the relative loading of each CPU, in particular the breakdown of 
  kernel and user time.
  2) Memory: Concentrate on Page Outs and Free Memory more 
  than anything else. That will give you plenty of clues about memory 
  starvation, and the relevence of your VM tuning.
  3) I/O: User "sar -d". It's a bit annoying on a system 
  with a lot of disks, because it returns a row for every device, even if no I/O 
  occurred in the sample period. However, it makes it easier to parse. ;-) 
  Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and 
  the queue depth. The utilisation is a function of these (queuing theory), but 
  you can store that too as a shortcut. You can give sar any sample period, so 
  your 5 minute averages are no problem.
How can I get the current I/O load on the system? I don't know 
exactly what metric I am looking for.
But I want to establish some baseline metric for each machine and 
then hunt for spikes from the
gathered data. The metric can be "I/O load on system bus in 
Mb/sec" (like the netstat info packets
input and output). I don't want individual disk statistics. I just 
want a overall number, which I
can snapshot.

  4) Network: "netstat 5" will report a row for every 5 
  seconds (for example), showing how many packets went in and out of each 
  interface. Your question below is easily answered - you have two columns in 
  your output; the first is for the named interface (hme0), the 100baseT network 
  card. The second is a total of all cards - looks like you only have one. This 
  total can also include the loopback interface (lo0), so look out for 
  that.

If I have only one card then why the total and hme0 data are 
different (by about 10%)?

  Good luck, you're doing the right thing. I've been 
  working on some software to do just this for a couple of years. I'd love to 
  hear how it goes!
+Rahul

  Regards
   
  James
  --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
  of "Scaling Oracle8i - Building Highly Scalable OLTP System 
  Architectures" 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul 
DandekarSent: 19 February 2002 12:59To: Multiple 
recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance 
Issues]
James,
 
Interleaved, please find my 
reply
 
+Rahul

  - Original Message - 
  From: 
  James Morle 
  To: Multiple recipients of list 
      ORACLE-L 
  Sent: Tuesday, February 19, 2002 6:03 
  AM
  Subject: RE: [Fwd: UNIX Performance 
  Issues]
  
  Rahul,
   
  Did you get a response on this? I'm not sure I fully 
  understand the actual question - are you looking for specific commands you 
  need to run to get the information, 
[Rahul] Yes. I would like to know which flags of the 
commonly used commands give good information.
For general System stats, I use "sar -u" (same as 
default), for Memory / Virtual Memory I use "vmstat"
and look for "r   b   w   
swap   free   pi   po   us  
 sy   id" columns.
I am looking for general monitoring. And once we have 
this general information giving a overall picture,
we could know if there is a problem and we could 
investigate further.
I am specifically looking for IO and Network 
statistics.
Is there any command which would give me approx IO of 
the system, say in last 5 minutes or
current?
How to get network statistics? I was littlebit confused 
with netstat. There are two main categories
in my output : hme0 and Total. What does that 
mean?
    input   
hme0  
output   
input  (Total)    outputpackets errs  packets 
errs  colls  packets errs  packets errs  
colls5757291 0 2447690 0 
0  6071152 0 2761551 
0 045  
0 1   
0 0  
45  0 
1   0 
024  0 
2   0 
0  24  
0 2   
0 0
 
What I plan to do is to take snapshot of all these statistics 
at a certain frequency and put it
in database. Later on I could generate reports based on 
this.
Currently, I have a lot of "Camera"s like this taking 
snapshots of my system.
Oth

RE: [Fwd: UNIX Performance Issues]

2002-02-19 Thread James McCann
Title: Message



Hi,
 I was at the Sun benchmarking labs in Paris before Christmas, and 
they had a tool which someone on there was working on.
It had 
a web based interface, and showed everything OS performance related that you 
could think of. It was also very configurable, and had lots of graphs, charts 
etc.
 
One of 
the best thing about it was that it could record the past statistics, for trend 
analysis. And had good report generation tools. The problem is I didn't catch 
it's name, and don't know if it's released yet. Sorry.
 
 
Also, 
take a look at "High performance oracle tuning with statspack". It has lots of 
scripts etc. doing the type of thing you want. 
 
Jim
 
 
 
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of James MorleSent: 19 
  February 2002 13:58To: Multiple recipients of list 
  ORACLE-LSubject: RE: [Fwd: UNIX Performance 
  Issues]
  Rahul,
   
  Here's what I would do. 
  1) I would use "mpstat" for the processor statistics. 
  This breaks the usage up by processor in SMP configurations. This can be 
  useful to see the relative loading of each CPU, in particular the breakdown of 
  kernel and user time.
  2) Memory: Concentrate on Page Outs and Free Memory more 
  than anything else. That will give you plenty of clues about memory 
  starvation, and the relevence of your VM tuning.
  3) I/O: User "sar -d". It's a bit annoying on a system 
  with a lot of disks, because it returns a row for every device, even if no I/O 
  occurred in the sample period. However, it makes it easier to parse. ;-) 
  Notably, keep an eye on the Service Times (avserv?), Wait times (avwait), and 
  the queue depth. The utilisation is a function of these (queuing theory), but 
  you can store that too as a shortcut. You can give sar any sample period, so 
  your 5 minute averages are no problem.
  4) Network: "netstat 5" will report a row for every 5 
  seconds (for example), showing how many packets went in and out of each 
  interface. Your question below is easily answered - you have two columns in 
  your output; the first is for the named interface (hme0), the 100baseT network 
  card. The second is a total of all cards - looks like you only have one. This 
  total can also include the loopback interface (lo0), so look out for 
  that.
   
  Good luck, you're doing the right thing. I've been 
  working on some software to do just this for a couple of years. I'd love to 
  hear how it goes!
  Regards
   
  James
  --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
  of "Scaling Oracle8i - Building Highly Scalable OLTP System 
  Architectures" 
  

-Original Message-From: 
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul 
    DandekarSent: 19 February 2002 12:59To: Multiple 
recipients of list ORACLE-LSubject: Re: [Fwd: UNIX Performance 
Issues]
James,
 
Interleaved, please find my 
reply
 
+Rahul

  - Original Message - 
  From: 
  James Morle 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Tuesday, February 19, 2002 6:03 
  AM
  Subject: RE: [Fwd: UNIX Performance 
  Issues]
  
  Rahul,
   
  Did you get a response on this? I'm not sure I fully 
  understand the actual question - are you looking for specific commands you 
  need to run to get the information, 
[Rahul] Yes. I would like to know which flags of the 
commonly used commands give good information.
For general System stats, I use "sar -u" (same as 
default), for Memory / Virtual Memory I use "vmstat"
and look for "r   b   w   
swap   free   pi   po   us  
 sy   id" columns.
I am looking for general monitoring. And once we have 
this general information giving a overall picture,
we could know if there is a problem and we could 
investigate further.
I am specifically looking for IO and Network 
statistics.
Is there any command which would give me approx IO of 
the system, say in last 5 minutes or
current?
How to get network statistics? I was littlebit confused 
with netstat. There are two main categories
in my output : hme0 and Total. What does that 
mean?
    input   
hme0  
output   
input  (Total)    outputpackets errs  packets 
errs  colls  packets errs  packets errs  
colls5757291 0 2447690 0 
0  6071152 0 2761551 
0 045  
0 1   
0 0  
45  0 
1   0 
024  0 
2   0 
0  24  
0 2   
0 0
 
What I plan to do is to take snapshot of all these statistics 
at a certain frequency and put it
in database. Later on I could generate rep

RE: [Fwd: UNIX Performance Issues]

2002-02-19 Thread James Morle
Title: Message



Rahul,
 
Here's what I would do. 
1) I would use "mpstat" for the processor statistics. This breaks the 
usage up by processor in SMP configurations. This can be useful to see the 
relative loading of each CPU, in particular the breakdown of kernel and user 
time.
2) Memory: Concentrate on Page Outs and Free Memory more than anything 
else. That will give you plenty of clues about memory starvation, and the 
relevence of your VM tuning.
3) I/O: User "sar -d". It's a bit annoying on a system with a lot of 
disks, because it returns a row for every device, even if no I/O occurred in the 
sample period. However, it makes it easier to parse. ;-) Notably, keep an eye on 
the Service Times (avserv?), Wait times (avwait), and the queue depth. The 
utilisation is a function of these (queuing theory), but you can store that too 
as a shortcut. You can give sar any sample period, so your 5 minute averages are 
no problem.
4) Network: "netstat 5" will report a row for every 5 seconds (for 
example), showing how many packets went in and out of each interface. Your 
question below is easily answered - you have two columns in your output; the 
first is for the named interface (hme0), the 100baseT network card. The second 
is a total of all cards - looks like you only have one. This total can also 
include the loopback interface (lo0), so look out for that.
 
Good luck, you're doing the right thing. I've been working on some 
software to do just this for a couple of years. I'd love to hear how it 
goes!
Regards
 
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
of "Scaling Oracle8i - Building Highly Scalable OLTP System 
Architectures" 

  
  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]] On Behalf Of Rahul DandekarSent: 
  19 February 2002 12:59To: Multiple recipients of list 
  ORACLE-LSubject: Re: [Fwd: UNIX Performance 
  Issues]
  James,
   
  Interleaved, please find my 
reply
   
  +Rahul
  
- Original Message - 
From: 
James Morle 
To: Multiple recipients of list ORACLE-L 
    
    Sent: Tuesday, February 19, 2002 6:03 
AM
Subject: RE: [Fwd: UNIX Performance 
Issues]

Rahul,
 
Did you get a response on this? I'm not sure I fully 
understand the actual question - are you looking for specific commands you 
need to run to get the information, 
  [Rahul] Yes. I would like to know which flags of the 
  commonly used commands give good information.
  For general System stats, I use "sar -u" (same as 
  default), for Memory / Virtual Memory I use "vmstat"
  and look for "r   b   w   
  swap   free   pi   po   us  
   sy   id" columns.
  I am looking for general monitoring. And once we have 
  this general information giving a overall picture,
  we could know if there is a problem and we could 
  investigate further.
  I am specifically looking for IO and Network 
  statistics.
  Is there any command which would give me approx IO of the 
  system, say in last 5 minutes or
  current?
  How to get network statistics? I was littlebit confused 
  with netstat. There are two main categories
  in my output : hme0 and Total. What does that 
  mean?
      input   hme0  
  output   input  
  (Total)    outputpackets errs  packets errs  
  colls  packets errs  packets errs  colls5757291 
  0 2447690 0 
  0  6071152 0 2761551 
  0 045  
  0 1   
  0 0  
  45  0 
  1   0 
  024  0 
  2   0 
  0  24  
  0 2   
  0 0
   
  What I plan to do is to take snapshot of all these statistics at 
  a certain frequency and put it
  in database. Later on I could generate reports based on 
  this.
  Currently, I have a lot of "Camera"s like this taking 
  snapshots of my system.
  Others involve Oracle stuff like DB Size Growth, 
  Performance Ratios, UNIX File System
  usage, Replication Statistics, Growth of DB objects, a lot of monitors 
  for application
  info (e.g. total # of clients, # of invoices generated per 
  day).
  I generate trends based on this archival data for capacity planning and 
  proactively
  anticipating chronic problems.
  
or advice on how to interpret it? Don't forget that you 
will really need to correlate many of these 
statistics to the Oracle pathology at the same time. 

  You said it! I want co-relation of Application Load, 
  UNIX System Load and Database 
  Statistics.
  And not just when the problem arises. 
  So, that's what I am trying to develop.
   
  
This then causes a problem because your sample points 
will at the very least experience clock drift and become harder to compare 
over time. There are ways to solve it, though. 
Anyway, if you could elaborate a little, I can try to 
assist!
Regards
 
 

Re: [Fwd: UNIX Performance Issues]

2002-02-19 Thread Rahul Dandekar
Title: Message



James,
 
Interleaved, please find my reply
 
+Rahul

  - Original Message - 
  From: 
  James Morle 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, February 19, 2002 6:03 
  AM
  Subject: RE: [Fwd: UNIX Performance 
  Issues]
  
  Rahul,
   
  Did you get a response on this? I'm not sure I fully 
  understand the actual question - are you looking for specific commands you 
  need to run to get the information, 
[Rahul] Yes. I would like to know which flags of the 
commonly used commands give good information.
For general System stats, I use "sar -u" (same as default), 
for Memory / Virtual Memory I use "vmstat"
and look for "r   b   w   
swap   free   pi   po   us  
 sy   id" columns.
I am looking for general monitoring. And once we have this 
general information giving a overall picture,
we could know if there is a problem and we could 
investigate further.
I am specifically looking for IO and Network 
statistics.
Is there any command which would give me approx IO of the 
system, say in last 5 minutes or
current?
How to get network statistics? I was littlebit confused 
with netstat. There are two main categories
in my output : hme0 and Total. What does that 
mean?
    input   hme0  
output   input  
(Total)    outputpackets errs  packets errs  
colls  packets errs  packets errs  colls5757291 
0 2447690 0 
0  6071152 0 2761551 
0 045  
0 1   
0 0  
45  0 
1   0 
024  0 
2   0 
0  24  
0 2   
0 0
 
What I plan to do is to take snapshot of all these statistics at 
a certain frequency and put it
in database. Later on I could generate reports based on 
this.
Currently, I have a lot of "Camera"s like this taking 
snapshots of my system.
Others involve Oracle stuff like DB Size Growth, Performance 
Ratios, UNIX File System
usage, Replication Statistics, Growth of DB objects, a lot of monitors 
for application
info (e.g. total # of clients, # of invoices generated per 
day).
I generate trends based on this archival data for capacity planning and 
proactively
anticipating chronic problems.

  or advice on how to interpret it? Don't forget that you 
  will really need to correlate many of these 
  statistics to the Oracle pathology at the same time. 
  
You said it! I want co-relation of Application Load, 
UNIX System Load and Database 
Statistics.
And not just when the problem arises. So, 
that's what I am trying to develop.
 

  This then causes a problem because your sample points 
  will at the very least experience clock drift and become harder to compare 
  over time. There are ways to solve it, though. 
  Anyway, if you could elaborate a little, I can try to 
  assist!
  Regards
   
  James
  --James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
  of "Scaling Oracle8i - Building Highly Scalable OLTP System 
  Architectures" 
  

-Original Message-From: Mogens 
Nørgaard [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 
22:11To: James MorleSubject: [Fwd: UNIX Performance 
Issues]Hi James,I've got no idea whether this 
is of interest or not to you, but you probably know a bit about this 
topic.Mogens Original Message  

  
  
Subject: 
UNIX Performance Issues
  
Date: 
Thu, 14 Feb 2002 07:43:26 -0800
  
From: 
"Rahul Dandekar" <[EMAIL PROTECTED]>
  
Reply-To: 
[EMAIL PROTECTED]
  
Organization: 
Fat City Network Services, San Diego, California
  
To: 
Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>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

RE: [Fwd: UNIX Performance Issues]

2002-02-19 Thread James Morle
Title: Message



Rahul,
 
Did you get a response on this? I'm not sure I fully understand the 
actual question - are you looking for specific commands you need to run to get 
the information, or advice on how to interpret it? Don't forget that you will 
really need to correlate many of these statistics to the Oracle pathology at the 
same time. This then causes a problem because your sample points will at the 
very least experience clock drift and become harder to compare over time. There 
are ways to solve it, though. 
Anyway, if you could elaborate a little, I can try to 
assist!
Regards
 
James
--James MorleScale Abilities, Ltdhttp://www.scaleabilities.co.ukAuthor 
of "Scaling Oracle8i - Building Highly Scalable OLTP System 
Architectures" 

  
  -Original Message-From: Mogens Nørgaard 
  [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 
  22:11To: James MorleSubject: [Fwd: UNIX Performance 
  Issues]Hi James,I've got no idea whether this is 
  of interest or not to you, but you probably know a bit about this 
  topic.Mogens Original Message  
  


  Subject: 
  UNIX Performance Issues

  Date: 
  Thu, 14 Feb 2002 07:43:26 -0800

  From: 
  "Rahul Dandekar" <[EMAIL PROTECTED]>

  Reply-To: 
  [EMAIL PROTECTED]

  Organization: 
  Fat City Network Services, San Diego, California

  To: 
  Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>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).