| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Off-Topic : Basic Critical O.S. Values that Trigger Problem Alert
Hi
Kevin wrote "Network (netstat): collisions < 10% of "packets transmitted" (0% in "switched" environment)"
Following is an Output on Solaris :-
netstat -i
Name Mtu Net/Dest Address Ipkts Ierrs Opkts Oerrs Collis Queue lo0 8232 loopback localhost 14055860 0 14055860 0 0 0 hme0 1500 sundb sundb 1169701421 7 940887777 0 0 0
Qs 1 Am i using the Correct netstat to Check Collisions ?
Qs 2 Is Collis Unit in % ?
Qs 3 Is "packets transmitted" = (Ipkts + Opkts) ?
Qs 4 How do i know what is my Environment i.e. "swiched" or not ?
Thanks
-----Original Message-----
Sent: Wednesday, July 31, 2002 12:10 AM
To: VIVEK_SHARMA
Greetings,
Here's some simple "rules of thumb" that may or may not be appropriate for every situation:
CPU utilization (sar -u or vmstat / mpstat): user <= 60%, sys <= 30%, wait
I/O = 0%, idle >= 10%
Memory (sar -g or vmstat): scan rate = 0 if running Solaris 8 or 9, scan
rate < 273 pages / second on Solaris 7 and earlier if priority paging is
not enabled (if priority paging is enabled, then scan rate can't be used to
determine if there's a memory bottleneck)
Disk (sar -d or iostat): average service time < 30 ms and busy < 25%
Network (netstat): collisions < 10% of packets transmitted (0% in switched
environment)
For more detailed information, I'd highly recommend picking up a copy of "System Performance Tuning" (2nd edition) by Gian-Paolo D. Musumeci and Mike Loukides. HTH...
Kevin Buterbaugh
LifeWay
"Anyone can build a fast CPU. The trick is to build a fast system." - Seymour Cray
Sent by: sunmanagers-admin_at_sunmanagers.org
To: <oracledba_at_lazydba.com>, <ORACLE-L_at_fatcity.com>,
<sunmanagers_at_sunmanagers.org>
cc:
Hi
We are Trying to make a General Document to be forwarded to Customers which should allow them to know when they are performing far below normal
At the Operating System Level we are trying to Identify Practical Critical Values which when below respective Threshold Limits which would give the alert about a potential problem .
We are Looking for these in Areas of :-
Would apreciate actual Commands used (preferably those Generic across different O.S.) & respective Critical Threshold Limit Values for the Above
EXAMPLE For Network thruput Between APPLICATION Server machine & Database
Server Machine
what , by experience , are the parameters & their respective Minimum
threshold Values which would let us know that there is a Severe problem
therein ?
NOTE - We have generally been measuring this by Manually ftping a Big
File , about 100MB , between APP & DB Server machines , noting the thruput
Displayed in (kbytes/s) on Completion & Converting this Value to Mega Bits
/
Second
(i.e. MBPS) . If this Value is Less than 40MBPS for a 100 MBPS Cable we
know there is a PRoblem with Network Bandwidth.
Miscellaneous - Some Threshold Limits known to us :-
Command - vmstat 5 3
Virtual Memory Statistics: (pagesize = 8192)
procs memory pages intrcpu
THANKS
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: VIVEK_SHARMA_at_infosys.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-LReceived on Thu Aug 01 2002 - 06:48:19 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |