Re: PLSQL Call Stats in AWR Reports: Am I double-counting?

From: Stefan Koehler <contact_at_soocs.de>
Date: Wed, 20 Apr 2016 20:32:38 +0200 (CEST)
Message-ID: <632971614.761955.1461177158259.JavaMail.open-xchange_at_app04.ox.hosteurope.de>

Hello,
the Top SQL by CPU section is recursive. It means that your PL/SQL package call includes the CPU time of the SELECT statement.

By the way Oracle itself writes a note about it at every section header: "Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code".  

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK  

> fmhabash_at_gmail.com hat am 19. April 2016 um 19:33 geschrieben:
>
> On 11204 RDBMS, I’m examining top sql by cpu section and I see 2 entries, one for a PLSQL package call and the a second for a select statement.
> When I checked v$SQL, I see the select statement is having a program_id that belongs to the same package. The package call shows 20% of %total and
> the ‘select’ has 10 %total.
>
> If the source of these 2 calls is shutdown, am I saving 20 or 30% of CPU time?
>
> ----------------------------------------
> Thanks

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

Received on Wed Apr 20 2016 - 20:32:38 CEST