Re: Top Shared Pool Consumers
Check these Note on Metalink.
- Oracle Note: 61623.1: Resolving shared pool fragmentation.
- Oracle Note: 146599.1: Diagnosing and Resolving Error ORA-04031.
there are way too many things to list and discuss about
ORA-4031 in a forum like this....and the best thing for you is to check
On 18/01/06, Deepak Sharma <email@example.com
We are frequently getting ORA-4031 event though we
have a very large shared pool (currently
free memory as being shown in v$sgastat constantly
show ~300M free. We have a script that runs every hour
to show the free memory. At some point, the free
memory suddenly goes to like 1.5 - 2 G free. So, I
need to know of a way, if possible, to find out which
sessions are consuming a lot of shared pool. Any
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around