Re: Script for identifying objects having freelists contention

[Bunyamin K. Karadeniz]

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:[EMAIL PROTECTED]] 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