Dtrace probes in Oracle 12c… v$kernel_io_outlier is populated by dtrace!!

Oracle 12c certainly has some great features, but for the performance guy like myself, performance monitoring features are particularly interesting.  There are three new v$ tables that track anomalies in the IO path.  The idea is to provide more information about really poorly performing IO that lasts more than 500ms.

  • V$IO_OUTLIER : tracks the attributies of an IO.  The size, latency as well as ASM information is recorded.
  • V$LGWRIO_OUTLIER : tracks information specifically on Log writer IO.

These two tables are going to be useful to monitor when performance issues occur.  I can already see the SQL scripts to monitor this activity starting to pile up.  But, there is one little extra table that dives even further into the IO stack using Dtrace.

  • “V$KERNEL_IO_OUTLIER” : This table dives into the KERNEL to provide information about Kernel IO.  This table uses my old friend Dtrace to provide information about where the waits are occurring when Kernel IO is in-play.  This shows the time for every step involved in the setup and teardown Kernel IO.   This information allows us to more easily debug anomalies in the IO stack.

Back in 2009 when Oracle was buying Sun I posted “Oracle buys Sun! Dtrace probes for Oracle?” and lamented on how cool that would be… It is good to know that someone was listening :)

About these ads

8 Responses to “Dtrace probes in Oracle 12c… v$kernel_io_outlier is populated by dtrace!!”


  1. 1 Stefan Koehler July 10, 2013 at 11:47 pm

    Hi Glenn,
    have you ever get the view v$kernel_io_outliers working and populating values? I have tried with several configurations and it never populated any values. I have described the issues in the comment section on Jonathan’s blog.

    http://jonathanlewis.wordpress.com/2013/07/02/12c-io-debug/#comment

    It would be great, if you maybe have a solution or an idea why it is not working on Solaris 11.1

    Thanks.

    Regards
    Stefan

    • 2 glennfawcett July 26, 2013 at 8:20 am

      I don’t have any details about the issue you are experiencing. I was just investigating 12c features when I ran across this tidbit.


  1. 1 12c I/O debug | Oracle Scratchpad Trackback on July 2, 2013 at 10:06 am
  2. 2 VMCD.ORG » Blog Archive » [12c new feature] slow IO tracing by views Trackback on July 3, 2013 at 12:52 am
  3. 3 yhddba.com » [12c new feature] slow IO tracing by views Trackback on July 3, 2013 at 1:00 am
  4. 4 [12c new feature] slow IO tracing by views | yihaodian_dba.com Trackback on July 3, 2013 at 1:06 am
  5. 5 [12c new feature] slow IO tracing by views | louis liu 的镜像blog Trackback on July 3, 2013 at 8:11 am
  6. 6 V$KERNEL_IO_OUTLIER | Latch, mutex and beyond Trackback on September 20, 2013 at 1:11 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 340 other followers

%d bloggers like this: