I’ve finished reading the blog post published by Tim Hall on his blog on Oct 04, 2021, you know he shared it by LinkedIn and Twitter as well on the same day. Yes, so many oracle folks and friends all retweet his post (of course include me), It has no doubt that that post has a great sentimental value for everybody. By the way I’ve also followed up the similar blog on 2019, the same intention, I decided to continue writing the blog post for commemorating Joel R. Kallman abidingly and permanently this year.
I’ve found out so many performance metrics on one oracle database monitored by EMCC 13.5, such as the following 2 number of screenshots.
Certainly oracle database exists several pretty critical performance metrics (in particular throughput) more than aforementioned two items. Hence I spent recent two weeks writing a few SQL scripts about oracle performance metrics (aka, AWR trend) to identify my oracle database performance situation (in the past and real time) to tackle urgent performance issue immediately by observation and analysis. In the meantime I published them to my GitHub Repository – as you can see the section with “awr_trend” and “recent_metrics”, on the other hand, I’ll be possible to update them and add some new SQL scripts continually in next few weeks.
These oracle performance metrics are listed here by ascending alphabetically:
- AWR Trend:
- Recent Metrics:
- Recent Average Active Sessions
- Recent Current Logons Count
- Recent CPU Load
- Recent CPU Usage
- Recent Database CPU Time Ratio
- Recent DB time
- Recent Database Wait Time Ratio
- Recent IO MBPS
- Recent IOPS
- Recent Logons Per Sec
- Recent Network MBPS
- Recent Redo Generated Per Sec
- Recent Redo Writes Per Sec
- Recent User Transaction Per Sec
Joel Kallman, we’ll miss you forever, the enormous “Thank you” to great and amazing contribution to oracle community.