Home » SQL & PL/SQL » SQL & PL/SQL » Hanging query over DB link
 Hanging query over DB link [message #176402] |
Thu, 08 June 2006 03:51  |
dawie
Messages: 2
Registered: June 2006
Location: South Africa
|
Junior Member |
|
|
I am having problems in a a .NET application which runs insert statements over a Oracle database link. It would work well sometimes for days and suddenly it will execute a similar insert statement which simply does not return. The entire configuration is as follows.
.NET 1.1 app using OleDB connects to a local instance of an Oracle 8.1.7 DB on which the database link is created. This part of the application I have control over.
The link connects to another company's Oracle gateway which in turn forwards the data to a DB2 database.
Here is a typical example of the insert statement:
BEGIN rollback; INSERT INTO ACS.V0Login@saadb2.us.oracle.com (PCOUNT,FLIGHT_IND,HOME_AIRPORT,REGISTRATION,AIRCRAFT_TYPE,OPERATOR,FLIGHT_PREFIX,FLIGHT_SUFFIX,TYPE,SCHED_DATE,SCHED_TIME,EST_DATE,E ST_TIME,ACT_DATE,ACT_TIME,CHOCKS_DATE,CHOCKS_TIME,BAY,CAROUSEL_FROM,CAROUSEL_TO,COUNTER_FROM,COUNTER_TO,GATE_FROM,GATE_TO,TERMINAL,PU SHDATE1,PUSHTIME1,PUSHBAY1,PUSHDATE2,PUSHTIME2,PUSHBAY2,PUSHDATE3,PUSHTIME3,PUSHBAY3,PUSHDATE4,PUSHTIME4,PUSHBAY4,PUSHDATE5,PUSHTIME5 ,PUSHBAY5,REMARK,STATUS_FLAG) VALUES ('1258906','D','JNB',NULL,'342','SA','SA','272','I',to_date('2006/06/07','YYYY/MM/DD'),'19:45',NULL,NULL,NULL,NULL,NULL,NULL,'D37',NU LL,NULL,'1009','1018','27','27','AD',to_date('2006/06/07','YYYY/MM/DD'),'17:20','D37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NU LL,NULL,NULL,NULL,'I'); commit; END;
Any ideas or suggestions on getting this resolved will be appreciated.
Regards
Dawie
|
|
|
|
| Re: Hanging query over DB link [message #176421 is a reply to message #176402] |
Thu, 08 June 2006 04:55  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
Did you check whether there were any locks blocking your action? Maybe a trigger on the insert that would do an update?
Is the dblink up? (Can you reach the other database at the problem-times?)
Queries don't "hang". They are either busy, or waiting for a resource (mostly locked rows) to be released.
|
|
|
|
| Re: Hanging query over DB link [message #176426 is a reply to message #176421] |
Thu, 08 June 2006 05:12 |
dawie
Messages: 2
Registered: June 2006
Location: South Africa
|
Junior Member |
|
|
Thanks for the response Frank
I only have access up to as far as the DB links, the system they connect to belongs to a third party and is out of my reach so I cannot check for locks etc.
The problem often occurs late at night and by the time the log files are read and the problem traced the link is up. Will contact the administrators of the external system and ask them to check for locks.
Regards
Dawie
|
|
|
|
Goto Forum:
Current Time: Sat Dec 27 07:22:03 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
