1.知道目标端的会话信息,怎么找到对应的源端资料库的会话连接信息?
--目标端
select PROCESS from v$session where username='HR';
--源端
SELECT ADDR FROM V$PROCESS WHERE SPID=5344;
SELECT *FROM V$SESSION WHERE PADDR = '0000000EBBDE78A0';
2.知道源端会话信息,怎么找到目标端的会话连接信息?
--源端查看
select PADDR from v$session where sid=13169;
select SPID from v$process where addr='0000000EBBDE78A0';
--目标端
select *from v$session where process='11586';
标签:--,资料库,dblink,会话,oracle,where,源端,select
From: https://www.cnblogs.com/aq0321/p/17867501.html