RE: V$system_event

Jolene,

Mladen's answer is a good one. There is also an in-depth discussion on this subject on pp210-217 of the book "Optimizing Oracle Performance."

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 1/27 Atlanta

• SQL Optimization 101: 2/16 Dallas
• Hotsos Symposium 2004: March 7-10 Dallas
• Visit www.hotsos.com for schedule details...

-----Original Message-----
Shrake, Jolene
Sent: Wednesday, January 21, 2004 10:44 AM To: Multiple recipients of list ORACLE-L

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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cary Millsap
  INET: cary.millsap_at_hotsos.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).