user11977510 wrote:Provide us with Proof about what you saying ?
Hi guys, I have so problem, client program which run heavy queries (executes long time 30-45 min) after some time disappeares from sessions in the Oracle database, it seems that Oracle has killed session but no any mesages in alert log and program still running. I run so query in Toad as example, session has disappeared but Toad shows that it query is still running. Database version 184.108.40.206, Linux 64 platform. Maybe somebody faced with so problem.
user11977510 wrote:I suspect that a Firewall or network timeout is happening
Client doesn't receive any messages, it's running as nothing happened with session, but I think that Oracle process PMON clears deadly sessions, so if session is dead something happened with network it break connection, but why client programm doesn't stop?
Edited by: user11977510 on 28.12.2012 6:27