RE: Measuring shared pool fragmentation

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, September 22, 2004 3:56 PM To: peter.schauss_at_ngc.com; 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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
--

http://www.freelists.org/webpage/oracle-l
--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 23 2004 - 07:36:44 CDT