select
  sessions_max,                            -- SESSIONS_MAX NUMBER
  sessions_warning,                        -- SESSIONS_WARNING NUMBER
  sessions_current,                        -- SESSIONS_CURRENT NUMBER
  sessions_highwater,                      -- SESSIONS_HIGHWATER NUMBER
  users_max,                               -- USERS_MAX NUMBER
  cpu_count_current,                       -- CPU_COUNT_CURRENT NUMBER
  cpu_core_count_current,                  -- CPU_CORE_COUNT_CURRENT NUMBER
  cpu_socket_count_current,                -- CPU_SOCKET_COUNT_CURRENT NUMBER
  cpu_count_highwater,                     -- CPU_COUNT_HIGHWATER NUMBER
  cpu_core_count_highwater,                -- CPU_CORE_COUNT_HIGHWATER NUMBER
  cpu_socket_count_highwater               -- CPU_SOCKET_COUNT_HIGHWATER NUMBER
from
  gv$license
where
  inst_id = userenv('Instance')