select
HS_SESSION_ID, -- HS_SESSION_ID NUMBER
AGENT_ID, -- AGENT_ID NUMBER
SID, -- SID NUMBER
DB_LINK, -- DB_LINK VARCHAR2(128)
DB_LINK_OWNER, -- DB_LINK_OWNER NUMBER
STARTTIME -- STARTTIME DATE
from
GV$HS_SESSION
where
INST_ID = USERENV('Instance')