KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
On oracle 10gr2, I have several sql queries that I am comparing performance. But after their first run, the v$sql table has the execution plan stored for caching, so for one of the queries I go from 28 seconds on first run to .5 seconds after. I've tried ALTER SYSTEM FLUSH BUFFER_CACHE; After running this, the query consistently runs at 5 seconds, which I do not believe is accurate. Thought maybe deleting the line item itself from the cache: delete from v$sql where sql_text like 'select * from.... but I get an error about not being able to delete from view.
Tags (comma-separated)
Save Edits
Cancel