Re: Hash Table Infrastructure ran out of memory

From: Yong Huang <yong321_at_yahoo.com>
Date: Thu, 27 Aug 2009 13:18:08 -0700 (PDT)
Message-ID: <642361.26406.qm_at_web80604.mail.mud.yahoo.com>

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.

Yong Huang

• 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.       

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 27 2009 - 15:18:08 CDT