FLUSHING SELECTED data FROM MEMORY

Hi all, I am performing a ORACLE benchmark on the time taken to retrive data from the database . To do that , I need to run a lot of select statements in a particular table which has 200 columns and 4000 rows with a record size of 20k.

  Since the tests need to be conducted for many times , I need to flush the selected value from the data base buffers to avoid cache hits . Is there a way to flush all the selected values from the database buffers without shutting down the database . Can checkpointing the database be an ideal solution to avoid cache hits . Please help ...............

cheers & thankx in advance
chandrasekar

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sun Feb 07 1999 - 01:42:14 CST