Vishal desai’s Oracle Blog

July 3, 2013

v$event_histogram

Filed under: Performance Tuning, Troubleshooting — vishaldesai @ 8:48 pm

Luca has written awesome script to visualize Oracle latency using Heat Maps. Many times Management appreciate numbers and percentages so my script will attempt to show those numbers since instance startup.

SQL> @wait_histogram direct%path%read

                                                                                % Wait Roll % Wait   % Wait Roll % Wait
EVENT                               WAIT_TIME_MILLI_RANGE          WAIT_COUNT    Count       Count     Time        Time LAST_UPDATE_TIME
----------------------------------- ------------------------------ ---------- -------- ----------- -------- ----------- ---------------------------------------------------
direct path read                    4096-8192                               1        0           0     0              0 02-JUL-13 03.15.05.925862 PM -05:00
direct path read                    2048-4096                              25        0           0     0              0 03-JUL-13 09.05.04.647574 AM -05:00
direct path read                    1024-2048                              54        0           0     0              0 03-JUL-13 12.40.05.158016 PM -05:00
direct path read                    512-1024                              798        0           0     1              1 03-JUL-13 01.27.50.565441 PM -05:00
direct path read                    256-512                              6775        0           0     5              6 03-JUL-13 02.35.25.224134 PM -05:00
direct path read                    128-256                             53429        3           3    18             24 03-JUL-13 02.35.30.723528 PM -05:00
direct path read                    64-128                             158033        9          12    26             50 03-JUL-13 02.35.31.271218 PM -05:00
direct path read                    32-64                              295652       17          29    25             75 03-JUL-13 02.35.31.168757 PM -05:00
direct path read                    16-32                              371819       21          50    15             90 03-JUL-13 03.17.51.706468 PM -05:00
direct path read                    8-16                               310634       18          68     6             96 03-JUL-13 03.17.36.320652 PM -05:00
direct path read                    4-8                                228440       13          81     2             98 03-JUL-13 03.17.36.327927 PM -05:00
direct path read                    2-4                                153154        9          90     1             99 03-JUL-13 03.17.06.015746 PM -05:00
direct path read                    1-2                                 89236        5          95     0             99 03-JUL-13 03.17.51.710201 PM -05:00
direct path read                    0-1                                 93204        5         100     0             99 03-JUL-13 03.35.50.715609 PM -05:00

Avg wait time ms
----------------
      32.7397445

Download

About these ads

2 Comments »

  1. Please fix download link. Thank you.

    Comment by Oleg — September 6, 2013 @ 2:36 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: