Re: analyzing queries performance

In article <90nqst$42l$1_at_nnrp1.deja.com>,   letokai_at_my-deja.com wrote:
> I'm trying to test queries performance in different conditions but I
> can't disable the cache memory.
> I've tried many commands like Flush Shared_pool but it has no effects
> on the timing.
>
> Do someone know a way to unable cache memory?
> What is the 'NOCACHE' option?
> How is it used?
>
> Thanks
> JOHN
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

The only way the buffer cache can be flushed is by taking tablespaces offline and bring them back online. Obviously this is a tric. The buffer cache can NOT be disabled.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.