Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Flush buffer pool
Thats too drastic, besides there are others that may be impacted by shutdown.
I was hoping for a neat little trick of which I was unaware.
In article <#TnDcpk19GA.346_at_ntdwwaaw.compuserve.com>,
"Jean-Philippe Squelbut" <squelbut_at_csi.com> 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:23:48 CDT