<!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>Our hosting site claims that there is an
OpenCms DB select that is clogging the Oracle server because it is
executing cotinuously:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>SELECT<BR>CMS_ONLINE_STRUCTURE.STRUCTURE_ID,</DIV>
<DIV>CMS_ONLINE_STRUCTURE.RESOURCE_ID,</DIV>
<DIV>CMS_ONLINE_STRUCTURE.RESOURCE_PATH,</DIV>
<DIV>CMS_ONLINE_STRUCTURE.STRUCTURE_STATE,</DIV>
<DIV>.....................</DIV>
<DIV>CMS_ONLINE_RESOURCES.USER_CREATED,</DIV>
<DIV>CMS_ONLINE_RESOURCES.USER_LASTMODIFIED,</DIV>
<DIV>....................</DIV>
<DIV><FONT face=Arial size=2></FONT>CMS_ONLINE_RESOURCES.SIBLING_COUNT,</DIV>
<DIV>CMS_ONLINE_RESOURCES.PROJECT_LASTMODIFIED <BR><BR>FROM
MS_ONLINE_STRUCTURE,CMS_ONLINE_RESOURCES <BR><BR>WHERE
CMS_ONLINE_STRUCTURE.RESOURCE_PATH=:1
AND<BR>CMS_ONLINE_STRUCTURE.RESOURCE_ID=CMS_ONLINE_RESOURCES.RESOURCE_ID
<BR>ORDER BY CMS_ONLINE_STRUCTURE.STRUCTURE_STATE ASC<BR></DIV>
<DIV><FONT face=Arial size=2>It seems to be something related to administration
resouces listings because it retrieves info like date last modified or user
created, except that nobody is accessing the ONLINE project in the
administration, much less with such frequency (they claim hundreds of
times).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Can anyone suggest what function is issuing that
statement, and a reason for it being invoked in what seems
a loop?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thank for any hint,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Pere</FONT></DIV></BODY></HTML>