Description of the illustration awr2_results_general.gif

This screenshot shows a table in the General tab of the Compare Periods: Results page.

The table has the following columns: Name, First Period Metric Ratio (shown as a bar chart), Second Period Metric Ratio (shown as a bar chart), First Period Value, Second Period Value, First Period Rate Per Second, Second Period Rate Per Second.

The table has 18 rows. The values in the rows are the following:

Row 1: DB cpu (seconds), null, null, 0, 0, 0, 0.

Row 2: DB time (seconds), (a bar about 43% of the column width), null, 7,341.60, 60.83, 4.06, .10.

Row 3: db block changes, (a bar about 15% of the column width), null, 68,185, 6,558, 37.69, 10.91.

Row 4: execute count, (a bar about 15% of the column width), null, 42,907, 1,941, 23.72, 3.23.

Rows for the following metrics showed all 0s: global cache cr block receive time (seconds), global cache cr blocks received, global cache current block receive time (seconds), global cache current blocks received, global cache get time (seconds), global cache gets.

Row 11: opened cursors cumulative, (a bar about 28% of the column width), null, 41,062.00, 1,157.00, 22.70, 1.93.

Row 12: parse count (total), (a bar about 15% of the column width), null, 4,053, 402, 2.24, .67.

Row 13: parse time cpu (seconds), (a bar about 26% of the column width), null, .89, .03, 0, 0.

Row 14: parse time elapsed (seconds), (a bar about 44% of the column width), null, 7.71, .05, 0, 0.

Row 15: physical reads, (a bar 100% of the column width), null, 2,478,815, 85, 1,370, .14.

Row 16: physical writes, (a bar about 23% of the column width), null, 13,086, 681, 7.23, 1.13.

Row 17: redo size (KB), (a bar less than 1% of the column width), null, 7,050.67, 2,198.98, 3.9, 3.66.

Row 18: session cursor cache hits, null, -27,137, 1,213, -15, 2.02.

End of description.