To see how many dispatchers/shared servers are started up with the RDBMS, check the
value of 'mts_dispatchers' and 'mts_servers' in the init.ora.
You can also tell by looking in the alert.log(default location is
$ORACLE_HOME/rdbms/log).
Sample:
PMON started
DBWR started
LGWR started
RECO
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
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