Re: CPU time in v$sesstat

From: mwang <mike_wang_at_intuit.com>
Date: 18 Oct 2001 08:42:03 -0700
Message-ID: <b4530838.0110180742.24cbc6d5@posting.google.com>

mike_wang_at_intuit.com (mwang) wrote in message news:<b4530838.0110160609.93618d8_at_posting.google.com>...
> "Stephan Bressler" <stephan.bressler_at_pdb.sbs.de> wrote in message news:<9qh367$7lc$1_at_news.mch.sbs.de>...
> > timed_statistics=false?
>
> Good guess, but TIMED_STATISTICS was set to TRUE.

Got answer from Oracle!!!

From: Oracle, Melissa Holman 16-Oct-01 22:34 Subject: Re : CPU time recorded by oracle (statistic# 12) is 0 for all background processes

Mike,

This is intended behavior. Bug 1158628 was filed for this but was closed as 'not a bug'. This was done deliberately as the information (a) would not be used to restrict resource use anyway (ie, via profiles) and (b) it was deemed to not be of use with respect to performance tuning. Also, another reason for not populating these fields for backgrounds is that it is difficult to establish start and end points of sample collection.

Melissa Holman
Oracle Support Received on Thu Oct 18 2001 - 10:42:03 CDT