"Burt Peltier" <burttemp1ReMoVeThIs_at_bellsouth.net> wrote in message news:<qFdAb.989$rG.434_at_bignews3.bellsouth.net>...
> Just commenting on the "switch logfile" and "host sleep" commands below...
>
> I think what you might want to do instead of a "switch logfile" and
> "host sleep" command is:
> alter system checkpoint;
> alter system archive log current;
>
> These 2 commands do not return control to the running program (like sqlplus)
> until they are done. The "switch logfile" command returns control
> immediately,
> but kicks off the background checkpoint and LGWR copy of REDO.
>
> Anyway, a host sleep command has the potential in an unusually busy system
> to not sleep long enough.
>
Burt,
Thanks for your suggestion here. In all the hoopla with HJR, I missed
your response on this item.
Lynn Sattler
[snip]
Received on Thu Dec 11 2003 - 07:36:50 CST
