Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
From: Ls Cheng <exriscer_at_gmail.com>
Date: Wed, 14 Nov 2012 10:49:32 +0100
Message-ID: <CAJ2-Qb_CV7WExYFH4b-xSwTNP_D2vgtuNG=SY3YG2uaRHWdJTw_at_mail.gmail.com>
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.
Date: Wed, 14 Nov 2012 10:49:32 +0100
Message-ID: <CAJ2-Qb_CV7WExYFH4b-xSwTNP_D2vgtuNG=SY3YG2uaRHWdJTw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 14 2012 - 10:49:32 CET