Re: is it possible to flush data block buffer without restart the database?

From: David Shi <dshi_at_magpage.com>
Date: 1997/12/12
Message-ID: <66s79q$j5i$0@204.179.92.83>#1/1

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_at_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_at_magpage.com> wrote in article
><66q79v$mb4$1_at_204.179.92.204>...
>> I know you can flush sql shared area, but what about data block
>> buffer?
>>
>> Thanks.
>>
Received on Fri Dec 12 1997 - 00:00:00 CST