November 6th, 2003, 10:47 AM
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
November 10th, 2003, 02:24 PM
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.