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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Shared and Dedicated Server...

759092Mar 14 2010 — edited Mar 15 2010

Dear All,

Can anybody tell what's the difference between shared and dedicated server? Our database is Oracle 9.0.1 in Windows 2003. Our total session is around 200. Our server is dedicated server. What will be the benefit if we change our database to shared server for specific users???

Shared pool size = 728MB
Buffer Cache = 592MB
Java pool = 104MB
Large pool = 60MB

There is no pga_aggregate_target in our database. Is the configuration ok for more than 200 users??? Most of the times we get 'out of process memory error'. What should we do in this situation??? Plz suggest.

This post has been answered by adnanKaysar on Mar 14 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2010

Added on Mar 14 2010

#database, #general-database-discussions

7 comments

3,895 views