Detailed Description and Symptoms
On the Database tables get locked, Automic System get stopped, automatic traces?
In the WP traces look for " Segment is already being shrunk?"
in detail it looks like:
25 - 20110908/141910.285 - U0011889 DB table 'MQPWP' is going to be reorganized.
18 - 20110908/141910.289 - U0029108 SQL_ERROR Database handles DB-HENV: e820340 DB-HDBC: e82b668
18 - 20110908/141910.289 - U0003591 DB error info: Opc: 'OCIStmtExecute' Return code: 'ERROR'
18 - 20110908/141910.289 - U0003592 Status: '' Native error: '10634' Msg: 'ORA-10634: Segment is already being shrunk
18 - Fehler: ORA-06512: at "UC4.UC_REORG", line 1
since Operations Manager V8 SP2 the MQ tables get checked and shrunk by the server every 30 min. The process is named: DB table 'MQPWP' is going to be reorganized. this has nothing to do with the DB reorg !
You can turn this off in:
MQ_CHECK_TIME set the value to 0?