alert_inst.log: confusing message

Hi,

I have a question about some message in my log files, perhaps anyone can help me

first; basic info:
oracle info: 8.1.6r2 on Linux (SuSe 6.4) kernel 2.2.14, 512Mb memory oracle_home: mount point /u01, 55% used (stable in size) oradata: mount point /u02, 26% used (growing in size)

I found a not-so-normal message in my
/u01/app/oracle/admin/inst01/bdump/alert_inst01.log (${ORACLE_BASE}/admin/${ORACLE_SID}/bdump/alert_${ORACLE_SID}.log)

contents:
...

Thread 1 cannot allocate new log, sequence 8986 Checkpoint not complete

   Current log# 3 seq #8985 mem# 0: /u02/oradata/inst01/redo03.log Thread 1 advanced to log sequence 8986

   Current log# 1 seq #8986 mem# 0: /u02/oradata/inst01/redo01.log Thread 1 advanced to log sequence 8987

   Current log# 2 seq #8986 mem# 0: /u02/oradata/inst01/redo02.log Thread 1 cannot allocate new log, sequence 8988 Checkpoint not complete
...

Although these messages are not repeated a lot (about 20 times), they still are repeated several times which confuses.

Since these messages have no time-stamp within the file, I can only guess when they have occured: most-likly during update statements of 3 tables (about 500 rows per table updated, using 3 cursors, each 3updates in 1 transaction, thus 500 transactions); the update statements have been processed

mount point /u02 (where the data is located) has 1.3Gb (26%) used of a total of 5.4Gb

some .ora settings:
open_cursors = 400
db_block_buffers = 2048
shared_pool_size = 70000000
large_pool_size = 20000000
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 100
log_buffer = 163840
db_block_size = 8192
compatible = 8.0.5

If any out here has some hints or solutions (or links); thnx in advance then Michiel Received on Tue Apr 17 2001 - 15:07:57 CDT