RE: SGA

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Fri, 15 Aug 2003 10:19:23 -0800
Message-ID: <F001.005CAEF2.20030815101923@fatcity.com>

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: Stephen.Lee_at_DTAG.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 Fri Aug 15 2003 - 13:19:23 CDT