OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Remote DB Status

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remote DB Status [message #110348]

Sun, 06 March 2005 07:13

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 14:55:45 CDT 2025