V$SHARED_SERVER_MONITOR definition in Oracle Database 11.2
V$SHARED_SERVER_MONITOR

select
  MAXIMUM_CONNECTIONS,                     -- MAXIMUM_CONNECTIONS NUMBER
  MAXIMUM_SESSIONS,                        -- MAXIMUM_SESSIONS NUMBER
  SERVERS_STARTED,                         -- SERVERS_STARTED NUMBER
  SERVERS_TERMINATED,                      -- SERVERS_TERMINATED NUMBER
  SERVERS_HIGHWATER                        -- SERVERS_HIGHWATER NUMBER
from
  GV$SHARED_SERVER_MONITOR
where
  inst_id = USERENV('Instance')

home |  up