Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How do I set server from dedicated to shared?

How do I set server from dedicated to shared?

From: Mark Cannata <markcann_at_mac.com>
Date: Fri, 10 May 2002 12:41:10 GMT
Message-ID: <B9013826.DC29%markcann@mac.com>


Hello,
I can't seem to switch from a dedicated to shared server. I have:
 shared_server = 1
 max_shared_server = 20 in my initialization file, but when I run the command:
SELECT server
FROM v$session
WHERE audsid = USERENV('SESSIONID');

I get the following result:

SERVER



DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED
DEDICATED What am I doing wrong?

Thanks for your time,
Mark Received on Fri May 10 2002 - 07:41:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US