-
Server Mode
Environment:
OS : IBM AIX 5.2
Database: Oracle9i Rel.2
I have a database in 9i Rel.2. Its running in the DEDICATED SERVER MODE. I wana manually change it to SHARED SERVER MODE.Can anyone suggest how can i do that.
How can I check after making the change in which mode my database is running.
I tried to change the mode for another TEST database using DBCA and when I run this query:
SELECT DISTINCT(SERVER)FROM V$SESSION;
its still showing me
SERVER
---------
DEDICATED
Please suggest me how can I change the Database to shared server mode and verify that.
Thanks
-
-
Thanks AMAR..
After following the documnet I am still getting the same result:
SQL>SELECT SERVER FROM V$SESSION;
SERVER
---------
DEDICATED
-
Have you configured dispatchers and and shared_servers ?