-
How to find the most pga consumer sql statement?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|