RE: 10053 trace for sql fired from pl/sql (stored code)
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <boris_dali@xxxxxxxx>
- Date: Fri, 23 Dec 2005 17:42:32 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
