RE: DB CPU is much lower than CPU Time Reported by TOP SQL consumers

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 13 Nov 2012 21:34:13 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90BA5D9_at_exmbx06.thus.corp>


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--
http://www.freelists.org/webpage/oracle-l Received on Tue Nov 13 2012 - 22:34:13 CET

Original text of this message