ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-03232: 无法分配 34 块 (源于表空间 3)

ORA-03232: 无法分配 34 块 (源于表空间 3)

原创 Linux操作系统 作者:victor1010 时间:2009-04-20 16:50:38 0 删除 编辑

刚帮同事解决了这个问题,记录一下。

ORA-03232: 无法分配 34 块 (源于表空间 3)

 

select * from v$tablespace where ts#=3

TEMP

解决方法:

alter tablespace temp default storage(next 1M);

 

资料:

摘自metalink 125271.1
Error:  ORA-3232
Text:   unable to allocate an extent of %s blocks from tablespace %s
---------------------------------------------------------------------------
Cause:  An attempt was made to specify a HASH_MULTIBLOCK_IO_COUNT value that         
is greater than the tablespace's NEXT value  
Action: Increase the value of NEXT for the tablespace using ALTER TABLESPACE         
DEFAULT STORAGE or decrease the value of HASH_MULTIBLOCK_IO_COUNT.
Option 1 --------  Set the initial and next extent size of the temporary tablespace equal to or  greater than MAX_IO_SIZE.
Option 2 --------  Set HASH_MULTIBLOCK_IO_COUNT to a value different than 0. This however should not be required as Oracle computes the value individually for every query.  If you let  Oracle do the automatic computation, the value of the parameter appears as 0 in the  V$PARAMETER dynamic performance view.  Note: If you are using Oracle's multi-threaded server architecture, Oracle ignores  any value you set for this parameter, and instead uses a value of 1

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8102208/viewspace-591039/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-29

  • 博文量
    296
  • 访问量
    568590