CPU Time greater than Startup time

From: Diego Cutrone <diegocutrone_at_yahoo.com.ar>
Date: Wed, 31 Mar 2004 14:34:17 -0800
Message-ID: <000a01c41770$50feac20$a504fea9@DC>

Hi List,

Maybe I'm too tired and I'm doing something wrong here.....I need some more eyes on it

Oracle 7.3.4.2
HPUX 10.20 SQL> select (sysdate - (to_date(a.value,'J') + (b.value/86400)))*24*60*60*100 time_since_startup_cs   2 from v$instance a, v$instance b
  3 where a.key = 'STARTUP TIME - JULIAN' and   4 b.key = 'STARTUP TIME - SECONDS';

 24502700

SQL> select name, value from v$sysstat where name like 'CPU%';

CPU used when call started                                        30712324
CPU used by this session                                          30731923

CPU used when call started is greater than time_since_startup_cs...how is that possible? I'm sure I missed something.

thanks in advance
Diego.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Mar 31 2004 - 11:31:41 CST