I am not sure if 9i has introduced any such parameter. Other than sizing smaller redo log files [but that still doesn't guarantee that you get a log-switch every X minutes], you'd have to write a DBMS_JOB or a CRON job to do an ALTER SYSTEM SWITCH LOGFILE.
Hemant At 06:08 AM 18-08-02 -0800, you wrote: >Dear gurus ! >It's either a Sunday's dead brain or ...... >Is there an init.ora parameter to force redo logs switch every 3 minutes or >so ? >( the reason is that I need frequent log switches in order for the standby >database to pickup changes frequently , i.e. to be "almost" in sync with the >primary DB. And, off course, issuing "alter system switch logfile" in the >application is not feasible ) >Now, i only found parameters related to the frequency of the CHECKPOINTs and >not log switches. >Any help , please ... > > >DBAndrey > >* 03-9254520 >* 058-548133 >* mailto:[EMAIL PROTECTED] > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Andrey Bronfin > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). Hemant K Chitale Now using Eudora Email. Try it ! My home page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
