[opencms-dev] v5.3.5 slower than 5.3.3 [Oracle - Open Cursors issue]

[CLB]

Simon, all,

Nothing related to Oracle or setup, this is just to provide some more
feedback to the core developers working on v6.

We are using v5.3.5, but have also noticed v5.3.5 is slower compared to
v5.3.3. We could observe this behavior on our server running both the
same Tomcat instance against the same MySQL server. 

I'm fully aware 5.3.5 is a dev version, and I believe this feedback can
be useful for v6 to run smoothly in the near future. 

--mariano

PS: Casually, I saw the news about the new OpenCMS book, by Matt
Butcher. Congratulations, this is excellent news for the community.

-----Mensaje original-----
De: opencms-dev-admin at opencms.org [mailto:opencms-dev-admin at opencms.org]
En nombre de SIMON DUTIL
Enviado el: Lunes, 09 de Agosto de 2004 03:24 p.m.
Para: opencms-dev at opencms.org
Asunto: [opencms-dev] Oracle - Open Cursors issue


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






_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit
http://mail.opencms.org/mailman/listinfo/opencms-dev