Re: Flushing data buffer
From: Naren Chintala <naren_at_mink.att.com>
Date: 1996/09/17
Message-ID: <51mpqp$2b3_at_newsb.netnews.att.com>#1/1
Date: 1996/09/17
Message-ID: <51mpqp$2b3_at_newsb.netnews.att.com>#1/1
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
There is a way to flush the dirty blocks from the data buffer. The dirty
buffers are written to disk under the conditions described in the Server
Concepts Manual
(Chap. Memory Structures and Process). Its too much to type.
Naren Chintala
naren_at_mink.att.com
Received on Tue Sep 17 1996 - 00:00:00 CEST