Re: flush shared_pool?

So when I execute this command it is supposed to low the performance of a query.
I mean if I run the same query 5 times i will have better performance because of the cache mechanism. If i execute the alter command and then i run the query again, is it going to run like it was the first time or not.
With the timing on, it seems it has no effects. Moreover in the trace I can see Oracle is doing what seems to be system queries after the alter command.
So...

I don't really understand what's going on.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 09:08:13 CST