GV$ACTIVE_SERVICES

select
inst_id,                 -- INST_ID NUMBER
kswsastabsi,             -- SERVICE_ID NUMBER
kswsastabnm,             -- NAME VARCHAR2(64)
kswsastabnmh,            -- NAME_HASH NUMBER
kswsastabnn,             -- NETWORK_NAME VARCHAR2(512)
kswsastabcd,             -- CREATION_DATE DATE
kswsastabcdh             -- CREATION_DATE_HASH NUMBER
from
x$kswsastab 
where
kswsastabact = 1
home |  up  |  mailbox