| Pl Help : Shared Server configuration Prob: [message #64001] |
Fri, 03 December 2004 20:15 |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
Dear frends,
I have following parameter set in init.ora for shared
We are using oracle 9.2
server.SQL> show parameter dispatcher
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
dispatchers string (PROTOCOL=TCP) (SERVICE=Oracle
92XDB)
max_dispatchers integer 5
mts_dispatchers string (PROTOCOL=TCP) (SERVICE=Oracle
92XDB)
mts_max_dispatchers integer 5
SQL> show parameter shared_server
NAME TYPE VALUE
------------------------------------ ------- ----------
max_shared_servers integer 20
shared_server_sessions integer 165
shared_servers integer 1
MY tnsnames.ora file look
ORACLE92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database_server)(PORT = 1592))
)
(CONNECT_DATA =
(SERVER = shared)
(SERVICE_NAME = Oracle92)
)
)
But when I am querying server column of v$session it's showing dedicated only.
1* select distinct server from v$session
SQL> /
SERVER
---------
DEDICATED
I am unable to understand how this is showing dedicated.. is anything missing in configuration?
Pl. Help
Bhavin...........
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
