| How to know if a database is in which mode. [message #135419] |
Wed, 31 August 2005 09:11  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
hi all,
how can i know if my database is running in dedicated or shared server mode.And if my database is in dedicated then how i will change it to shared server mode.
Thanks
Regds
Dinesh
|
|
|
|
| Re: How to know if a database is in which mode. [message #135542 is a reply to message #135419] |
Thu, 01 September 2005 02:31  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
If using unix: check for dispatcher processes/shared_server process. Dispatcher (Dnnn)/Shared_server (Snnn). If no process, Database is in dedicated server mode.
If max_shared_server=0 then database in dedicated mode.
The client profile (sqlnet.ora file) can be configured with USE_DEDICATED_SERVER=on. This adds (server=dedicated) to the CONNECT_DATA section of the connect descriptor the client uses.
Also check V$ views V$DISPATCHER, V$SHARED_SERVER.
Regds
Girish
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
