Re: Elapsed time for Stored Procedure and Time model
From: Marcus Mönnig <mm_at_marcusmoennig.de>
Date: Thu, 29 Sep 2011 10:02:09 +0200
Message-ID: <CAFuw4vkmeJiLUUFFVVT-8EKJ75VP9UxQ_mcUNqg4bqRCvszvbg_at_mail.gmail.com>
Hi Thierry,
Date: Thu, 29 Sep 2011 10:02:09 +0200
Message-ID: <CAFuw4vkmeJiLUUFFVVT-8EKJ75VP9UxQ_mcUNqg4bqRCvszvbg_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 29 2011 - 03:02:09 CDT