Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Carlos Sierra Shared Scripts

with 2 comments

Every so often I write small scripts for my personal use. Recently I wrote this mini tiny version of a snaper on v$mystat. Basically a script with no parameters that if executed right before and after a SQL I am investigating, it spits out the delta on two snaps on v$mystat taken just before and after my SQL. This way I can quickly validate some of the “cell” counts used by Exadata for example. Of course if I want a more robust script, and I want the capability to monitor a session other than the one I connected, I would use snaper.sql created by Tanel Poder. In my case, I just needed something extra light, with no installation of any object into the database. This mini tiny script is named mystat.sql and it is available here. As time passes by, I will be writing other small and useful scripts. I will upload them into same location. So feel free to visit this Google Drive place every so often. If I upload something exiting I will blog about it. Until then, I just have two new scripts: mystat.sql and tkprof.sql.

Written by Carlos Sierra

October 4, 2013 at 10:43 am

Posted in Scripts

2 Responses

Subscribe to comments with RSS.

  1. thanks Carlos!

    lester gutierrez

    October 4, 2013 at 8:23 pm

  2. The “SQL*Net roundtrips to/from dblink” is a nice metric included in the mix. This script is especially good for SQL (and PL/SQL) developers within a constrained environment.

    Eldon Mellaney

    October 7, 2013 at 1:16 pm


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

Follow

Get every new post delivered to your Inbox.

Join 1,606 other followers

%d bloggers like this: