 |
|
ss
Oracle Tips by Burleson |
Describe v$eventmetric
This is a short-term view and only stores
information for about the past minute. The exact duration of the
data is shown in the INTSIZE_CSEC field, which represents the number
of centiseconds in this interval. In the example shown in Figure
8.10, on the interval on the Linux test system is 6018 cs, which
when rounded to the nearest second equates to one minute and two
seconds. This data can be obtained by running eventmetric.sql
available in the code depot.
* eventmetric.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
--
*************************************************
/* eventmetric.sql */
column INTSIZE_CSEC format 99999 heading
INTERVAL|SIZE
column EVENT# format 9999
column NUM_SESS_WAITING format 9999 heading
NUMBER|SESSIONS|WAITING
column TIME_WAITED format 999999 heading
TIME|WAITED
column WAIT_COUNT format 9999 heading
WAIT|COUNT
select
to_char(begin_time, 'DD/MON/YYYY
HH24:MI:SS') "BEGIN",
to_char(end_time, 'DD/MON/YYYY
HH24:MI:SS') "END",
intsize_csec,
event#,
event_id,
num_sess_waiting,
time_waited,
wait_count
from
v$eventmetric
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 |