Oracle数据库问题整理

使用DBlink查询的SQL

-- 查询dblink 卡住问题
SELECT b.machine, a.*
FROM   v$session_event a, v$session b
WHERE  a.event LIKE '%SQL*Net message to dblink%'
       AND a.sid = b.sid
ORDER  BY time_waited DESC