Monthly Archives: May 2014

db_io*metrics family

Into the last three posts I introduced three utilities to report database physical IO metrics in real time. I just want to introduce again those three utilities into a single post as: You may have missed one of them. They … Continue reading

Posted in Perl Scripts | 1 Comment

Report database physical IO activity per database function (LGWR, DBWR, Smart Scan…) and IO type in real time

Welcome to db_io_function_metrics, an utility used to display database physical IO per database functions (DBWR, LGWR, Direct Reads, Smart Scan and so on) real-time metrics. It basically takes a snapshot each second (default interval) from the gv$iostat_function cumulative view and … Continue reading

Posted in Perl Scripts | Leave a comment

Report database physical IO activity per IO type and oracle files type in real time

Introduction After I published the blog post related to the db_io_metrics utiliy (based on gv$filestat and gv$tempstat), Luca Canali suggested me to create a version based on the gv$iostat_file cumulative view (available since 11.1). The advantages of this view are: … Continue reading

Posted in Perl Scripts | 2 Comments