Re: SGA Fragmentation - How to Monitor

From: Surachart Opun <surachart_at_gmail.com>
Date: Wed, 10 Mar 2010 17:28:23 +0700
Message-ID: <1dacf81e1003100228n431c5cfbwc04ac498d9be4394_at_mail.gmail.com>

if you can use metalink - *Troubleshooting and Diagnosing ORA-4031 Error [ID 396940.1]* and *Diagnosing and Resolving Error ORA-04031 [ID 146599.1]*

Surachart Opun
http://surachartopun.com
Oracle ACE, OCE, OCP

On Wed, Mar 10, 2010 at 5:03 PM, 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.
>
> ---------------------------------------------------------------------------------------------------------------
>
>

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

Received on Wed Mar 10 2010 - 04:28:23 CST