Finding open database links
Hello,
I need to find all sessions with open database links. The closest thing I found via google is:
select
username,osuser,status,sid,serial#,machine,process,terminal,program, saddr
from v$session
where saddr in ( select k2gtdses from sys.x$k2gte );
But this doesn't show all sessions, just my various ones.
Thanks
Scott
I need to find all sessions with open database links. The closest thing I found via google is:
select
username,osuser,status,sid,serial#,machine,process,terminal,program, saddr
from v$session
where saddr in ( select k2gtdses from sys.x$k2gte );
But this doesn't show all sessions, just my various ones.
Thanks
Scott
0