avatar
ORACLE error code 04031# Database - 数据库
k*e
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
avatar
m*g
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

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。