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: @OracleSK
fmhabash@xxxxxxxxx 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