Query to see total PGA memory used by the instance
select sn.name, sum(s.value)
from v$sesstat s, v$statname sn
where s.statistic# = sn.statistic#
and sn.name like '%pga%'
group by sn.name
Labels: sql scripts, v$sesstat, v$statname
This blog is to record the steps I take to explore the world of Oracle database.
select sn.name, sum(s.value)
Labels: sql scripts, v$sesstat, v$statname
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home