Newsletters Archive - All

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Flushing the Oracle Data Buffer Cache During Performance Testing — (23-September-2010)

A common question among developers is how to flush the Oracle data buffer 
cache. During performance testing, it is important to replicate a real-world 
production environment as closely as possible; especially when it involves 
reducing physical I/O (disk reads). Developers need the ability to test the 
effects of changing execution paths without getting accidental benefits from 
the buffered data in the database buffer cache. Having the ability to flush the 
data buffer cache is essential throughout this phase of the SQL tuning process. 

The following note provides several methods used to flush the Oracle data 
buffer cache depending on the release of Oracle.

Flushing the Oracle Data Buffer Cache During Performance Testing

----------------------------
Jeffrey M. Hunter, OCP
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------