| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> inside mts?
Some queries stall over a dblink, but only after some "timeout" has
expired. If joe uses the dblink after the period the query stalls
for 20-30 seconds. After joe-user finishes his query every other user
does not stall, including joe in a new joe session.
tkprof shows the 20 seconds spent in:
"virtual circuit status" = "SQL*Net message from dblink"
I assume this is a double reporting since the total time for the query to return is 20 seconds.
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ SQL*Net message to client 3 0.00 0.00 SQL*Net message from client 2 0.00 0.00 db file sequential read 3 0.00 0.00 virtual circuit status 56 15.42 19.38 SQL*Net message to dblink 19 0.00 0.00 SQL*Net message from dblink 19 15.42 19.33 log file sync 2 0.02 0.03
So, if the stall is "from dblink" does that necessarily mean that the problem is on the remote host, or could it still be in the local mts? Is there a way to trace mts? I am suspicious of local mts because the remote dba says he can not duplicate this between a third system and the original remote host. No mts on those two servers.
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Apr 09 2003 - 08:18:40 CDT
 |
 |