|
|
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 ---------------------------- |