Open session problem.
I am using 11.1.2.1 Jdeveloper and i have problem with open sessions.
I set in appModule pool, min available size: 0
I set in Db Conexion pool, min available size:0
This are the step i am doing to get the problem:
- I Clic on search button from inputListofValue, until request end i turn off pc wifi.
- I wait 1 minuts and then I turn on pc wifi again.
- Open another window from Internet Explorer and enter to the same web page.
After that i check session and i find two open session:
1 - first session is executing a query ( is the query from list of value)
2 - second session is inactive (session actually i have)
I take a picture in this moment:
http://s2.subirimagenes.com/imagen/previo/thump_7690052open-connections.png
after wait idle timeout from appModule pool the second session die but first session is open.
First session is executing query for eternity!! I hear that ADF kill transaction when transaction time is long but maybe dont work bc i check next day and first session is open.
I dont want to check disconnect db conexion option from appmodule configuration bc that force to kill sessions after each request and that lose temporal table data.
Any help plz??