RE: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 13 Nov 2012 21:34:13 +0000
Double counting for SQL calling (indirectly) SQL is the simplest explanation.
Unless the calls to dbms_application_info to set the module information have
been done correctly (with stack pushing and popping) it's possible that two
statements with different reported modules in statspack were USUALLY run from
the same module, and only optimized in different modules.
Checking for clues - how many of the statements are in upper case, with minimal
white space, and bind variables of the form ":B{number}" ?
Regards
Jonathan Lewis--
//www.freelists.org/webpage/oracle-l
Other related posts:
