Hi my friends and guys ,
Anybody else knows what's the difference about "DB time" between v$sysstat and v$sys_time_model? and what unit with the value (microsecond or millisecond)?
16:21:41 SYS@emcdb> set linesize 80
16:21:44 SYS@emcdb> desc v$sysstat
Name Null? Type
--------------------- -------- ----------------------------
STATISTIC# NUMBER
NAME VARCHAR2(64)
CLASS NUMBER
VALUE NUMBER
STAT_ID NUMBER
CON_ID NUMBER
16:21:49 SYS@emcdb> desc v$sys_time_model
Name Null? Type
--------------------- -------- ----------------------------
STAT_ID NUMBER
STAT_NAME VARCHAR2(64)
VALUE NUMBER
CON_ID NUMBER
16:21:54 SYS@emcdb> col name for a10
16:22:31 SYS@emcdb> col stat_name for a10
16:23:52 SYS@emcdb> col value for 999,999,999,999.99
16:23:57 SYS@emcdb> select stat_name, value from v$sys_time_model where stat_name = 'DB time';
STAT_NAME VALUE
---------- -------------------
DB time 35,869,600,586.00
16:23:58 SYS@emcdb> select name, value from v$sysstat where name = 'DB time';
NAME VALUE
---------- -------------------
DB time 1,162,450,336.00
16:24:04 SYS@emcdb>
Thank you very much!
Best Regards
Quanwen Zhao