[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