From: dshi@magpage.com (David Shi)
Subject: Re: is it possible to flush data block buffer without restart the database?
Date: 1997/12/12
Message-ID: <66s79q$j5i$0@204.179.92.83>#1/1
References: <66q79v$mb4$1@204.179.92.204> <01bd070b$607a89c0$0d87c584@buggs>
Newsgroups: comp.databases.oracle.server



I have been testing how fast Oracle accomplish certain tasks, and I
want to avoid the situation that next task is faster than the previous
one because of data cache.

On 12 Dec 1997 13:47:33 GMT, "Leonid Lamburt" <ll01@gte.com> wrote:

>And what would be the purpose of flushing the buffer cache?
>I thought that it uses LRU mechanism, and unless something was pinned into
>it, the
>most recently fetched blocks will  squeeze out the old ones.
>(May be I am wrong)
>
>David Shi <dshi@magpage.com> wrote in article
><66q79v$mb4$1@204.179.92.204>...
>> I know you can flush sql shared area, but what about data block
>> buffer? 
>> 
>> Thanks.
>>