Dave,
I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.
Here's my configuration:
mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78) (PORT=1521))
mts_service = PRUE1
mts_dispatchers = tcp,2
What does your TNSNAMES.ORA file look like? If there is a line in there
'(server=dedicated)' you might as well turn MTS off.
Dick Goulet
Reply Separator
Author: =?iso-8859-1?q?Pablo=20Rodriguez?= [EMAIL PROTECTED]
Date: 11/6/2002 11:39 AM
Dave,
On Wed, Nov 06, 2002 at 11:39:06AM -0800, Pablo Rodriguez wrote:
Dave,
I've seen these processes (ora_S00... and
ora_d00..) but all connections are being made through
dedicated processes.
Here's my configuration:
mts_listener_address = (ADDRESS=(PROTOCOL=TCP)
(HOST=10.20.81.78)
Pablo,
init.ora -- Look at the dispatchers=... parameter (You can comment it
out if you don't want MTS)
listener.ora -- Look for (SERVER = DEDICATED) vs. (SERVER = SHARED)
In SQLPLUS -- SQL SELECT servers_started FROM v$mts;
-Scott Stefick
-Original Message-
Sent: Wednesday,
Another place to look is how connections are made to the database.
Do you know if the connections are bypassing the tnsnames.ora altogether and
using their own connect string wherein they could be specifying a dedicated
server?
First thing to determine is whether connections are in fact using