What or why are you trying to achieve? The db is always in a consistent
state as far as recoverability goes when in archive log mode with
regular checkpoints...

>>> "bnavid" <oracledba-ezmlmshield-x27547401.[Email address protected]
7/27/2006 3:00:31 PM >>>
We want to implement capability to put DB in quiesce mode (flush dirty
buffers and commit) frequently without impact to jobs running; this is
to acheive consistant stateof DB.
I know forcing CHECKPINT and/or putting DB in QUIESCE mode will do that
but will they effect the performance or throw errors at users ?
Has anyone done this before or has some ideas how to do it effectively
in Oracle?


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page