Home » RDBMS Server » Performance Tuning » SGA shared pool
SGA shared pool [message #65373] Fri, 27 August 2004 10:21
jph2658
Messages: 1
Registered: August 2004
Junior Member
Forgive me if this questions is simple or doesn't make any sense :P. I'm new to oracle and still trying to find my way around.
I'm looking for the specifics of the least recently used algorithm for the shared pool in the sga. Oracle seems to continuously allocate memory in the library cache, and sql area, which never gets fread. Eventually the application dies because there isn't enough memory.

ORA-04031: unable to allocate nnn bytes of shared memory

My shared pool size is 94271840 (94Mb), which I think is large enough. Increasing the size doesn't do anything, because memory is sucked dry no matter what the size.
In my application the queries differ slightly from user to user, and each time the user logs in they differ slightly. I'm assuming Oracle is trying to save them all, which I don't really want it to do. Even so, shouldn't some of the saved queries be removed when it reaches a point when it can't allocate enough memory to store another?
How long does it take before a query stored in the library cache is removed?
Previous Topic: Help me( tuning PL/SQL)
Next Topic: Rule for bitmap indexes
Goto Forum:
  


Current Time: Thu Mar 28 07:18:21 CDT 2024