Re: MTS versus dedicated for resolving a ORA-04031.
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Mar 2004 19:49:22 -0700
Chris,
You're killing yourself by using MTS and not allocating Large Pool. The
Large Pool is designed to accommodate MTS; the Shared Pool is not. In
fact, depending on your reasons for using MTS, you could really be suffering
severe contention for Shared Pool latches by having MTS remain there.
Check V$SESSTAT for "uga" sizing information during peak periods, double or
triple what you see (depending on how confident you are about whether you
witnessed a true "peak" period), and then allocate that much to the Large
Pool. You'll see a world of difference when you get all those UGAs for MTS
shared sessions out of the Shared Pool.
Hope this helps...
-Tim
on 3/11/04 2:02 PM, Grabowy, Chris at chris.grabowy@xxxxxxxx wrote:
> We have upgraded our databases from 8174 to 9203.
>
> We have started encountering ORA-04031's on processes that are using MTS.
> Once we switch that process to use a dedicated connection then the problem
> goes away. This problem did not occur when we were using 8174.
>
> For 8174, the shared pool was 100M. Large pool = 0. reserved is 10%.
> For 9203, the shared pool was doubled to 200M. Large pool = 0. reserved is
> 10%.
>
> Any thoughts?? Are we killing ourselves by doubling the shared pool?? Does
> everyone else set their large pool to zero???
>
> TIA.
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
