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

From: Ls Cheng <exriscer@xxxxxxxxx>
To: jonathan@xxxxxxxxxxxxxxxxxx
Date: Wed, 14 Nov 2012 10:49:32 +0100

Hi
I guess this isnt double counting because the top 1 SQL is a pl/sql package
running from JDBC Thin Client, I have the source code and some sql
stataments are from this package but other top SQL statements are not
called from this package, also the module for other top SQL statements are
from C programs.

Adding up the top sql statements CPU usage not from the package is much
higher than DB CPU.

TIA


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

Follow-Ups:
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Jonathan Lewis

References:
- DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Ls Cheng
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: mohamed houri
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Ls Cheng
- AW: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Petr Novak
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Ls Cheng
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: mohamed houri
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Ls Cheng
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Marcus Mönnig
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Ls Cheng
- Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Karl Arao
- RE: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
  - From: Jonathan Lewis

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

Other related posts: