RE: Frequency of Log Switches

Use the following SQL command:
SQL> alter system switch logfile;

You could have a CRON job that does the above every 15 mins.

Gillian

• SAURY Alain <ASAURY_at_recherche.loreal.com> wrote: > I beg to differ : I am running 8.1.6 on NT with
  > log_checkpoint_timeout = 300
  > and can have as much as 40 minutes between log
  > switches.
  >
  > I suppose that forcing a checkpoint does not forces
  > a log switch (whereas
  > the log switch forces the checkpoint).
  >
  > Anybody having an idea on how to force a log switch
  > ?
  > Alain.
  >
  > -----Message d'origine-----
  > De: Kieran Murray [SMTP:Kieran.Murray_at_esat.com]
  > Date: jeudi 30 novembre 2000 10:46
  > À: Multiple recipients of list ORACLE-L
  > Objet: RE: Frequency of Log Switches
  >
  > Steven,
  >
  > try changing the initialization parameter
  > LOG_CHECKPOINT_TIMEOUT to
  > be 900
  > and set the LOG_CHECKPOINT_INTERVAL to be a very
  > high value (greater
  > than
  > the size of the redo logs),
  > this will cause log switches every 15 minutes or
  > when the log file
  > is full.
  > Both of these values can
  > be dynamically altered using ALTER SYSTEM.
  >
  > Regards,
  > Kieran Murray
  > Norkom Technologies,
  > 43 Upper Mount Street, Dublin 2, Ireland
  > Tel:- +353 86 8117916
  >
  > -----Original Message-----
  > Sent: 29 November 2000 22:03
  > To: Multiple recipients of list ORACLE-L
  >
  >
  > I know that the recommended optimal log switch
  > interval is 30
  > minutes, and
  > our log sizes of 20Mb average a little less than
  > that. Now that I
  > am
  > looking to implement a standby database, my users
  > have a requirement
  > that no
  > more than 15 minutes of data should be lost if we
  > need to fail over
  > to
  > standby. I was looking through the Oracle 8
  > reference (we are
  > running 8.0.5
  > on SunOS 5.6) and I could not find one that would
  > force a log switch
  > based
  > on time, not size. Is there one, or do I need to
  > create a script
  > that
  > simply forces a log switch every 15 minutes?
  >
  > TIA,
  > -------------------------------------
  > Steven Monaghan
  > Oracle DBA
  > MSC Industrial Direct Co., Inc.
  > Melville, NY
  > MonaghaS_at_mscdirect.com
  > http://www.mscdirect.com
  > -------------------------------------
  >
  >
  > This e-mail is intended for the use of the
  > addressee(s) only and may
  > contain
  > privileged, confidential, or proprietary
  > information that is exempt
  > from
  > disclosure under law. If you are not the intended
  > recipient, please
  > do not
  > read, copy, use or disclose the contents of this
  > communication to
  > others.
  > Please notify the sender that you have received
  > this e-mail in error
  > by
  > replying to the e-mail. Please then delete the
  > e-mail and destroy
  > any
  > copies of it. Thank you.
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Steven Monaghan
  > INET: MonaghaS_at_mscdirect.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).
  >
  >
  >
  >

  ---

  
  > This email and any files transmitted with it are
  > confidential and
  > intended solely for the use of the individual or
  > entity to whom they
  > are addressed. If you have received this email in
  > error please
  > notify
  > the system manager.
  >
  > http://www.marketplace.ie
  > Ireland's Home for eBusiness
  >
  >

  ---

  
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Kieran Murray
  > INET: Kieran.Murray_at_esat.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).