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
Please suggest me how can I change the Database to shared server mode and verify that.