RE: Log Switch hangup?

James:

   Thanks for your advuce. I set
log_checkpoint_timeout to zero and the checkpoint happens every 30 minutes now.

Eric Fang

• James Bullard <jbullard_at_onvia.com> wrote:
  > Why not set the log_checkpoint_timeout to zero? If
  > you set it to 1200
  > you're forcing a checkpoint every 2 minutes.
  >
  > James
  >
  > -----Original Message-----
  > Sent: Wednesday, May 03, 2000 11:29 AM
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > 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
  > also send the HELP command for other information
  > (like subscribing).
  > --
  > Author: James Bullard
  > INET: jbullard_at_onvia.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