Re: Top Shared Pool Consumers

Hi,

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 those notes.

regards
anand

On 18/01/06, Deepak Sharma <sharmakdeep_oracle_at_yahoo.com> wrote:
>
> We are frequently getting ORA-4031 event though we
> have a very large shared pool (currently 4.2G). The
> 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
> ideas?
>
> Thanks,
> Deepak
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l