DTrace is a dynamic analysis tool for Sun Microsystems operating systems. It was first introduced in the Solaris 10 operating system, and can be used ONLY on Sun platforms from Solaris 10 onwards.
Spotlight and DTrace
Spotlight on Oracle uses DTrace to capture details of the interaction between Oracle and the operating system.
When Oracle sessions use CPU time, most of that elapsed time is spent executing Oracle code. However, Oracle sometimes uses system calls to perform functions such as to:
Spotlight uses DTrace to investigate these system calls to calculate where that elapsed time is being spent.
To install and configure DTrace scripts
To use DTrace within Spotlight, you need to install and configure a number of DTrace scripts on the server. Once installed, use the DTrace drilldown to view the DTrace analysis. Spotlight on Oracle Drilldowns
Provide DTrace authority. Add this line to /etc/user_attr:
For more information on DTrace and its uses: