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!

how to find SGA and PGA values for a schema

s_mFeb 6 2012 — edited Feb 27 2012
I did

Select * from v$SGA;
and Select * from v$pgastat;

to get the SGA and PGA sizes. But I doubt they return values for teh whole database server and not just for a schema that I am logged into. Please help me explain what should be the correct query or what views I should query against to find those values for a particular instance/schema??


Thanks,
Samip
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2012
Added on Feb 6 2012
4 comments
4,649 views