DBA Data[Home] [Help]

ORACLE_OCM.MGMT_DB_LL_METRICS dependencies on DBA_DB_LINKS

Line 480: SELECT count(*) INTO l_dblink_out FROM DBA_DB_LINKS;

476: INTO l_headroom FROM dual;
477: END IF;
478:
479: -- outgoing DB links
480: SELECT count(*) INTO l_dblink_out FROM DBA_DB_LINKS;
481:
482: -- incoming DB links
483: SELECT count(*) INTO l_dblink_in FROM dba_audit_trail
484: WHERE action_name='LOGON' AND comment_text LIKE '%DBLINK_INFO%' AND timestamp > (sysdate-1) ORDER BY timestamp;