You were brought to this page based on an internet search
and as a free service to Oracle DBAs.
The text below is an except from the book,
Oracle Performance Firefighting, written by
Craig Shallahamer of
OraPub, Inc.
Figures and tables are not included on this page, only their reference.
To order the book in either print or PDF form, click
here.
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
-------------------------------
Figure 4-7 shows a typical vmstat command sampling every 30 seconds from an active and very stable system. The first vmstat line returned is supposed to be the average since the system was rebooted. This is why the first line commonly looks very different from the rest of the lines, and why we usually do not include the first line in our analysis.
Figure 4-7. Sample vmstat output sampling every 30 seconds. The CPU system is active, but not too active, with plenty of excess capacity.
While vmstat can be used to monitor many system aspects, our current focus is the CPU subsystem. The utilization-related columns are at the far right of the report (Figure 4-7):
©2009, 2010 by Craig Shallahamer. This is copyrighted material.
PleaseOut of respect for those involved in the creation of the book and also for
their familes, we ask you to respect the copyright both in intent and deed. Thank you.
|