Analysing Database Time with Active Session History for Statements with Online Optimizer Statistics Gathering Operations

(David Kurtz) I have been looking into the performance of online statistics collection. This feature was introduced in 12c. When statistics are collected online there is an extra OPTIMIZER STATISTICS GATHERING operation in the execution plan.

Register to Read