Hi Julian,
Yes you are right. At the moment I am thinking to just to use the 'select dummy from dual@dblink' method to check whether it is successfully connected else I will send the email to administrator about the connectivity is fail.

Any other better method ? Thanks

Regards,
ckwan