Re: Elapsed time for Stored Procedure and Time model
- From: Marcus Mönnig <mm@xxxxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2011 10:02:09 +0200
Hi Thierry,
without seeing the complete report, it's hard to say.
One idea would be that the procedure D_FORTIS.PRC_REMONTEE_PM_SUPPORT
executes lots of different SQL statements (not using bind variables,
but dynamic SQL). Each of these statements would not show up in the
SQL sections of the report since the separate execution time is too
low, but the sum of all these SQLs would be very high.
Even with the full AWR report this might not be easy to track with
instance data and you might want to look into a 10046 trace file for a
session calling D_FORTIS.PRC_REMONTEE_PM_SUPPORT.
Cheers,
Marcus
--
//www.freelists.org/webpage/oracle-l
Other related posts:
