RE: ora-4031 & large_pool

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 20 May 2004 15:01:19 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNEEHNCDAA.lex.de.haan@naturaljoin.nl>

... and while we are on this subject anyway: Oracle 10g is pre-configured for MTS by default. there is one TCP protocol dispatcher on startup, so you can dynamically configure the SHARED_SERVERS parameter without the need to bounce your instance...

Cheers,
Lex.

---

visit my website at http://www.naturaljoin.nl

---

-----Original Message-----

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.

Default values can well give you MTS. Default value for dispatchers is to start a disparcher for IPC and another one on localhost, port 1521.

The best thing is to check V$SESSION and statspack.
--

Mladen Gogala
Oracle DBA

• Binary/unsupported file stripped by Ecartis --
• Type: text/x-vcard
• File: Lex de Haan.vcf

  ---

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 - 07:58:33 CDT