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!

WHY PGA IS REQUIRED FOR EVERY USER ?

GTS (DBA)Dec 19 2013 — edited Dec 19 2013

Good Morning Everyone ;

I have a question  about PGA.

WHY  PGA IS REQUIRED FOR  EVERY USER ?

What i got from google ..

Even though the parse information for SQL or PL/SQL may already be available in library cache of shared pool,

the value upon which the user want to execute the select or update statement cannot be shared.

I cant realize it   Can anyone show clear  example , if  possible ?

DB Version is  10.2.0.4.0

OS : oracle linux 5.5

Thanks in advance ..

This post has been answered by Aman.... on Dec 19 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2014
Added on Dec 19 2013
8 comments
848 views