Hello All

I have an 8.1.6.2.0 database experiencing an ORA-3232 error.

Text: unable to allocate an extent of %s blocks from tablespace %s
---------------------------------------------------------------------------
Cause: An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value
Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.

The tablespace is TEMP with a next extent of 128K. The HASH_MULTIBLOCK_IO_COUNT=0, HASH_JOIN_ENABLED = true and the HASH_AREA_SIZE=10485760.

I do not particularly want to alter the TEMP storage.

Can anyone please advise on what value I should set HASH_MULTIBLOCK_IO_COUNT to or any other relevant advice to avoid this error?

Thanks in advance.

Regards

Steve

__________________________________________________________________
Get your own FREE, personal Netscape Webmail account today at http://webmail.netscape.com/
Oracle LazyDBA home page