Hi folks,

We suffered this early morning from significant virtual memory paging on our main production server during the ETL processes .
Eventually, we were forced to reboot the server.
I need to investigate who were the most pga memory consumers sessions before the server's crashing and how many bytes the session used from the pga?
Is there any historical session table which store this information?

DB version : 10.2.0.4
OS : Sun Solaris 10 64 bit

Thanks in advance,
Nir