Hi Kiran.
As a matter of fact, excessive DML is occurring in the DE dictionary tables below as DE operates.
In other words, 300 JOBs are performed about 40,000 times a day. As a result, millions of DMLs occur in the table below, and as a result, excessive redologs occur, and offline redologs occur too much during oracle hot backup,
and as a result, excessive redologs occur, and offline redologs occur too much during oracle hot backup.
As such, I would like to know if the excessive DML of the DE ditionary table is normal or abnormal.
Deleting the history table was a question in the process of finding a solution to the excessive redo log problem.
UPDATE ESP_RTWOB SET ONHOLD=:1 ,ONQUIESCE=:2 ,COMPLETE=:3 ,COMPPEND=:4 ,FORCED=:5 ,THESTATE=:6 ,CONDITIONS=:7 ,STATUS=:8
,READYTIME=:9 ,STARTTIME=:10 ,ENDTIME=:11 ,USERID=:12 ,READYQUEUED=:13 ,JOBNO=:14 ,JOB_LOG_ID=:15 ,CMPC=:16 ,HOST=:17
WHERE ID = :18
UPDATE ESP_WSS_APPL SET STATUS = :1 , COMPLETE_DATE_TIME = :2 WHERE APPL_ID = :3
UPDATE ESP_JOB_DATA SET STATE = :1 , CMPC = :2 WHERE JOB_ID = :3
UPDATE ESP_WSS_JOB SET STATE_AFM = :1 WHERE JOB_ID = :2
DELETE FROM ESP_MANAGER_INQ
Regards,
WoonGyo Han
Open Network Enterprise Inc
Managing Director, Solution Business Division
Tel: +82-2-2107-3477
Fax: +82-2-2107-3499
Mobile: +82-10-6202-4820
wghan@one.co.kr