| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: MTS versus dedicated for resolving a ORA-04031.
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_at_lmco.com 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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Mar 15 2004 - 20:45:40 CST
 |
 |