Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Re: Dedicated VS. Shared server Part 2

640410Aug 6 2009 — edited Aug 7 2009

Hi Friends,

Oracle 10g DB
OS = Windows2003

I have 3party applications with 800 users.

Is it OK if I use Oracle Database Assistant to switch DEDICATED / SHARED server connection?

I set my db server to SHARED connection, I can see that all the users can connect.

If I change my db server to DEDICATED connection, only half can connect and the other half hangs.

I already set my db to > alter system set sessions=1000 scope=both;

What else do I need to allow all users to use dedicated connection?

Thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 4 2009

Added on Aug 6 2009

#general-database-discussions

7 comments

613 views