Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: [Fwd: UNIX Performance Issues]
MessageJames,
Getting interesting, isn't it? I have added my response...
Rahul,
Here's what I would do.
James
--
James Morle
Scale Abilities, Ltd
http://www.scaleabilities.co.uk
Author of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures"
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf Of Rahul Dandekar
Sent: 19 February 2002 12:59
To: Multiple recipients of list ORACLE-L
Subject: Re: [Fwd: UNIX Performance Issues]
James,
Interleaved, please find my reply....
+Rahul
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" -----Original Message----- From: Mogens Nørgaard [mailto:mln_at_miracleas.dk] Sent: 18 February 2002 22:11 To: James Morle Subject: [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" <rvd_oracle_at_hotmail.com> Reply-To: ORACLE-L_at_fatcity.com Organization: Fat City Network Services, San Diego, California To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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...
Thanks,
___ ___ ___ ___ ___ / /\ / /\ / /\ / /\ / /\ / /::\ / /::\ / /:/ / /:/ / /:/ / /:/\:\ / /:/:| / /:/ / /:/ / /:/ / /::\ \:\ / /:/|:| / /::\ __ / /:/ ___ / /:/ /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/ / /\ /__/:/ \__\/~|::\/:/ \__\/\:\:| \__\/ \:\/:/ \ \:\ / /:/ \ \:\ | |:|::/ \__\::| \__\::/ \ \:\ /:/ \ \:\ | |:|\/ | |:| / /:/ \ \:\/:/ \ \:\ |__|:| |__|:| /__/:/ \ \::/ \ \:\ \__\| \__\| \__\/ \__\/ \__\/
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: 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 (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: Rahul Dandekar INET: 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 (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).Received on Tue Feb 19 2002 - 09:48:33 CST
![]() |
![]() |