Oracle-L: Re: Script for identifying objects having freelists contention

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Wed, 17 Apr 2002 23:23:18 -0800
Message-ID: <F001.00447852.20020417232318@fatcity.com>

SELECT s.segment_name,s.segment_type,s.freelists,w.wait_time,w.seconds_in_wait,w.state

FROM dba_segments s , V$session_wait w WHERE s.header_file=w.p1 AND s.header_block=w.p2;

Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729

The degree of normality in a database
is inversely proportional to that of its DBA.

Original Message ----- From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, April 18, 2002 8:13 AM Subject: RE: Script for identifying objects having freelists contention

Steve Adams' site is a good start. http://www.ixora.com.au/

  Tony Aponte
    -----Original Message-----
    From: Anand Prakash [mailto:AnandPrakash_at_firsthealth.com]     Sent: Wednesday, April 17, 2002 5:29 PM     To: Multiple recipients of list ORACLE-L     Subject: Script for identifying objects having freelists contention

Does anyone have the scripts (or URL) for identifying objects having freelists contention?

Thanks.
Anand Prakash

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bunyamin K. Karadeniz
INET: bunyamink_at_havelsan.com.tr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Thu Apr 18 2002 - 02:23:18 CDT