Peter Are you specifically interested in finding shared pool freespace fragmentation ? Shared pool freespace is maintained in multiple freelists and this script by Steve Adams shows a good picture of shared pool freespace fragmentation. BTW, Does your database have shared pool latch contention ? http://www.ixora.com.au/scripts/sql/shared_pool_free_lists.sql Thanks Riyaj "Re-yas" Shamsudeen Certified Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark Sent: Wednesday, September 22, 2004 3:56 PM To: peter.schauss@xxxxxxx; Oracle-L (E-mail) Subject: RE: Measuring shared pool fragmentation Peter, Check Steve Adams' website, particuarly for scripts that=20 run agains X$KSMLRU and X$KGHLU. -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Schauss, Peter Sent: Wednesday, September 22, 2004 4:14 PM To: Oracle-L (E-mail) Subject: Measuring shared pool fragmentation Is there a way do measure the amount of shared pool fragmentation? I would be looking for metrics such as the largest available chunk of memory, number of fragments, average size of memory fragments ... thanks, Peter Schauss -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- Attached file included as plaintext by Ecartis -- -- Desc: Signature The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. -- //www.freelists.org/webpage/oracle-l