[opencms-dev] Oracle - Open Cursors issue

[SIMON DUTIL]

Hi dev,

I had a talk yesterday with the DBA about oracle open cursors problem
during setup process and she gave me few more details about the issue :

Four different sessions are open during the setup process.  Two of them
opening more than a thousand cursors, and the others a little less than
an hundred.  In every case, once the session is switching to inactive,
all of the newly opened cursors are left opened.

After i quit the wizard, the four session state is set to inactive, but
all of the 3000 thousand cursors are still opened.  Then, a fifth
session is opened  ( for the connexion pool i guest... )

This major need for open cursor by opencms is only appearing during the
setup wizard...
On the other hand, OpenCms 5.3.5 is highly unstable when deployed on
our server (oracle db 9i and 10g AS), even if the installation is
successful.

Hope this help,

Simon