Timeline for Queries hang when accessing Oracle via ODBC and Python
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 12, 2015 at 15:25 | comment | added | paulmorriss | That didn't work. Thanks for the suggestion though. | |
| Mar 9, 2015 at 14:20 | comment | added | ibre5041 | possible duplicate of dba.stackexchange.com/questions/59200/…. Also some SSL VPNs do not like TCP packets having OOB bit set. These get either merged into TCP stream or discarded. You can also use DISABLE_OOB. | |
| Feb 6, 2015 at 2:44 | answer | added | Eilert Hjelmeseth | timeline score: 1 | |
| Nov 14, 2013 at 10:21 | answer | added | paulmorriss | timeline score: 0 | |
| Nov 11, 2013 at 20:23 | comment | added | user953 | is the explain with the extra column different than without the extra column? | |
| Nov 11, 2013 at 17:25 | history | edited | paulmorriss | CC BY-SA 3.0 |
Added further information gathered during debugging
|
| Nov 8, 2013 at 13:46 | comment | added | paulmorriss | @ik_zelf The data in the extra column is text. I don't know the answers to the other two questions, so I'll contact the DBAs. | |
| Nov 8, 2013 at 13:16 | comment | added | user953 | what kind of data is in the 'extra' column? Can you use explain plan to find how the 'extra' column is accessed? Is the join using an index? | |
| Nov 8, 2013 at 11:48 | comment | added | Philᵀᴹ |
Sounds like some kind of networking or firewall issue. You probably need to get your network admin to help diagnose it. Listener tracing server-side may also help, along with netstat etc
|
|
| Nov 8, 2013 at 10:31 | history | asked | paulmorriss | CC BY-SA 3.0 |