OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora-03232

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

ora-03232 [message #138220]

Tue, 20 September 2005 14:47

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai ,

we got an error msg from our client ora-03232 unable allocate and extent of 9 blocks from table space 3.

we have set the initial and next of the temp tablespace to 1m which was formerly set as 64k.but even then it is not resolved.

we have also set hash_multiblock_io_join to 32 from 0 in pfile also and started even then no hope..

what else to do.?

plz gimme steps to proceed...very urgent...

regards
bala

[Updated on: Tue, 20 September 2005 14:49]

Report message to a moderator

Re: ora-03232 [message #138221 is a reply to message #138220]

Tue, 20 September 2005 15:00

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

Senior Member
Account Moderator

More details please?
Post the complete error message.

Is that a temp tablespace and is that 8i?
what is your OS? what kind of filesystem?
hash_multiblock_io_join depends on OS.

Report message to a moderator

Re: ora-03232 [message #138223 is a reply to message #138221]

Tue, 20 September 2005 15:04

balavignesh
Messages: 180
Registered: March 2005

Senior Member

sorry i am in hurry...

ora-03232 - unable allocate and extent of 9 blocks from table space 3.

the tablespace 3 is temp;

db --> 8i
os --> linux

what to do..?

Report message to a moderator

Re: ora-03232 [message #138224 is a reply to message #138223]

Tue, 20 September 2005 15:15

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

Senior Member
Account Moderator

set the initial and next parameters to greater than or equal to MAX_IO_SIZE (of the Operating system).

Report message to a moderator

Re: ora-03232 [message #138225 is a reply to message #138224]

Tue, 20 September 2005 15:17

balavignesh
Messages: 180
Registered: March 2005

Senior Member

we have set the initial and next as 1m from 64k.

but we dont know to find the max_io_size in os..?how to find..?

[Updated on: Tue, 20 September 2005 15:18]

Report message to a moderator

Re: ora-03232 [message #138226 is a reply to message #138225]

Tue, 20 September 2005 15:18

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

Senior Member
Account Moderator

talk to your unix admin

Report message to a moderator

Re: ora-03232 [message #138285 is a reply to message #138226]

Wed, 21 September 2005 03:28

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Hi,
I have to confess to not knowing anything about this error, however I did a google on it, and several people appear to have solved the issue by coalescing their tablespace. i.e. it may be that you don't have enough contiguous space available.
Here's one example
http://groups.yahoo.com/group/VOUGlist/message/344

Hope you get it solved.
Jim

Report message to a moderator

Re: ora-03232 [message #138289 is a reply to message #138220]

Wed, 21 September 2005 03:34

Jay Munshi
Messages: 30
Registered: July 2004

Member

if autoextend is on then check of enough hard disk space on the disk where your tempfiles are located.

sorting on disk slows down the system...how about tuning your joins so that your temp requirement goes down.

Regards,
Jay Munshi
http://jaydba.tripod.com

Report message to a moderator

Previous Topic:	I can't purge my recyclebin!
Next Topic:	Oracle Service not starting on Windows 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 10:36:13 CST 2025