Re: ORA-03232 : unable to allocate an extent of 127 blocks from tablespace 5

From: David Fitzjarrell <fitzjarrell_at_cox.net>
Date: 23 Sep 2004 14:49:23 -0700
Message-ID: <9711ade0.0409231349.afa3eed@posting.google.com>

"paddy_nyr" <mpprpp_at_yahoo.com> wrote in message news:<2rg55hF18lck9U1_at_uni-berlin.de>...
> I get the following message on a select statement and tablespace 5 is temp.
>
> My initiatl exetent and next extent on TEMP are set at 1024000 and my
> hash_io_block_count = 0.
>
> Any insite is most appreciated.
>
> I'm using Oracle 8.1.7.4 on Solaris 8.
>
> Thanks

I will take this to mean your hash_multiblock_io_count = 0. With an 8192 (8K) block size this parameter can have a value as large as 8. And, with a NEXT value of 1024000 (100K) you probably should set it that high. Make this adjustmeent and see if the problem disappears.

David Fitzjarrell Received on Thu Sep 23 2004 - 16:49:23 CDT