SQL tuning

hi,
i am into query tuning in oracle (9.2)
so execution time for a query is very critical to my experiments
unfortunately (for my purpose ofcourse) oracle caches the tables and intermediate results and therefore a query taking minutes runs in milliseconds.

any way i could flush this case.
restarting should be the last answer

-- Nilesh

As far as I know ( I might be wrong) that Oracle instance only catches the query (without re-parsing it) when the syntax is exactly the same. For example, the same query written in upper case and lower case are considered as 2 different queries. I am not sure about the flushing tables part.

Good luck!

Vivi