> Tools and Products >

  Exploring Buffer Cache Visualization (v6e 12-Sep-2011)



 
Free

Product Code: BC_EXPLORE_MM
To download click here.

Description
 
Click to seriously expand picture.

Important: To use this free tool you must download the free CDF Player.


Click to expand picture.
Click to expand picture.
Click to expand picture.
Click to expand picture.
Click to expand picture.
Click to expand picture.
Click to expand picture.



A few people have asked is the data pulled from a real database. No, this is a synthetic model based on Oracle's memory structure and architecture, not the actual number of structures in a production Oracle system. I did try this but because of the number of objects (millions), the visualization was one big giant blob.



Links to other Mathematica-based tools, click here.

Note: Craig has a blog entry that shows how to use the previous release of this tool and introduces buffer cache internals. However, the Library Cache Visualization Tool operates more closely then the previous BC Tool version.

If you want to visually and interactively explore the key Oracle buffer cache structures; the buffer headers, least recently used lists, cache buffer chains, and the write/dirty lists, then you're in for a fantastic surprise. I created this visually interactive tool to help DBAs understand Oracle's buffer cache memory architecture, their relationships, and also to demonstrate how various performance hindering situations can arise... and of course how to resolve them!

I'm finding that these types of visualizations are allowing me to communicate key concepts at a deeper level and much faster. This leaves more time for other material, which is something I'm always trying to optimize (beside Oracle systems, of course).

Version 6e includes a few visual and usage enhancements. Version 6d includes a number of important enhancements. The most obvious is the rotating 3D option (which can see a few examples to the left). However, there are a number of color schemes available, presets to help get you started, and even a Black and White option (use with Visualization set to Circle!) to make it easy to include in papers, presentations, and books.

Please email me (craig@orapub.com) and let me know what you think. As I think you'll see it has some amazing possibilities.

Enjoy!

Craig.

Share your knowledge of this product with other customers... Be the first to write a review

Browse for more products in the same category as this item:

Tools and Products

view my cart my account my support

shopping cart powered by Volusion                                                             To receive OraPub activity updates »