GV$MTS
select
inst_id,                 -- INST_ID NUMBER
kmmsgcmx,                -- MAXIMUM_CONNECTIONS NUMBER
kmmsgmmx,                -- MAXIMUM_SESSIONS NUMBER
kmmsgsta+kmmsgutr,       -- SERVERS_STARTED NUMBER
kmmsgtrm,                -- SERVERS_TERMINATED NUMBER
kmmsgsmx                 -- SERVERS_HIGHWATER NUMBER
from
x$kmmsg 

home |  up  |  mailbox