Re: SGA Fragmentation - How to Monitor

  • From: Surachart Opun <surachart@xxxxxxxxx>
  • To: moovarkku.mudhalvan@xxxxxxxxxxxxxxxx
  • Date: Wed, 10 Mar 2010 17:28:23 +0700

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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx*<moovarkku.moovarkku.mudhalvan@xxxxxxxxxxxxxxxx>
>
> 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.
>
> ---------------------------------------------------------------------------------------------------------------
>
>

Other related posts: