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

3 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


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: