I am using Oracle 10g release 2 database in windows and the db is present locally in my machine .
I tried configuring shared server for my database by changing the parameter shared_servers in spfile.ora through this command
alter system set shared_servers=3 scope=both;
then i reconnected as sysdba and issued the statement
SQL> select username , sid , server from v$session where username='SYS';
USERNAME SID SERVER
------------------------------ ---------- ---------
SYS 159 DEDICATED
SQL> show parameter shared_server
NAME TYPE VALUE
------------------------------------ ----------- --------------
max_shared_servers integer
shared_server_sessions integer
shared_servers integer 3
SQL> show parameter dispatcher
NAME TYPE VALUE
------------------------------------ ----------- ---------------
dispatchers string (PROTOCOL=TCP)
max_dispatchers integer
Then I tried re-starting the db but still faced the same issue .
I then connected as scott and issued the statement
select username,sid,server from v$session where username='SCOTT';
USERNAME SID SERVER
------------------------------ ---------- ---------
SCOTT 146 DEDICATED
but still it was connected using dedicated server.
Let me know if I have to do any other settings before configuring shared server , I went throgh Oracle 10g documentation and there it was mentioned that setting SHARED_SERVERS will configure shared server for the database and no other parameter is needed . Please clarify
] 
Blog
Search
Help
Members
Register
Login
Home
