Re: Flush buffer pool

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
>
Received on Thu Sep 03 1998 - 02:15:14 CDT