X

News, tips, partners, and perspectives for the Oracle Solaris operating system

Oracle Database 12c and Oracle Solaris 11 DTrace

Guest Author
As you may have heard, Oracle Database 12c is now available for Oracle
Solaris and Oracle Linux. Among other things, that means we now have
the opportunity to share some of the cool things the Oracle Database and
Oracle Solaris engineering teams have been doing together.

And here's a good one: In this screencast, Jon Haslam describes how on Oracle Solaris 11, DTrace is now integrated into Oracle Database V$ views to provide a top-to-bottom picture of a database
transaction I/O -- from storage devices, through the Oracle Solaris
kernel, up to Oracle Database 12c itself:

With this end-to-end
view, you can easily identify I/O outliers -- transactions that are
taking an unusually long time to complete -- and use this comprehensive
data to identify and mitigate storage system problems that were
previously extremely hard to debug.

This is a great demonstration of the power of DTrace, which is just about to celebrate its 10th anniversary in the wild. The screencast has some additional examples of DTrace's power on its own, as well as diving into the DTrace/Oracle Database 12c synergy.

There's more, of course.  Over on the OTN Garage blog, Rick Ramsey has put together a nice compendium of ways the OS makes the database scream, and Ginny Henningsen's written an article on the same topic.  And, we've also got an OTN page that digs further into Oracle Database / Oracle Solaris optimizations.

Join the discussion

Comments ( 4 )
  • guest Monday, July 1, 2013

    You linked the V$% Views to Oracle8 documentation? Old stuff...


  • Larry Monday, July 1, 2013

    Yikes -- it links to something a little more current now. Thanks!


  • Martin Wednesday, July 10, 2013

    Hello.

    Is there improved observability of database (OracleDB12c) from operating system (OracleSolaris11) (eg. reverse observability to V$*) ?

    Are there compiled/enabled SDT DTrace probes in database (like in MySQL, PostgreSQL...) ?

    Thanks, Martin


  • guest Thursday, June 5, 2014
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.