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 Received on Thu May 02 2002 - 20:42:03 CDT