C:\>Sqlplus /nolog sQL>conn sys/iorakle@production as sysdba connected. SQL>Show parameter shared_servers; NAME ITYPE VALUE --------------------- ------- -------------------------- max_shared_servers integer 20 shared_servers integer 1 SQL>show parameter dispatcher; NAME ITYPE VALUE --------------------- -------- ------------------------ dispatchers string (PROTOCOL=TCP)(SER=MODOSE),(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer),(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) max_dispatchers interger 5 mts_dispatchers string (PROTOCOL=TCP)(SER=MODOSE),(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer),(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer) NAME TYPE VALUE -------------------- ---------- ------------------------- mts_max_dispatchers integer 5 SQL>select * from v$shared_server; NAME PADDR STATUS MESSAGES BYTES BREAKS CIRCUIT IDLE BUSY REQUESTS ---- -------- ---------------- ---------- ---------- ---------- -------- -------- -------- -------- S000 66D9222C WAIT(COMMON) 0 0 0 0 0 00 16947130 SQL>select username,server from v$session; USERNAME SERVER ---------------- ------- SYS DEDICATED Here my sys user is connected as dedicated mode,but I created database in shared server mode. I want to know whether my production database is running in shared server mode or not. If not then how can I convert my database from dedicated mode to shared server mode.