Re: Flushing data buffer
From: Jack <pgzhang_at_cris.com>
Date: 1996/09/21
Message-ID: <520umm$bdj_at_herald.concentric.net>#1/1
Date: 1996/09/21
Message-ID: <520umm$bdj_at_herald.concentric.net>#1/1
Not aware of a way to flush the entire data buffers. However, you can at least flush the dirty buffer ( which is part of the data buffers ) by manually trigger a checkpoint :
alter system checkpoint ....
Ping
Witold Iwaniec <wiwaniec_at_novalis.ca> wrote:
>Hi all
>Does anybody knows a way to flush data buffer? I need it in order to
>perform different timing tests.
>You can flush shared_pool but it is good for the SQL statement only.
>Thanks
>Witold
Ping Zhang
Senior Consultant
Delta AireLines
770-989-0261(H) 404-715-5595 (O) pgzhang_at_cris.com or ping.zhang_at_mailport.delta-air.com
Received on Sat Sep 21 1996 - 00:00:00 CEST