Hash Table Infrastructure ran out of memory
Date: Wed, 26 Aug 2009 23:20:29 -0500
We are using oracle 10.2.0.3 on sparc solaris 64 bit with 16 CPU and 32GB of physical memory. Our sga_target is 12G and pga target is 15G.
We are receiving
ORA-32690: Hash Table Infrastructure ran out of memory
We had identified query which is running in parallel 8 and using huge hash group by. May be due to that this error is there. But here are some questions
- How to find why this error is coming. Any trace dump or pga dump can help ? Because i believe it was not using temp space at all. We have 2 TB temp space free.
- i think for hash group by if it don't get any memory it spill to temp ? then why this error
- How to monitor this while this error is happening.
- How to dig into issue using dumps and what to look for.
5 IS PGA_AGGREGATE_TARGET only use 5 % for each parallel process
Thanks & Regards,
Marie von Ebner-Eschenbach<http://www.brainyquote.com/quotes/authors/m/marie_von_ebnereschenbac.html> - "Even a stopped clock is right twice a day."
http://www.freelists.org/webpage/oracle-l Received on Wed Aug 26 2009 - 23:20:29 CDT