Originally posted by ckwan
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
I can't think of anything smarter than that :-)

Have a look at that about the dual table:

http://www.optimaldba.com/internals/oraint_dual.html