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.
-------------------------------
ASH is based on a sampling methodology, whereas both Oracle's wait interface and instance statistic views (e.g., v$sysstat) gather their data based on instrumentation. Sampling is not an unusual way to gather information. It is used in many disciplines. Nearly all Oracle third-party performance products gather their performance data by polling, which is sampling. Sampling is used outside the Oracle community also; for example, with statistics, signal processing, music, compression, financial auditing, and quality control.
Sampling simply takes a look at what is currently occurring and makes note of it. With enough samples, we'll get a good idea of what has happened in the past. While sampling does not provide perfect information, with enough samples, statistically the data is just as good as instrumentation and possibly at a much lower overhead.
For example, suppose ten samples were taken over a 10-second period. During two of the samples, an Oracle process was consuming CPU and the other eight were waiting for IO. Based solely on these samples, we can infer 20% of the time the process is consuming CPU, while 80% of the time it is waiting for IO. Since we know the duration is ten seconds, we can also infer the process was consuming CPU for about 2 seconds and waiting for IO about 8 seconds. While we do not know the exact figures and we could increase the accuracy by increasing the sample rate, we know enough to understand the situation, resulting in a stellar diagnosis.
©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.
|