|
James,
Interleaved, please find my reply....
+Rahul
----- Original Message -----
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) output
packets errs packets errs
colls packets errs packets errs colls
5757291
0 2447690 0
0 6071152 0 2761551
0 0
45
0 1
0 0
45 0
1 0
0
24 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 Morle
Scale Abilities, Ltd
http://www.scaleabilities.co.uk
Author
of "Scaling Oracle8i - Building Highly Scalable OLTP System
Architectures"
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 --------
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).
| 