hi,susan lam
yes ,checkpoint problems.
you have IO problem. the DBWR write too slow
the disk array is too slow?
use AIO or IO slaves ?
Best regards
msn: biti_rainy_at_hotmail.com
a dba from alibaba(china)
- from the mail-----
>I'm running a batch updates on my database and I've
>been getting the following messages in my alert file:
>"cannot allocate new log
>check point incomplete."
>
>My job hangs waiting on log file switch (checkpoint
>incomplete) event.
>
>I have 8 redo log groups (300MB members). When I did a
>query on v$log, all of the log members' archived
>status ='YES' except for the current member. So it
>appears that the rest of the seven groups have been
>archived but yet the database could not advanced to
>the next redo log.
>
>Furthermore, the alert.log does not show frequent log
>switches. It switches log every 10mins and about every
>5mins, the database complains
>about "cannot allocate new log". Does not appear to be
>a problem with the number or size of the redo logs.
>Anyone has any idea what may be a possible problem?
>checkpoint?
>
>thanks.
>
>susan
>
>
>
>
>__________________________________
>Do you Yahoo!?
>The all-new My Yahoo! - Get yours free!
>http://my.yahoo.com
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 18 2004 - 22:22:34 CST