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

13 thoughts on “Perl Scripts

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

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

      1. Hello,
        If possible can you email me all the scripts to this email (iliyaz.devops@gmail.com), I would be thankful.

        Thanks
        iliyaz

  3. Hi Bertrand, I can’t download scripts. When i clicked on one file, nothing append. Can you please tell me how to download?

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