DBA Data[Home] [Help]

VIEW: SYS.DBA_CPU_USAGE_STATISTICS

Source

View Text - Preformatted

select cu.dbid, cu.version, timestamp,
        cpu_count, cpu_core_count, cpu_socket_count
 from wri$_dbu_cpu_usage cu, wri$_dbu_cpu_usage_sample cus
 where cu.dbid    = cus.dbid
   and cu.version = cus.version
View Text - HTML Formatted

SELECT CU.DBID
, CU.VERSION
, TIMESTAMP
, CPU_COUNT
, CPU_CORE_COUNT
, CPU_SOCKET_COUNT
FROM WRI$_DBU_CPU_USAGE CU
, WRI$_DBU_CPU_USAGE_SAMPLE CUS
WHERE CU.DBID = CUS.DBID
AND CU.VERSION = CUS.VERSION