DB Pga Usage

Pga usage queries

select name, sum(value/1024) "Value - KB"
 from v$statname n,
 v$session s,
 v$sesstat t
 where s.sid=t.sid
 and n.statistic# = t.statistic#
 and s.type = 'USER'
 and s.username is not NULL
 and n.name in ('session pga memory', 'session pga memory max',
 'session uga memory', 'session uga memory max')
 group by name
 /

select *
from v$pgastat
order by lower(name)
/
select
    sum(pga_used_mem) sum_pga_used_mem
    , sum(pga_alloc_mem) sum_pga_alloc_mem
    , sum(pga_max_mem) sum_pga_max_mem
from v$process
/
select
    max(pga_used_mem) max_pga_used_mem
    , max(pga_alloc_mem) max_pga_alloc_mem
    , max(pga_max_mem) max_pga_max_mem
from v$process
/
select *
from v$pga_target_advice
order by pga_target_for_estimate
/
SELECT
    to_number(decode(sid, 65535, null, sid)) sid
    , operation_type operation_type
    , trunc(expected_size/1024) expected_size_k
    , trunc(actual_mem_used/1024) actual_mem_used_k
    , trunc(max_mem_used/1024) max_mem_used_k
    , number_passes
    , trunc(tempseg_size/1024) tempseg_size
FROM V$SQL_WORKAREA_ACTIVE
ORDER BY 1,2
/
select *
from v$pgastat
order by lower(name)
/