由买买提看人间百态

topics

全部话题 - 话题: 04031
(共0页)
k**e
发帖数: 86
1
来自主题: Database版 - ORACLE error code 04031
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
来自主题: Database版 - ORACLE error code 04031
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
(共0页)