GV$LICENSE
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

home |  up  |  mailbox