Re: SGA Fragmentation - How to Monitor

x$ksmsp
* and *x$ksmlru* comes to my mind.
But beware of shared pool latches.

have you checked Note
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=146599.1 or others?

regards,
 Martin

On Wed, Mar 10, 2010 at 11:03, Mudhalvan Moovarkku < moovarkku.mudhalvan_at_axa-direct.co.jp> wrote:

> Dear DBA
>
> Our Environment had an incident and got an error message ORA-04031:
> unable to allocate 1048 bytes of shared memory
>
> We understand that it is because of SGA Fragmentation.
>
> How to Monitor the SGA fragmentation and avoid it?.
>
> Thank you.
> Best Regards,
> M.Moovarkku Mudhalvan
>
> -----------------------------------------------------------------------
> ----------------------------------------
> Service Delivery Dept. IT & Logistics Div
>
> AXA NON-LIFE INSURANCE CO. Ltd.
>
> ***moovarkku.mudhalvan_at_axa-direct.co.jp*<moovarkku.moovarkku.mudhalvan_at_axa-direct.co.jp>
>
> Phone: +81-3-6688-8879 Fax: +81-3-3528-1164
> E-mail disclaimer:
> This message is confidential; its contents do not constitute a commitment
> by AXA NON-LIFE INSURANCE CO LTD except where provided for in a written
> agreement between you and the Company. Any unauthorized disclosure, use or
> dissemination, either whole or partial, is prohibited. If you are not the
> intended recipient of this message, please notify the sender immediately.
>
> ---------------------------------------------------------------------------------------------------------------
>
>

-- 
Martin Berger           martin.a.berger_at_gmail.com
Lederergasse 27/2/14           +43 660 660 83306
1080 Wien                                       http://berx.at/

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