Use this tool to visually explore the relationship between total time (think: big bar) and response time (think: time to process a logical IO) over a given interval (think: snapshot range).

We know from hard-fought experience that the more work we push through a system the more processing time involved. That's not rocket science... but to mathematically represent the relationship between work and time is rocket science.

Decades ago Operations Research queuing theory researchers quantitatively established the relationship between work and time. They put into math what we all have experienced. In our DBA world this means that as the system activity increases, then so does CPU consumption and eventually Oracle non-idle wait time.

This tool allows you to visually see the relationship between work and time... plus a lot more. Yeah... it's pretty cool. The tool is completely free!

Documentation: For details about how to use the tool, that is the documentation, please reference the related blog posting by clicking here and then search for "Total Time and Bits of Time".

Comments welcome: 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.

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






Links to other Mathematica-based tools, click here.