select
inst_id, -- INST_ID NUMBER
ksullms, -- SESSIONS_MAX NUMBER
ksullws, -- SESSIONS_WARNING NUMBER
ksullcs, -- SESSIONS_CURRENT NUMBER
ksullhs, -- SESSIONS_HIGHWATER NUMBER
ksullmu, -- USERS_MAX NUMBER
cpu_count, -- CPU_COUNT_CURRENT NUMBER
decode( -- CPU_CORE_COUNT_CURRENT NUMBER
cpu_core_count,0,to_number(null),cpu_core_count),
decode( -- CPU_SOCKET_COUNT_CURRENT NUMBER
cpu_socket_count,0,to_number(null),cpu_socket_count),
cpu_count_hwm, -- CPU_COUNT_HIGHWATER NUMBER
decode( -- CPU_CORE_COUNT_HIGHWATER NUMBER
cpu_core_count_hwm,0,to_number(null),cpu_core_count_hwm),
decode( -- CPU_SOCKET_COUNT_HIGHWATER NUMBER
cpu_socket_count_hwm,0,to_number(null),cpu_socket_count_hwm)
from
x$ksull