how to find SGA and PGA values for a schema
s_mFeb 6 2012 — edited Feb 27 2012I 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