Re: Script for identifying objects having freelists contention

[Anjo Kolk]

That won't do it ........ Anjo. "Bunyamin K. Karadeniz" wrote:   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