Perl Scripts

This page list the perl scripts referenced into this Blog.

To get one of them :  Click on the link, and then on the view source button and then copy/paste the source code. You can also download the scripts from this repository to avoid copy/paste (click on the link).

The perl scripts are :

• db_io_function_metrics.pl: This script is used to collect physical IO activity per database function (LGWR, DBWR, Smart Scan…) and IO type in real time. See this page for more informations.

• db_io_type_metrics.pl: This script is used to collect physical IO activity per IO type and oracle files in real time. See this page for more informations.

• db_io_metrics.pl: This script is used to collect physical IO metrics at the database level. See this page for more informations.

• asm_metrics.pl: This script is used to collect and to manipulate ASM metrics in real-time. See “ASM metrics are a gold mine. Welcome to asm_metrics.pl, a new utility to extract and to manipulate them in real time” for more informations.

• system_event.pl : This perl script is used to collect real-time information based on the v$system_event cumulative view.  You can find a practical case in the Measure oracle real-time I/O performance post.

• event_histogram.pl :  This perl script is used to collect real-time information based on the v$event_histogram cumulative view. You can find a practical case in the Measure oracle real-time I/O performance post.

• sqlidstat.pl :  This perl script is used to collect real-time information based on the v$session, v$sesstat and v$statname views.  You can find a practical case in the Link sql_id and oracle stats post.

• exadata_metrics.pl : This perl script is used to collect exadata cell’s real-time metrics based on cumulative metrics. You can find a practical case in the Exadata real-time metrics extracted from cumulative metrics post.

• os_cpu_per_db.pl : This perl script is used to collect real-time cpu utilization per database . You can find a practical case in the Real-Time CPU utilization per oracle database post.

• sysstat.pl : This perl script is used to collect real-time information based on the v$sysstat cumulative view. You can find a practical case in the Real-Time Wait Events and Statistics related to Exadata post.

• segments_stats.pl: This perl script is used to collect real-time information based on the v$segstat cumulative view. You can find a practical case in the Real-Time segments statistics post.

• sgastat.pl: This perl script is used to collect real-time information based on the v$sgastat view. You can find a practical case in the Real-Time SGA component monitoring post.

• enqueue_statistics.pl: This perl script is used to collect real-time information based on the v$enqueue_statistics cumulative view. You can find a practical case in the Real-Time enqueue statistics post.

• librarycache.pl: This perl script is used to collect real-time library cache statistics based on the v$librarycache cumulative view. You can find a practical case in the Real-Time library cache monitoring post.

• sqlidevent.pl:  This perl script is used to collect real-time information based on the v$session_event  view. You can find a practical case in the Real-Time Wait Events and Statistics related to Exadata : Part II post.

• real_time.pl: This perl script is used to collect real-time information from the database based on the cumulative views. You can find an explanation into the Real-Time database utilities grouped into a single script post.

Advertisement