Can you post your whole v$sgastat ?
On 1/17/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
>
>
>
--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 17 2006 - 13:25:12 CST
