Re: Query testing

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 20 Sep 2005 23:36:03 +0200
Message-ID: <433080c4$0$10042$ba620e4c@news.skynet.be>

"Chuck" <skilover_nospam_at_softhome.net> wrote in message news:1127235946.6cc2ddaa83e934c4c564312d4e8a121c_at_bubbanews...
> Several years ago I was in a 9i new features class and thought I
> remembered hearing about a feature that would let you test a query over
> and over, forcing it think that that none of the blocks were in memory
> when they query started. Is there such a feature, and if so, can someone
> please remind what it's called or how to access it?
>
> Thanks.
> --
> To reply by email remove "_nospam"

alter system flush shared pool ?

or the NOCACHE hint maybe ?

select /*+ NOCACHE(table) */ ... from table

Matthias Hoys Received on Tue Sep 20 2005 - 16:36:03 CDT