Re: Help: PL/SQL execution error

"Yang" <yg.yang_at_wanadoo.fr> wrote in message news:<9d6s4h$ck6$1_at_wanadoo.fr>...
> check your file alert.log , maybe you can get the entire error message...
>
>
> Weidong Zhou wrote in message <3AF6C89E.E0EA5CFE_at_sabre.com>...
> >Hi, all,
> >I have a PL/SQL procedure. It runs fine with one instance but have
> >problems in another instance. The error is listed as follows:
> >ORA-03232: unable to allocate an extent of 8 blocks from tablespace 2
> >
> >The problem is that we do not have any tablespace name called 2. We know
> >ROLLBACK tablespace use datafile 2 and the procedure do have a lot
> >update operation. We add more space to ROLLBACK tablespace and still got
> >the same error. Does anyone have any idea how to fix the problem. Thanks
> >a lot.
> >
> >Regards,
> >
> >Weidong Zhou

If you query v$tablespace, you will find that tablespace #2 is your temporary tablespace. Your statement is attempting to perform a hash join and your NEXT extent size for your temporary tablespace is less than the HASH_MULTIBLOCK_IO_COUNT, which relates to the OS parameter MAX_IO_SIZE. For Solaris 2.8, I ended up setting the NEXT to 512K and the problem went away.

  -bruce Received on Tue Jun 05 2001 - 16:06:24 CDT