Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CPU time in v$sesstat

CPU time in v$sesstat

From: mwang <mike_wang_at_intuit.com>
Date: 15 Oct 2001 14:10:41 -0700
Message-ID: <b4530838.0110151310.4c3e8036@posting.google.com>


Could someone tell me why CPU time recorded by oracle (statistic# 12) is 0 for all background processes, while CPU time for the same processes as recorded by O/S is not 0?

select spid, value, c.program
 from v$sesstat a, v$process b, v$session c  where paddr = addr
 and a.sid = c.sid
 and statistic# =12
 and type = 'BACKGROUND';

SPID VALUE PROGRAM

--------- ---------- ------------------------------------------------
417                0 oracle_at_sugar.ma.intuit.com (PMON)
419                0 oracle_at_sugar.ma.intuit.com (DBW0)
421                0 oracle_at_sugar.ma.intuit.com (LGWR)
423                0 oracle_at_sugar.ma.intuit.com (CKPT)
425                0 oracle_at_sugar.ma.intuit.com (SMON)
427                0 oracle_at_sugar.ma.intuit.com (RECO)

6 rows selected.

ps -eo pid,time,comm | grep _$ORACLE_SID |sort

  417        0:00 ora_pmon_srdb1
  419        0:00 ora_dbw0_srdb1
  421        0:02 ora_lgwr_srdb1
  423        0:17 ora_ckpt_srdb1
  425        0:01 ora_smon_srdb1
  427        0:00 ora_reco_srdb1
Received on Mon Oct 15 2001 - 16:10:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US