V$system_event

From: Shrake, Jolene <JEShrake_at_Pella.com>
Date: Wed, 21 Jan 2004 08:44:25 -0800
Message-ID: <F001.005DDC51.20040121084425@fatcity.com>

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