Check PGA usage
select name,value-243956081 from v$sysstat where name like ‘workarea executions%optimal’
union all
select name,value-617354 from v$sysstat where name like ‘workarea executions%onepass’
union all
select name,value-602411 from v$sysstat where name like ‘workarea executions%multipass’
select * from v$sysstat where name like ‘workarea executions%’
al 243707814
workarea executions - onepass 616835
workarea executions - multipass 602193
select 720/240981*100 from dual
select (616835+602193)/243707814 from dual
NAME,VALUE
workarea executions - optimal,243822342
workarea executions - onepass,616872
workarea executions - multipass,602230
select * From v$pgastat
alter system set pga_aggregate_target=500m scope=memory