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

9 Responses to Perl Scripts

  1. steve says:

    hi, don’t seem to able to download your scripts, when I clicked on the filename, nothing seems to happen

  2. fid says:

    hi, cannot download your scripts, when I clicked on the filename, nothing seems to happen

  3. chambolle says:

    hi

    hi
    I do not seem to able to download your scripts. Nothing seems to happen

  4. Chitij says:

    Scripts work fine Bertrand..Awesome Stuff.

    Chitij

  5. JAKC says:

    Hi, can’t download all scripts in the repository. When i clicked on one file, nothing append.
    how cant i do or can you send me all repository files

    Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s