What I'm trying to pin down is how accurate the execution time displayed in TOAD is. For some complex queries, the time displayed may be 1 second. If I trace the query using TKPROF it reports about 4 ...
This trace has been around for quite a while. I’m not sure when it first showed up but easily back to Oracle8i.
This is the Cost-based Optimizer trace. This trace really tells you ‘why did the CBO pr...