Re: Flush buffer pool

From: <tmalek_at_my-dejanews.com>
Date: Fri, 04 Sep 1998 21:34:54 GMT
Message-ID: <6spmdu$tnu$1@nnrp1.dejanews.com>

I didnt think the buffer pool was part of the shared pool, are you sure of this? I will crack open my concepts manual to check on this.

In article <35EE4202.73CDCE30_at_worldonline.nl>, Ton Raaijmakers <torgan_at_worldonline.nl> wrote:
> You could use :
>
> alter system flush shared_pool;
>
> This really works.
>
> Ton
>
> Jean-Philippe Squelbut wrote:
>
> > What do you think of svrmgrl shutdown and startup ?
> >
> > tmalek_at_kmart.com a écrit dans le 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
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 04 1998 - 16:34:54 CDT