Re: Flush buffer pool

From: GMAN <gman_at_siscom.net_NOSPAM>
Date: Tue, 1 Sep 1998 17:58:34 -0400
Message-ID: <kcZG1.851$g4.2676187@news.siscom.net>

Hi,

A couple of comments:

1). Flushing the buffer pool only cleans out the shared sql pool, so doing a full table scan should have no impact on the shared pool.

2). Remember that flushing only affects packages and sql that are not pinned, so if you have packages pinned in the shared pool, they will not be flushed.

3). Alter system flush shared_pool, I believe....

All opinions are my own, etc....

tmalek_at_kmart.com wrote in message <6shm07$abp$1_at_nnrp1.dejanews.com>...
>Is there a way to flush the buffer pool in 7.3.3? I need to completely
empty
>the buffer pool for performance testing. I have been doing full table scans
on
>an unrelated table but this is getting tiring very quickly.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 01 1998 - 16:58:34 CDT