Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ora-4031 & large_pool

RE: ora-4031 & large_pool

From: Norris, Gregory T [ITS] <gregory.t.norris_at_mail.sprint.com>
Date: Thu, 20 May 2004 09:15:16 -0500
Message-ID: <D24DD765BFEDB145B346ACDA71E1658B057B88AC@PKDWB04C.ad.sprint.com>


> The only way to really tell whether
> you do or do not use MTS is from
> V$SESSION. If the SERVER column
> is "SHARED", then you are using MTS.

It can also contain NONE, which means that you have a MTS connection = which is not currently using a server process (i.e. an inactive = session).

--
My employers like me, but not enough to let me speak for them.

Greg Norris
Sprint LTD Database Administration
=20
----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Thu May 20 2004 - 09:12:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US