Re: Log Switch hangup?

We've got to get past these hangups of yours and on to the mother of your database problems...
--Freud

(Sorry, Jared, the thought processes inspired by the subject line were just too warped to pass up)

• Original Message ----- From: "Jared Still" <jkstill_at_bcbso.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, May 03, 2000 12:25 PM Subject: 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
> jkstill_at_teleport.com - private
>
>
> --
> Author: Jared Still
> INET: jkstill_at_bcbso.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
Received on Wed May 03 2000 - 15:16:14 CDT