Timeline for Unclear oracle problem with getting response of query
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 1, 2014 at 17:59 | comment | added | Justin Cave |
How many rows does the query return? In PL/SQL Developer, are you measuring the time required to fetch the first row? Or to fetch the last row? Is your application logging something when the first row is returned? Or when the last row is returned? Are you certain that the query you are running in PL/SQL Developer has the same sql_id, that it uses bind variables in the same way that your application does, etc.?
|
|
| Oct 3, 2013 at 15:21 | answer | added | kubanczyk | timeline score: 1 | |
| Oct 2, 2013 at 12:20 | answer | added | mustaccio | timeline score: 0 | |
| Oct 2, 2013 at 11:28 | comment | added | Colin 't Hart | tnsnames settings on the client are different? Different network/route from client to server compared to from the appserver to the server? | |
| Oct 2, 2013 at 10:54 | comment | added | Alexander.Iljushkin | @Colin'tHart what's the difference could be between server request and pl/sql developer request (Also, Toad shows prefect timing too) | |
| Oct 2, 2013 at 10:52 | comment | added | Alexander.Iljushkin | @Colin'tHart, yes, the server uses dbpool reference (the only reference of dbpool) and I tried to set up different timeout parameters, but still no changes... ( how can I detect problems ? is there any tools or methods ? | |
| Oct 2, 2013 at 9:07 | comment | added | Colin 't Hart | 300 seconds sound like a TCP timeout, yet you say the query is returning results. I wonder if the app server is trying to connect via multiple addresses and only manages to connect after the first times out? | |
| Oct 2, 2013 at 8:38 | history | edited | user1822 | CC BY-SA 3.0 |
added 48 characters in body
|
| Oct 2, 2013 at 8:26 | review | First posts | |||
| Oct 2, 2013 at 9:37 | |||||
| Oct 2, 2013 at 8:10 | history | asked | Alexander.Iljushkin | CC BY-SA 3.0 |