k**e
发帖数: 86 | 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*g
发帖数: 377 | 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
|
|
