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?

Oracle LazyDBA home page