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