OraFAQ Forum: Server Administration » ORA-03232 in Oracle 8i 8.1.7

Home » RDBMS Server » Server Administration » ORA-03232 in Oracle 8i 8.1.7

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-03232 in Oracle 8i 8.1.7 [message #58516]

Thu, 04 September 2003 08:14

Vanisri Yalamanchili
Messages: 4
Registered: October 2002

Junior Member

Hi All,

We have oracle 8.1.7 on Sunfire V1280. I have set the temp tablespace next extent to 128K as I heard that the MAX_IO is defaulted to 128K on SUN Solaris. Autoextend is off and we keep getting this error ORA-03232 - Unable to allocate 25 blocks to tablespace 3 which is TEMP tablespace in our case. I am hoping that someone out there may have some suggestions. Thank you.

Report message to a moderator

Re: ORA-03232 in Oracle 8i 8.1.7 [message #58521 is a reply to message #58516]

Thu, 04 September 2003 11:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

for solaris MAX_IO_SIZE is 128 k (by default, unless u change).
I beleive , u have set the INITIAL=NEXT=128k   and
            HASH_MULTIBLOCK_IO_COUNT = 0 ( defualt in 8i..if it is changed..thats a different case..)
so just try to recreate the temp tablespace with larger extents.

Report message to a moderator

Re: ORA-03232 in Oracle 8i 8.1.7 [message #58524 is a reply to message #58521]

Thu, 04 September 2003 11:37

Vanisri Yalamanchili
Messages: 4
Registered: October 2002

Junior Member

Mahesh, Thanks for your response. HASH_MULTIBLOCK_IO_COUNT is currently set to 0. Since oracle recommends not to change it I did not. But I think I fixed this problem. I just altered the temp segment to have initial and next to be 1M each and that seems to have fixed the problem. Rigorous stress tests are going against this DB. But we are able to reach higher levels of stress than we did before without ever hitting this error so far. I seem to have done the same thing that you suggested. Thanks again.

Report message to a moderator

Previous Topic:	Question about datafiles assigned to tablespace
Next Topic:	Urgent Help! Rollback Segements - Automatic undo mode???!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:23:09 CDT 2024