Re: SGA Fragmentation - How to Monitor
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: "moovarkku.mudhalvan" <moovarkku.mudhalvan@xxxxxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2010 11:21:33 +0100
Even I've never done it, *
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@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.
>
> ---------------------------------------------------------------------------------------------------------------
>
>
--
Martin Berger martin.a.berger@xxxxxxxxx
Lederergasse 27/2/14 +43 660 660 83306
1080 Wien http://berx.at/
Other related posts:
