PLSQL Call Stats in AWR Reports: Am I double-counting?
From: <fmhabash_at_gmail.com>
Date: Tue, 19 Apr 2016 13:33:22 -0400
Message-ID: <57166be3.a24f320a.8e45d.63c1_at_mx.google.com>
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.
Thanks
Date: Tue, 19 Apr 2016 13:33:22 -0400
Message-ID: <57166be3.a24f320a.8e45d.63c1_at_mx.google.com>
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 Tue Apr 19 2016 - 19:33:22 CEST