 |
|
ss
Oracle Tips by Burleson |
Sample v$waitclassmetric
data
The DBA might be interested in seeing what
wait classes 6, 7 and 9 represent. Querying the v$system_wait_class
view is one way to identify what the wait classes represent. This
view has a historical rollup for the entire time the instance has
been up, but it also provides a way to change wait_class# into the
name of that class. wait_class_info.sql is a simple query that
could easily be plugged into waitclassmetric.sql to include the name
of the wait class in addition to the number. Sample output of this
script is shown in Figure 8.13.
* wait_class_info.sql
--
*************************************************
-- Copyright © 2003 by Rampant TechPress
-- This script is free for non-commercial
purposes
-- with no warranties. Use at your own
risk.
--
-- To license this script for a commercial
purpose,
-- contact rtp AT rampant.cc
--
*************************************************
select
wait_class# ,
wait_class
from
v$system_wait_class
where:
See Code Depot
The above book excerpt is from:
Oracle Wait Event Tuning
High Performance with Wait
Event Iinterface Analysis
ISBN 0-9745993-7-9
Stephen Andert
http://www.rampant-books.com/book_2004_2_wait_tuning.htm |
