This discussion is archived
6 Replies Latest reply: Dec 4, 2012 10:39 AM by EdStevens RSS

Primitive Way

846231 Newbie
Currently Being Moderated
Hi All,

Primitive way sometimes is the fastest way. :)

I have a one critical remote PROD database that I want to check every 10 mins for its connectivity. If connection fails an email & SMS is sent to me.
My question is what is the best way to check if the remote database is up and running?

Can I use sqlplus system/manager@PROD? But sometimes this took so long and hanging. I want the fastest response time?


Thanks a lot,
Kinz

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points