Name: Database link check
Platform: Oracle
Category: Availability
Description: Checks database links.
Long description: In order to check private database links you have to create a following view ‘create view dbw_link_check as select username from user_users@DB_LINK’ in the database link owner schema, and then grant select privilege to dbwatch user on that view (‘grant select on dbw_link_check to dbwatch’).
Version: 2.5
Default schedule: 15,45 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _priv_read_dba_db_links = ‘1’ ]]]


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment