DB Time Test Tool

• Answer the question - how can there be extra time? •

Download Now

Use this tool to help understand, analyze and measure DB Time's "gap" time. That is, the difference between DB Time and Oracle foreground process CPU consumption plus the non-idle wait time.

This tool was developed and tested on Oracle 11 and 12. It will not work on Oracle 10g.

To receive updates about the DB Time Test Tool changes, sign-up for the Tools list.

Search Craig's blog for relevant posts at the link above.

An actual example of real output is shown below. Notice it is ready for quick statistical analysis.


SQL> @op_db_time_test.sql
.
OraPub DB Time Test v1a 26-Sep-2014. Enjoy but use at your own risk.
5-Dec-2014 sixcore super light load; dml and lio, 16% io busy, 30% cpu util
.
Starting to collect 11 180 second samples now...
All displayed times are in seconds.
.
..........................................................................
... RAW OUTPUT (keep the output for your records and analysis)
..........................................................................
.
sample#,  db_time_delta_v ,  db_cpu_delta_v,  tot_ni_wait_delta_v, derived_db_time_delta_v, diff_v, diff_pct_v
.
1, 406.643, 394.676, 107.833, 502.509382, -95.867, -23.6
2, 346.393, 332.987, 94.801, 427.78798, -81.395, -23.5
3, 347.293, 333.011, 95.348, 428.3595, -81.067, -23.3
4, 346.143, 333.62, 94.22, 427.840573, -81.698, -23.6
5, 347.059, 333.398, 94.405, 427.80313, -80.745, -23.3
6, 346.285, 333.38, 94.224, 427.604058, -81.319, -23.5
7, 350.313, 339.266, 93.386, 432.652594, -82.339, -23.5
8, 348.611, 337.119, 93.674, 430.793106, -82.182, -23.6
9, 347.923, 335.733, 94.176, 429.908556, -81.985, -23.6
10, 347.899, 335.301, 94.269, 429.569584, -81.671, -23.5
11, 359.939, 348.015, 96.421, 444.436364, -84.498, -23.5
.
The test is complete.
.
PL/SQL procedure successfully completed.
All displayed times are in seconds.
 

Related Videos