I am trying to do performance tuning in our SAP sysetm, which uses Oracle version 7.3.4. The problem is we cannot test modifications to data base selects because the first pass fills Oracle's buffers. We want to force selects to always retrieve data directly from the tables.
Is there a way to temporarily either stop Oracle from using buffers or flush the buffers between each test run of the application?
Be advised, I am not a DBA or Oracle guru. Answers will be passed to our resident DBA/guru.