I have a problem with implementing a Novell Operation Center 5.0 for
Services Mapping.
Current configuration of Novell Operation Center is:
1. Operations Center Server(OS:SLES 11 SP1);
2. DB Server (OS:SLES 11 SP1; DB: Oracle 11g R2);
3. NOC CMS (OS:SLES 11 SP1);

Problem is in performance degradation of Oracle Database.

If the CMS NOC is included in the custom setting "Show Events Feed", is
performance degradation of Oracle Database. SQL request which results to
it is shown below:


INSERT INTO CFG_ENTRY_IDS(ID)
SELECT DISTINCT(id)
FROM CFG_ENTRY_HISTORY
WHERE (ID,timeEnd) IN
(
SELECT id, MAX( timeEnd )
FROM CFG_ENTRY_HISTORY
START WITH id = 754266790086382056
CONNECT BY PRIOR id = parent_id
GROUP BY ID
)


After you enable "Show Events Feed", in log file formula.trc error:

2012-05-30 15:37:15,193 WARN org.hibernate.util.JDBCExceptionReporter -
SQL Error: 0, SQLState: null
2012-05-30 15:37:15,193 ERROR org.hibernate.util.JDBCExceptionReporter
- An attempt by a client to checkout a Connection has timed out.



As can be disabled for all users custom setting "Show Events Feed" in
CMS NOC?


--
VBondarchuk
------------------------------------------------------------------------
VBondarchuk's Profile: http://forums.novell.com/member.php?userid=119057
View this thread: http://forums.novell.com/showthread.php?t=456366