Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Log Switch hangup?

Re: Log Switch hangup?

From: Scott Shafer <scott.shafer_at_ildmail.com>
Date: Wed, 3 May 2000 18:02:14 -0500
Message-Id: <10486.104875@fatcity.com>


What is the output of: SELECT * FROM v$database;

Are there any alert.log or Dr. Watson/NT app errors?

Any trace files?

Just trying to troubleshoot remotely here...

--Scott

> Jared :
> Thanks for the reply. I know the log switch stops
> because 1) it doesn't advance in v$log_history for 2
> hours 2)the pplication will commit after inserting
> every 3000 records. When I query the table, it still
> has only 3000 records even after 2 hours.
> I am able to login the database and do all the
> queries. Since it's just a test database, it's not in
> archivelog mode.
> I will set log_checkpoint_timeout to 1200, how
> about the log_checkpoint_interval (I use 10000), do I
> also have to increase? The redo log file is 20m each
> (4 redo logs).
> The application basically has one user with one big
> table of 1.1m records and some other small tables. In
> the java application, it has 15 connections with 12
> threads, has some data contension when the 12 threads
> insert into another table at the same time(also 1.1m
> records).
> Glad to have the list and learn from you about the
> database tuning and application tuning stuff. Thanks.
>
> Eric Fang
>
> --- Jared Still <jkstill_at_bcbso.com> wrote:
> >
> > 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
> >
> >
> >
>
> __________________________________________________
> 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
Received on Wed May 03 2000 - 18:02:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US