Good day dear,
I'm having serious issues with using the Oracle database and losing the session. The scenario is as follows: thousands of queries, some crash and when we will see if it is still running, they are no longer in the bank. This happens both in SQL Developer and in the Java application itself. This error seems to happen within 1% of several that run. One thing I noticed is that the larger the volume of data being processed in the query, the more often the error happens. What's more interesting is that both SQL Developer and the application wait for a response from the database, even without a session in the database. If I take this query and try to run again, it runs normally.
These queries run 7 in parallel, returning from seconds to few minutes. If you're already running for more than 30 minutes, you're sure to have missed the session.
Sorry if the question was left blank, but I did not find any standards for you to express here. I would like to know the possible causes to help with this investigation.