First page Back Continue Last page Overview Graphics
V$SQL_PLAN_STATs
Runtime trace-level statistics via dynamic performance view
Query view for stats instead of OS command TKPROF
Bugs fixed in Release 9.2.0.4
Notes:
The Oracle9i V$SQL_PLAN_STATISTICS table provides runtime trace-level statistics – without having to locate the trace file and execute TKPROF.
Bug Report
According to my tests on a Windows 2000 server with release 9.2.0.2, this feature does not work (V$SQL_PLAN_STATISTICS is not populated with the runtime statistics) until Release 9.2.0.4.