Hello,

I did history table from v$sqlarea, to follow some performance problems.
However I check some inconsistencies.

The collumns buffer_gets, disk_reads, executions should be always
cumulative, but some times for the same hash_value and address this
values are decreased and some times the column optimizer_mode also change
in the same condition.


This is rigth? why?

TIA

Joao
Oracle LazyDBA home page