RE: RE: SGA Fragmentation - How to Monitor
- From: "Mudhalvan Moovarkku" <moovarkku.mudhalvan@xxxxxxxxxxxxxxxx>
- To: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>, <Joel.Patterson@xxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2010 10:31:01 +0900
Dear All,
Thanks for everyone reply. I have checked the meta link
document and feel I can do some scripting which will help me to find out
the error before it come.
By the way when I do analysis just few seconds before this
error ORA-04031 happened one trace file was created at udump folder
which has the following message and found the chunk is suddenly down
from 6000 to 15.
---- Snip Start - udump trace file
FREELIST CHUNK COUNT:6328 OBJECT SIZE:184
LATCH:10 TOTAL SPACE: 15447168
FREELIST CHUNK COUNT:5072 OBJECT SIZE:184
Permanent space allocated for KGL S handles
LATCH:0 TOTAL SPACE: 348480
FREELIST CHUNK COUNT:14 OBJECT SIZE:480
LATCH:1 TOTAL SPACE: 341760
FREELIST CHUNK COUNT:5 OBJECT SIZE:480
LATCH:2 TOTAL SPACE: 345600
---- Snip End - udump trace file
Do you have any clue how to find why it is happened?
Regards
Mudhalvan M.M
________________________________
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Thursday, March 11, 2010 3:56 AM
To: Joel.Patterson@xxxxxxxxxxx
Cc: Jon.Crisler@xxxxxxx; karlarao@xxxxxxxxx; Mudhalvan Moovarkku;
Oracle-L@xxxxxxxxxxxxx
Subject: Re: RE: SGA Fragmentation - How to Monitor
Joel, this is about shared pool fragmentation not keeping blocks in the
SGA. Any PL/SQL intensive app is likely to benefit from this, assuming
they've packaged routines appropriately
On Mar 10, 2010 6:47 PM, <Joel.Patterson@xxxxxxxxxxx> wrote:
I really can't answer definitively one way or another. If it
was good
for you under 8 and 9, then of course you know for versions 8
and 9.
The thinking has always been in the past (oracle 8 and 9), when
the
subject came up, especially with tables, that the least recently
used
algorithm employed by oracle would purge essentially keep the
hot tables
anyway and so there wasn't any point in pinning them.
Now I'm sure you have more detail than that, but thought I'd put
that
out there for consideration for whatever it might be worth.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Crisler, Jon
Sent: Wednesday, March 10, 2010 11:...
Subject: RE: SGA Fragmentation - How to Monitor If this is an
Oracle Applications / Ebiz / ERP syst...
Other related posts:
