Hi,

We're having an issue where our 2 ZCM servers are no longer responding to user logins, I have to manually stop & restart the Zenserver / Zenloader services as an interim. Our DB admins told us that the Zen database is causing 100% disk I/O and the gave me a trace to post.

ZCM 10.1.2 on Win2003, Oracle 10g backend

************************************************** ******************************

UPDATE NC_COMPONENT SET ISDELETED = NULL
WHERE
WORKSTATIONOID IN (SELECT WORKSTATIONOID FROM NC_WORKSTATION WHERE
ZENWORKSAGENTID = :B1 )


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 101 0.00 0.00 0 0 2 0
Execute 101 134.87 461.24 10869 4405258 42588 41644
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 202 134.87 461.24 10869 4405258 42590 41644

Misses in library cache during parse: 4
Misses in library cache during execute: 4
Optimizer mode: ALL_ROWS
Parsing user id: 59 (recursive depth: 1)

Rows Row Source Operation
------- ---------------------------------------------------
0 UPDATE NC_COMPONENT (cr=44024 pr=117 pw=0 time=5745921 us)
459 HASH JOIN (cr=44024 pr=117 pw=0 time=2991762 us)
1 TABLE ACCESS FULL NC_WORKSTATION (cr=249 pr=0 pw=0 time=1129 us)
1663504 TABLE ACCESS FULL NC_COMPONENT (cr=43775 pr=117 pw=0 time=3327074 us)


Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
read by other session 1516881 0.12 327.40
latch: cache buffers chains 76 0.00 0.00
db file scattered read 2182 0.03 1.62
db file sequential read 1933 0.02 1.62
latch: shared pool 1 0.00 0.00
************************************************** ******************************

Our DB admin has suggested they might be able to build an index for the NC_COMPONENT table, but they think it's a bug in Zenworks...

Does anyone have any suggestions ? I've disabled Inventory Scanning in the ZCC for now...

The problem started last week after doing some 'house cleaning' in deleting workstation objects that are no longer active (if LastAccessDate is before 2010.12.31 then delete ws object)

Any info would be appreciated. Thanks.
Yves