Skip to Main Content

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!

UGA in Shared Server

JavidSep 21 2012 — edited Sep 22 2012
Hi,
At first i want to say that i'm new in oracle environment,especially in database administration field.

I want to disscuss about shared server

Oracle says that shared server gives benefit in memory,however by allocating for sessions UGA in SGA it avoids from using more memory,but in dedicated server ,where for every session Oracle creates PGA in memory.
My question is that:
While Oracle is able to share sessions data in SGA,as it does in shared server ( by allocating for sessions UGA in SGA) ,why it doesn't do it in dedicated server ,by that way to run away from consuming memory ?

In real it is possible only for memory problems we need to configure shared server in our db.

Sorry for grammatic mistakes :(
Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2012
Added on Sep 21 2012
10 comments
539 views