Hello,
thanks for your answers. Well I actually wanted to test
the result of changing DBWR's policies (more or less
aggressive). Thanks for your suggestions.
Francesco
"quarkman" <quarkman_at_myrealbox.com> ha scritto nel messaggio
news:oprs8bcy0ezkogxn_at_haydn...
> On Fri, 01 Aug 2003 07:01:00 GMT, Francesco
> <fmarchioniNIENTESPAM_at_libero.it> wrote:
>
> > Hi all,
> > I'd like to monitor when last checkpoint executed on a datafile, in
order
> > to force it -if data's going to be stale-. How can I extract that
> > information ?
> > Thanks
> > Francesco
>
> What do you mean by saying that you want to monitor when data will be
> stale??
>
> But in answer to your specific question, if you investigate init.ora
> parameters such as DB_BLOCK_MAX_DIRTY_TARGET, FAST_START_IO_TARGET or
> FAST_START_MTTR_TARGET, depending on the version which you didn't mention,
> then you will discover that you can variously 'encourage' DBWR to flush
> blocks to disk more aggresively or less aggessively. And since DBWR
> flushing to disk is what is known as a checkpoint, then that would resolve
> your concern about being 'stale'
>
> ~QM
Received on Mon Aug 04 2003 - 02:35:28 CDT
