Re: DB CPU is much lower than CPU Time Reported by TOP SQL consumers
From: Ls Cheng <exriscer_at_gmail.com>
Date: Tue, 13 Nov 2012 16:28:50 +0100
Message-ID: <CAJ2-Qb_i213h+niNJcwMVJJpyvfg-WkyUW-gKN7C1-7mxf2ebA_at_mail.gmail.com>
By the way DB Time is the time spending by the session doing work, running SQL are doing work so if DB CPU is part of DB Time, CPU consumed by the SQL must be part of DB CPU IMHO.
Thanks
Date: Tue, 13 Nov 2012 16:28:50 +0100
Message-ID: <CAJ2-Qb_i213h+niNJcwMVJJpyvfg-WkyUW-gKN7C1-7mxf2ebA_at_mail.gmail.com>
By the way DB Time is the time spending by the session doing work, running SQL are doing work so if DB CPU is part of DB Time, CPU consumed by the SQL must be part of DB CPU IMHO.
Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 13 2012 - 16:28:50 CET