A reader, September 04, 2017 - 2:06 pm UTC
Hi,
Can you please let know how to find historic session details ,consuming huge pga
Again in 11g does pga growth depends on number process *3 ,or double of pga size
September 05, 2017 - 6:26 am UTC
DBA_HIST_PGASTAT contains pga details per AWR snapshot, and DBA_HIST_ACTIVE_SESS_HISTORY for session level detail.
In 11g, we'll try keep to pga_aggregate_target, but if you go way over (eg with a giant PLSQL table) there's nothing we can do to stop it...and eventually you'll blow up
(Hence the new parameter in 12)