Oracle Metric db block changes

Oracle Tips by Burleson Consulting

The Oracle Documentation notes:

"The db block changes Oracle metric is closely associated to consistent changes, this statistics counts the total number of changes that were made to all blocks in the SGA that were part of an update or delete operation. These are changes that are generating redo log entries and hence will be permanent changes to the database if the transaction is committed.

This statistic is a rough indication of total database work. This statistic indicates (possibly on a per-transaction level) the rate at which buffers are being dirtied. "

The popular WISE tool is the easiest way to analyze Oracle disk performance and WISE allows you to spot hidden disk I/O performance trends. WISE is our favorite Oracle tuning tool, and the only 3rd party tool that we use.

This, and many other Oracle performance metrics are discussed in my book "Oracle Tuning" by Rampant TechPress. You can buy it directly from the publisher and save 30% at this link:

http://www.rampant-books.com/book_2005_1_awr_proactive_tuning.htm

Need an Oracle Health Check?

Do you have bad performance after an upgrade?
Need to certify that your database follows best practices?

BC Oracle performance gurus can quickly certify every aspect of your Oracle database and provide a complete verification that your database is fully optimized.

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page.

Burleson Consulting

The Oracle of database support

Oracle® is the registered trademark of Oracle Corporation.