Category Archives: Perl Scripts

Monitor the dNFS activity as of 11.2.0.4

As you may know, there is some views available since 11g to monitor the dnfs activity: v$dnfs_servers: Shows a table of servers accessed using Direct NFS. v$dnfs_files: Shows a table of files now open with Direct NFS. v$dnfs_channels: Shows a … Continue reading

Posted in Perl Scripts, ToolKit | Leave a comment

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

Welcome to db_io_metrics, a new utility to display database physical IO metrics in real time

The db_io_metrics.pl utility is used to display database physical IO real-time metrics. It basically takes a snapshot each second (default interval) from the gv$filestat and gv$tempstat cumulative views and computes the delta with the previous snapshot. The utility is RAC and Multitenant aware. This utility: … Continue reading

Posted in Perl Scripts | 7 Comments

Recovering after the loss of Redo Log files thanks to the file descriptor

This morning when I came at work I discovered that all the redo log files (current, active, inactive..) have been removed from one of our database (useless to say by mistake) resulting in: Errors in file /ec/prod/server/oracle/orabdt/u000/admin/BDT/diag/rdbms/bdt/BDT/trace/BDT_m000_17002.trc: ORA-00313: open failed … Continue reading

Posted in Perl Scripts | 3 Comments

Main pages for exadata_metrics.pl and asm_metrics.pl

A quick post as I realized that I wrote a lot of blog posts related to those 2 scripts (New features, examples, findings…). For centralization/simplicity I just created 2 main pages for those utilities: The one related to exadata_metrics.pl: here … Continue reading

Posted in Perl Scripts | Leave a comment