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