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