How to find out what is eating your PGA and possible gonna eat your temp seg

select sql_id,MAX_MEM_USED from  v$sql_workarea_active order by 2;

SQL_ID        MAX_MEM_USED
————- ————
3mfa13g41v37x            0
59x35kd3vbd8f        71680
3z294wg0udavm        71680
9m2ctqgmdmw5w        88064
1rwxnm0m9vmc3       306176
9t202yjs4usz2       337920

Advertisement