Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> V$system_event
These results don't seem possible.
I run the following query:
select ((vse.time_waited/100)/60) time_waited,
((vse.time_waited/vse1.total_time)*100) p_time_waited,
vse.event
from v$system_event vse, (select sum(time_waited) total_time from
v$system_event) vse1
where ((vse.time_waited/100)/60) >= .1
and vse.event not in ('SQL*Net message from client','rdbms ipc
message','pmon timer','smon timer')
order by 2 desc
/
The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX 11.11.
The database has been up since Sunday night after the cold backup.
These results seem too large. Any thoughts?
Time Waited % Time
(min) Waited Wait Event
------------ ------- ---------------------------- 50,771.54 2.30 db file sequential read 19,129.29 .86 db file scattered read 15,735.79 .71 latch free 15,321.68 .69 io done 15,248.34 .69 log file sync 14,866.87 .67 buffer busy waits 14,718.91 .67 log file parallel write
Thanks for your help,
Jolene
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Shrake, Jolene
INET: JEShrake_at_Pella.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 21 2004 - 10:44:25 CST
![]() |
![]() |