We use Oracle 11gR2 on win2008R2 and develop SQL query and tune SQL query.
When we compare SQL query performane before tuning and after tuing , what should we do to eliminate the effect of Database Buffer Cache ?
In other oracle article , I saw we need to clear Database Buffer Cache to compare query peformance precisely.
But I heard here that I should not clear Buffer Cache , because it has siginificant infuluence to the end users.