Thursday Jun 27, 2013

Oracle Database 12c and Oracle Solaris 11 DTrace

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.

About

The #1 enterprise OS
for SPARC and x86 systems.
Connect with Oracle Solaris:


Search

Categories
Archives
« June 2013 »
SunMonTueWedThuFriSat
      
1
2
3
5
6
8
9
10
11
12
14
15
16
17
18
19
20
22
23
24
25
26
28
29
30
      
Today