DBA Hub

📋Steps in this guide1/1

Open database link information

set pagesize 200 set lines 200 col db_link for a19 set long 999 SELECT db_link, owner_id, logged_on, heterogeneous, open_cursors, in_transaction, update_sent FROM gv$dblink ORDER BY db_link;

oracle configurationintermediate
by OracleDba
12 views
1

Open database link information

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
set pagesize 200
set lines 200
col db_link for a19
set long 999
SELECT db_link,
owner_id,
logged_on,
heterogeneous,
open_cursors,
in_transaction,
update_sent
FROM gv$dblink
ORDER BY db_link;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!