同步WF时总提示APPLSYSD表空间不足

1、求助 同步WF时总提示APPLSYSD表空间不足 我执行一个请求,同步 WF 局部表,结果报错ORA-1653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 138255 in tablespace APPLSYSD而该表空间空闲剩余3.7GB啊!出现好几次了,每次要增加1GB的数据文件才行。而且该表空间有时候一下增加1GB左右空间,有时候又自己变少了。有人能帮助、解释一下吗?解决过程：1 try to resize the tbs's datafile,but no use2 这是他的数据文件分布情况3 有人建议扩大这

2、个table的maxextents，我们不妨看看具体报错ORA-1653: unable to extend table APPLSYS.WF_LOCAL_ROLES_STAGE by 138255 in tablespace APPLSYSD题是很明显，使这个table要申请那么多空间，可是tbs不能满足，而非tbs由空间，可是table的maxextents到了，所以这种说法否掉4 后来我建议对方察看这个tbs的连续的free_space,因为oracle存取数据的时候要找的是连续的space,但是对方察看后发现freespace也足够5最后在metalink发现如下bug2812945C

3、auseWF_LOCAL_ROLESWF_LOCAL_USER_ROLESWF_LOCAL_USER_ROLES_STAGEWF_LOCAL_ROLES_STAGEWF_LOCAL_ROLES_TL_STAGEFeedback from development. 解决方案：To implement the solution, please execute the following steps: 1. List storage parameters for wfds tables.select table_name, partition_name, initial_extent, next_e

4、xtent, pct_increasefrom dba_tab_partitionswhere table_name in ('WF_LOCAL_USER_ROLES_STAGE','WF_LOCAL_USER_ROLES','WF_LOCAL_ROLES_STAGE','WF_LOCAL_ROLES','WF_LOCAL_ROLES_TL','WF_LOCAL_ROLES_TL_STAGE')Unionselect table_name, 'No partition', initi

5、al_extent, next_extent, pct_increasefrom sys.dba_tables twhere table_name in ('WF_LOCAL_USER_ROLES_STAGE','WF_LOCAL_ROLES_STAGE','WF_LOCAL_ROLES_TL_STAGE')order by 1, 2;2. All partitions that have next extent over 16M or pctincrease different to 0 need to be modified.Generate

6、 the statements to correct these storage parameters using this SQL statement:Select 'Alter table APPLSYS.' | table_name | ' modify partition '| partition_name | ' storage ( next 16M pctincrease 0);' statementfrom dba_tab_partitionswhere table_name in ('WF_LOCAL_ROLES'

7、,'WF_LOCAL_USER_ROLES ')and (pct_increase <> 0 or next_extent > 16 * 1024 * 1024)Unionselect 'Alter table APPLSYS.' | table_name | ' storage clause (NEXT 16M pctincrease 0);'from sys.dba_tables twhere table_name in ('WF_LOCAL_USER_ROLES_STAGE','WF_LOCAL_R

8、OLES_STAGE','WF_LOCAL_ROLES_TL_STAGE')and (pct_increase <> 0 or next_extent > 16 * 1024 * 1024)order by 1;3. Run previous statements generated.4. Rerun statement in step #1 to review the changes in the storage wfds table storage parameters.5 让对方察看table的定义SQL> select TABLE_NAM

9、E, INITIAL_EXTENT, next_extent2 from all_tables3 where table_name = 'WF_LOCAL_ROLES_STAGE'.TABLE_NAME INITIAL_EXTENT NEXT_EXTENT - - - WF_LOCAL_ROLES_STAGE 40960 755048448 可以apply patch:Patch 2350501打完后，应该是这样：Change the next_extent to 5M as shown below .SQL> select TABLE_NAME, INITIAL_EXTENT, next_extent2 from all_tables3 where ta