Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to disable the caching for my session in oracle 11g to see how long a query takes.

Is this possible or is there a better way for meassuring the time a query takes to run?

share|improve this question
You could for example enable tracing of session in SQL*Plus. – Yasir Arsanukaev Apr 15 '13 at 14:42
Which cache? Oracle's buffer cache? The file system cache? The cache inside your harddisk? The cache built into your harddisk controller? There is so many caching going on in a modern computer, you won't be able to disable all of it. I would compare/monitor the logical I/O a statement does. This can be obtained e.g. using SQL*Plus' "autotrace" facility – a_horse_with_no_name Apr 15 '13 at 14:43
up vote 0 down vote accepted

Oracle caches (placed in System Global area) can not be turned off.
You can only increase or decrease the size of these caches.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.