Vishal desai’s Oracle Blog

November 26, 2013

Compare IO outliers

Filed under: Performance Tuning, Tools, Troubleshooting — vishaldesai @ 9:47 pm

Oracle SQL Developer has nice reporting capability to plot charts. To compare IO outliers using db_hist_event_histogram between two periods, I have created couple of reports for quick comparison.

When you click on report, it will prompt you to select database and input event, period one start snap and end snap, period two start and end snap.

Compare IO wait count outliers by %

image

Compare IO wait count outliers by Value

image

Compare IO wait time outlier by %

image

IO latency for all snaps by Day

image

IO latency for last 24 hours

image

Download link for report definition file.

PS Current version of SQL developer supports only 5 different colors for pie charts so there is overlap of colors in first 3 charts.

About these ads

10 Comments »

  1. jagan.x.rentachintala@chase.com

    On Tue, Nov 26, 2013 at 4:47 PM, Vishal desais Oracle Blog wrote:

    > vishaldesai posted: “Oracle SQL Developer has nice reporting > capability to plot charts. To compare IO outliers using > db_hist_event_histogram between two periods, I have created couple of > reports for quick comparison. When you click on report, it will prompt you > to select dat”

    Comment by Jagan Mohan — November 28, 2013 @ 4:38 am

  2. Very nice post. Please fix the download link, and I will try it in my environment. My management may like it :)
    Thanks. Oleg

    Comment by Oleg — December 9, 2013 @ 10:12 pm

  3. Fixed Download link.

    Comment by vishaldesai — December 11, 2013 @ 3:03 am

  4. Vishal,

    Great stuff. Could you please tell us how does one go about importing this xml file into the SQL Developer reporting feature? I am new to SQL Developer(have used TOAD before), so trying to figure out how do do get the report working…

    Also one other thing from your post “SQL Developer Child Reports and Drill Down” i am trying to figure out how did you integrate those scripts from Tanel and Kerry on SQL Developer.

    If you can point that out, i would really appreciate it.

    Comment by Max Scalf — November 19, 2014 @ 1:45 pm

  5. Thank you so much…

    Keep up the good work…

    GOD Bless you!!!

    Comment by Max Scalf — November 20, 2014 @ 1:26 am

  6. Vishal,

    I was able to import the reports into SQL Developer. But when i run them against my database (but putting in bind variable like db file sequential read or the default of direct path read) i get no data returned….

    i get graph like output that says “No Data to display”…what am i missing here?

    if i run one of the canned report that comes with SQL Developer they work just fine…

    Comment by Max Scalf — November 20, 2014 @ 12:56 pm

    • Sorry, please ignore my last comment. I was able to get this to work….and WOW i am amazed what you have done…GREAT WORK…

      Comment by Max Scalf — November 20, 2014 @ 1:42 pm


RSS feed for comments on this post. TrackBack URI

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

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: