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

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: 2005-12-23 19:37:55
Message-id: 43AC4403.10301@centrexcc.com

Boris, Christian,

that is an excellent comment. I recall that when doing tests in a sqlplus session, I need to execute some other sql afterwards - even though the original sql HAS finished - for the statistics to show up (viewing from a second session, else the sql to query v$sql_plan_statistics already IS another sql). I believe sqlplus keeps the cursor of the most recent sql statement open, so it may be that the cursor needs to be closed for the statistics to be "populated". But then these are v$ views, so there is nothing to BE populated.

Christian Antognini wrote:
> 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.
>

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 23 2005 - 19:37:55 CST