10 Apr
The Read Consistency Trap in Sql Tracing
There are some important things to consider when interpreting sql trace files. One of the most important ones is the read consistency trap as it is called in the documentation.
If you see different number of block reads with the same data at different times when you trace a sql statement, this can be one reason. A test case showing what this means follows:
SQL> create table t as select * from