Re: Hash Table Infrastructure ran out of memory
Date: Thu, 27 Aug 2009 13:18:08 -0700 (PDT)
As Greg said, the way to solve this problem is to use the provided workarounds, or work with Oracle support. In case you want to "dig into issue", Bug 7607581 has some interesting words in it:
"We are out of [hash area] slots
/* if partition can't fit in memory, build disk based HD */
So really we should wspill to disk and not run out of slots
It looks like the PGA has been limited manually"
And the event 32699 is for a more curious mind.
- Original message -----
ORA-32690: Hash Table Infrastructure ran out of memory
1. 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.
4. How to dig into issue using dumps and what to look for.