RMAN CPU time accounts also to background time in dba_hist_sys_time_model ?

From: Milen Kulev <makulev_at_gmx.net>
Date: Fri, 23 Jan 2009 13:58:16 +0100
Message-ID: <20090123125816.270720_at_gmx.net>

HallO Listers,
I am trying to generate some report showing how much CPU time is consumed from RMAN.
I have found that normally background precesses (as per dba_hist_sys_time_model view) consume 20-100 seconds (in 30 minutes interval). But when RMAN backup is running the background cpu time is nearly RMAN CPU time + background CPU time (see below). That means that RMAN CPU time is double accounted in dba_hist_sys_time_model view ?! Can someone confirm my observation ?

Here is the output of my script:

                    ELAPSED     DB   RMAN  BGRND
  SNAP        BEGIN    TIME    CPU    CPU    CPU
    ID         TIME   [sec]  [sec]  [sec]  [sec]


------ ------------ ------- ------ ------ ------

  9421 21/01 09:01     1740    446      0      8
  9422 21/01 09:30     1800   1006      0     15
  9423 21/01 10:00     1860     39      0      6
  9424 21/01 10:31     1740   2171      0     79 -> normal CPU consumption
  9425 21/01 11:00     1800   5178      0    219
  9426 21/01 11:30     1800   2978   8326   8408 -> 8408 -8326 = 82 sec 
  9427 21/01 12:00     1800   1588   4893   4915 -> the same 
  9428 21/01 12:30     1860     30    445    459
  9429 21/01 13:01     1740    400      1     17
  9430 21/01 13:30     1800    405      0     12
  9431 21/01 14:00     1860    297      0      6
 

Any help is highly appreciated.

MILEN
--

Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 23 2009 - 06:58:16 CST