RE: 10053 trace for sql fired from pl/sql (stored code)

Boris

>3) Another stupid question, just taking advantage of
>you being here - do you know when EXACTLY
>v$sql_plan_statistics gets populated? Sometimes I get
>a result set back sometime ago, and the plan is
>visible in v$sql_plan, but the stats are still all
>zeros in v$sql_plan_statistics.

One possibility is that the SQL statement is still running. In fact the execution stats \ are available only when the execution is over.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l