One of these could be what you are looking for:
<pre>select * from v$sga;
select * from v$sgastat;
select * from v$parameter;</pre>
If this doesn't help, please provide more details about your query.
Last Wiki Answer Submitted: March 23, 2009 5:53 pm by carlosdl63,580 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.