| Hit ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3 [message #404797] |
Sun, 24 May 2009 01:07  |
greentea
Messages: 12
Registered: May 2009
|
Junior Member |
|
|
I have encounter the following message when I tried to run a query.
"ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3",
and I have check the tablespace,
tablespace name : temp
initial extend : 131072
next extend : 131072
max extend : 4096
pct increate : 0
and I have change the tablespace,
tablespace name : temp
initial extend : 262144
next extend : 262144
max extend : 4096
pct increate : 0
still does not solve my problem, please advise. Thank you.
|
|
|
|
|
|
| Re: Hit ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3 [message #404844 is a reply to message #404797] |
Sun, 24 May 2009 23:25  |
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
|
Member |
|
|
Hi,greentea,please specify the oracle version.By the way in general the error u asked for may be having one of these causes
1)Your SELECT statement has a "order by" clause, which requires the temporary tablespace for sorting
2) An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that is greater than the tablespace's NEXT value
Solution to the cause
1)Set the tablespace to autoextend mode: ALTER DATABASE DATAFILE filename AUTOEXTEND on NEXT 10M;
2)Increase the value of NEXT for the tablespace using ALTER TABLESPACE DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT
3) Set the parameter HASH_MULTIBLOCK_IO_COUNT = 0 in the ini file and restart the database, This satisfies the condition already that NEXT > hash_multiblock_io_count (as per oracle documentation it is not recommended to modify this parameter)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
