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 :
- 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.
