RE: Measuring shared pool fragmentation

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 22 Sep 2004 16:56:24 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF09660EAD@bosmail00.bos.il.pqe>

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 Received on Wed Sep 22 2004 - 15:51:56 CDT