Click to seriously expand picture.
Important: To use this free tool you must download the free Mathematica Player.
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 do this but because of the number of objects (millions), the visualization was one big giant blob.
Links to other Mathematica-based tools, click here.
|
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).
The other added benefit is you can, in a way, create DBA art! Strange, I know, but as you start to explore the buffer cache architecture you'll notice how beautiful (wipe that tear away) the memory structures can be. It's really quite amazing.
It's my second attempt at using Mathematica, so please check back frequently as I'm sure I'll be making many updates. I will also be adding some documentation, which does not exist. One of my daughter's is using Mathematica for her Algebra II class, so I decided to check it out. It's very cool!
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.
|
