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@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
--
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

Other related posts: