-
ora-06580 Hash Join out of memory
OS Win 2000 4Gb 2x2.4 Ghz
DBMS 8.1.7.4.1 (Block Size 8192)
SOT_AREA_SIZE = 1M
Peoplesoft 7.60 Financials
Hi Guys
Our Peoplesoft application reported an ora-06580 error whilst running a batch job.
The error description suggests there was a lack of memory space to store the row even though the rowsize in question wouldn't be more than about 200 bytes. Interesting that the message suggests altering HASH_JOIN_MULTIBLOCK_IO_COUNT even though Oracle recommends that we don't.
Another DBA here suggests this was due to a "clash of transactions" although he couldn't back that up. OK the machine was pretty busy at the time but I can't see how "clashing transaction" would raise this error.
Any thoughts (or even abuse for being so dumb) would be appreciated.
Nick
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
|