First page Back Continue Last page Overview Graphics

V$SQL_PLAN_STATISTICS…

Notes:

When SQL_TRACE is enabled the V$SQL_PLAN_STATISTICS view is populated with runtime statistics. The statistics are cumulative, i.e. as a query (cursor) is executed multiple times, the statistics are added to. Metalink Note 223724.1 describes the V$SQL_PLAN_STATISTICS view this way – "provides…information for each cached cursor which includes the execution statistics of each operation in the execution plan."
Essentially, this is a way of tracing the query (or application) without finding the trace file in the USER_DUMP_DEST directory and executing TKPROF to format the trace file.