Re: FLUSHING SELECTED data FROM MEMORY

Hi

    try this
    alter system flush shared_pool;

hope this help.
good luck.

pradhan

chandrasekar_at_my-dejanews.com wrote:

> 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 - 18:30:14 CST