ORACLE error code 04031 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

ORACLE error code 04031

ORACLE error code 04031# Database - 数据库

k*e2002-08-22 07:08

1 楼

SELECT cdr_filename, missing_rec_seq_no, flag FROM missing_rec_seq_no_audit
WHERE cdr_filename in (select cdr_filename from split_audit WHERE
split_filename=' ' AND file_time >= to_date('01/08/2002 00:00:00','dd/MM/yyyy
HH24:MI:SS') AND file_time <= to_date('22/08/2002 14:13:42','dd/MM/yyyy
HH24:MI:SS')) order by CDR_FILENAME, MISSING_REC_SEQ_NO;
Exception, While accessing the database
java.sql.SQLException: ORA-04031: unable to allocate 8192 bytes of shared
memory ("large pool","unknown objec

m*g2002-08-22 07:08

2 楼

large pool out of memory.
You may want to try:
Shutdown Oracle first. Increase LARGE_POOL_SIZE in the db's init file.
Normally located under directory $ORACLE_HOME/dbs( in unix and linux) or you
may find a soft link there. In windows NT/2000, normally located under
directory %ORACLE_HOME%\DATABASE. Then restart the oracle database.
Hope it can help. Please let us know the result if you tried.

00:00:00','dd/MM/yyyy
外

【在 k**e 的大作中提到】

: SELECT cdr_filename, missing_rec_seq_no, flag FROM missing_rec_seq_no_audit
: WHERE cdr_filename in (select cdr_filename from split_audit WHERE
: split_filename=' ' AND file_time >= to_date('01/08/2002 00:00:00','dd/MM/yyyy
: HH24:MI:SS') AND file_time <= to_date('22/08/2002 14:13:42','dd/MM/yyyy
: HH24:MI:SS')) order by CDR_FILENAME, MISSING_REC_SEQ_NO;
: Exception, While accessing the database
: java.sql.SQLException: ORA-04031: unable to allocate 8192 bytes of shared
: memory ("large pool","unknown objec