Another python graph – one wait event

Here is another graph that I created in Python with Pyplot:

onewait_medium

This is onewait.py in my PythonDBAGraphs repository. myplot.py has the plotting code.  db.py has the database access code.

I blanked out the database name in the example graph to hide it.

This is a graphical version of my onewaitevent.sql script. It queries the AWR looking at a particular wait event per hour. You look at the number of wait events in an hour to see how busy the system was and then the average elapsed time for that hour. Also, you set the smallest number of waits to include so you can drop hours where nothing is going on.

In the example graph you can find times where the average time for a db file sequential read is high and the system is busy. You use the top graph to see how busy the system is and the bottom to see where the average time spikes.

Still just an experiment but I thought I would pass it along. It isn’t that hard to create the graph in Python and I seem to have a lot of flexibility since I’m writing code instead of using an existing program like Excel.

Bobby

P.S.

4/26/2021

Updated the links to point to the current version of the same code.

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.
This entry was posted in Uncategorized. Bookmark the permalink.

3 Responses to Another python graph – one wait event

  1. Anonymous says:

    Great post. Thank you!

  2. Krishna says:

    Does your script create graph from ash/dash data to drill events and connectons together

Leave a Reply to Krishna Cancel reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.