Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Help: Is there any way we can get all the db_links that are active?
Somebody suggested
select username,
db_link,
logged_on,
heterogeneous,
protocol,
open_cursors,
in_transaction ,
update_sent,
commit_point_strength
from v$dblink,
dba_users
Where owner_id = user_id order by 1,2
But it always returns no rows even though I know there is some open db links
Any suggestions?
Thanks
-- Sent by joebayerii from hotmail part from com This is a spam protected message. Please answer with reference header. Posted via http://www.usenet-replayer.com/cgi/content/newReceived on Thu May 02 2002 - 13:53:24 CDT