<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2995" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>After some cosmetic changes to our OpenCms-based
application user interface, and a few other minor function modifications, its
performance deteriorated dramatically. The reason is a huge increase in the
OpenCms (6.2.3) access to its DB tables, to the point that we had to increase
its number of DB connections in opencms.properties from 25 to 200. I really
can't imagine the reason for such increase.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>An Oracle report that we got shows large number of
selects per second to the CMS_ONLINE_STRUCTURE table, so I guess it would help
to find out what resources OpenCms is accessing.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can OpenCms log details about its DB select's?
I tried using the
log4j.logger.org.opencms.db.oracle.CmsProjectDriver logger, but didn't get
anything useful.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I would appreciate very much your comments about
this situation.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Pere</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>