Top Shared Pool Consumers 2006-01-18 - By Anand Rao
Hi,
Check these Note on Metalink.
- Oracle Note: 61623.1: Resolving shared pool fragmentation.
- Oracle Note: 146599.1: Diagnosing and Resolving Error ORA-04031 (See ORA-04031.ora-code.com).
there are way too many things to list and discuss about ORA-4031 (See ORA-4031.ora-code.com) 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@(protected)> wrote:
>
> We are frequently getting ORA-4031 (See ORA-4031.ora-code.com) 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
>
>
>
Hi,<br><br>Check these Note on Metalink.<br><br><ul><li> Oracle Note: 61623.1:
Resolving shared pool fragmentation.
</li><li> Oracle Note: 146599.1: Diagnosing and Resolving Error ORA-04031 (See ORA-04031.ora-code.com).
</li></ul>there are way too many things to list and discuss about
ORA-4031 (See ORA-4031.ora-code.com) in a forum like this....and the best thing for you is to check
those notes.<br><br>regards<br><span class="sg">anand</span><br><br><div><span
class="gmail_quote">On 18/01/06, <b class="gmail_sendername">Deepak Sharma</b>
<<a href="mailto:sharmakdeep_oracle@(protected)">sharmakdeep_oracle@(protected)
</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">We are
frequently getting ORA-4031 (See ORA-4031.ora-code.com) event though we<br>have a very large shared pool
(currently
4.2G). The<br>free memory as being shown in v$sgastat constantly<br
>show ~300M free. We have a script that runs every hour<br>to show the free
memory. At some point, the free<br>memory suddenly goes to like 1.5 - 2 G free.
So, I
<br>need to know of a way, if possible, to find out which<br>sessions are
consuming a lot of shared pool. Any<br>ideas?<br><br>Thanks,<br
>Deepak<br><br>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<br>Do You
Yahoo!?
<br>Tired of spam? Yahoo! Mail has the best spam protection around
<br><a href="http://mail.yahoo.com">http://mail.yahoo.com</a><br>--<br><a href=
"http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage
/oracle-l
</a><br><br><br></blockquote></div><br>
|
|
