Contents Lab128 - Tools for Advanced Oracler Tuning and Monitoring. Reference Guide.

SQL Statement Details

There are two tabbed pages in the SQL Statement Details window:

The "Delta" page shows SQL statistics delta between two snapshots defined by the beginning and end of a selected time period. Even though it has a different look, conceptually this page is very similar to SQL Explorer. The only difference is that the scope of data in this window is limited to one SQL statement. It is advisable to get familiar with the concept and description of SQL Explorer, if you have not yet done so. When you need to focus on a particular SQL statement, this window provides all available data in one place. This window can only be called from other windows through a SQL ID link.

The "Cumulative" page shows cumulative counters from v$sql view. This page is provided as a convenience; it can be used to look at SQL attributes not tracked by Lab128.