Re: Log Switch hangup?

How do you know the log switch stops?

Are you able to login to the database?

It sounds like you have log archiving on, but the destination directory is full. The database will hang until you make room for new log files.

Or you have the database in archivelog mode, but do not have the archiver process running.

Also, switching logs every 30 seconds is too frequent.

Resize your logs so that they never switch less than 20 minutes apart, and set log_checkpoint_timeout = 1200 in your init.ora so that checkpoints are ensured at 20 minute intervals.

Jared

On Tue, 2 May 2000, Eric Fang wrote:

> The database is Oracle8i on NT. After certain
> transactions(delete 1m records from a table), the log
> switch stops(I checked v$log_history), usually it
> switches every 30 seconds, I have to tune the redo log
> by either increase the redo log file(one user with 4
> redo log file, 10m each) or increase the
> log_checkpoint_interval(I set the value as 80000 with
> db_block_size=16k).
>
> Could anyone give me some advice? Thanks.
>
>
> ERic Fang
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Eric Fang
> INET: eric_fang_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Wed May 03 2000 - 11:18:24 CDT