Home » RDBMS Server » Performance Tuning » Remote DB Status
icon4.gif  Remote DB Status [message #110348] Sun, 06 March 2005 07:13 Go to next message
fanni
Messages: 96
Registered: March 2004
Member
While using the DB Links, If Remote DB is down applicaton goes halted for about 50-60 seconds.
Can i check the status (whether it is running properly or it is down) of remote DB , before using the DB Link. Embarassed

any idea ???/
Re: Remote DB Status [message #110360 is a reply to message #110348] Sun, 06 March 2005 20:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can just directly run a dummy query against the remote DB as a seperate sql ( if this would apply).
Re: Remote DB Status [message #110412 is a reply to message #110348] Mon, 07 March 2005 06:32 Go to previous message
sridcpp
Messages: 23
Registered: February 2005
Location: India
Junior Member
Check the status using OEM, Database Links option
Previous Topic: Index not used when changing the selected columns
Next Topic: Performance problems
Goto Forum:
  


Current Time: Thu Mar 28 04:03:06 CDT 2024