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 ???/

Report message to a moderator

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: 10708
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).

Report message to a moderator

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

Report message to a moderator

Previous Topic: Index not used when changing the selected columns
Next Topic: Performance problems
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 02 20:45:44 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.