What's with all this performance stuff? This is a matter of principle. The
man paid for 8 Gig of memory, and BY GOD, the man ought to be about to use
his 8 Gig of memory!
-----Original Message-----
col event format a35 head 'EVENT NAME'
col total_waits format 999,999,999 head "TOTAL|WAITS"
col total_timeouts format 999,999,999 head "TOTAL|TIMEOUTS"
col time_waited format 999,999,999 head "TIME|WAITED|SECONDS"
col average_wait format 99999 head "AVG|WAIT|100ths"
set line 150
set trimspool on
select
event,
total_waits,
total_timeouts,
time_waited/100 time_waited,
average_wait
from v$system_event
order by time_waited
/
ttitle off
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
