1 Reply Latest reply on Jul 6, 2009 12:45 AM by alwu-Oracle

    Delete result cache

      Hello guys,

      I just on measuring the response time for some SPARQL Queries that I send to my DB. In order to have similar and correct times and to compare the times, I want to delete the cache.
      Can anyone tell me, how to delete the cache?
      Do I have to delete it by entering any command in SQL*PLUS or is it also possible to delete the cache in Oracle Enterprise Manager?

      ah, btw: I am using Oracle 11g ;)

        • 1. Re: Delete result cache
          Are you talking about result cache? I don't think it is used for your queries.

          To measure query execution time, one way is to run a benchmark query multiple times, get rid of the first one (or two) result(s) and take
          an average of the rest.


          Zhe Wu