这几天同步全文索引报错
[php]
SQL> exec ctx_ddl.sync_index('DIDX_ITEM_SUMMARY');
begin ctx_ddl.sync_index('DIDX_ITEM_SUMMARY'); end;
ORA-20000: Oracle Text error:
ORA-04030: out of process memory when trying to allocate 123404 bytes (hash-join subh,kllcqas:kllsltba)
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 1328
ORA-06512: at line 1
.
[/php]
如果在同一个会话继续查询,则会报另一个错:
[php]
SQL> select * from user_indexes where index_name='DIDX_ITEM_SUMMARY';
select * from user_indexes where index_name='DIDX_ITEM_SUMMARY'
ORA-00604: error occurred at recursive SQL level 1
ORA-01116: error in opening database file 1
ORA-01110: data file 1: '/opt/oracle/oradata/sc1/system01.dbf'
ORA-27041: unable to open file
Linux Error: 24: Too many open files
Additional information: 3
.
[/php]
但其它会话不会报错
全文索引语法分析器是CHINESE_LEXER,数据库平台是linux as3 + 9204
索引所在字段数据类型是varchar2(4000),有很多数据长度是接近4000的
大家有遇到这种情况的吗?