WSG Purge Monitor Log

From: wsgPurgeMornitor@wgwprddbsl001.optus.com.au [mailto:wsgPurgeMornitor@wgwprddbsl001.optus.com.au]
Sent: Tuesday, 5 June 2007 7:36 AM
To: Stephen Cheng; Peter Wrzos; Bradley Miller
Subject: WSG Purge Monitor Log

 

WSG Purge Monitor Log

 

---

Info:

Tue, 05 Jun 2007 04:30:02-> Purge task starting .....

Running in: SAF MODE, ENV: PRD
fixRunCnt: 40000, Applied only in Fixed Run or Safe Mode
clockStop: 07:30,Applied only in Clocked Scheduled Run or Safe Mode
batchCnt: 300 Means for the deletion will commit only every 300 rows
Keep data after date:070307,lastMsgId:070307999999999

->before Purging: Tue, 05 Jun 2007 04:43:27 Caculating EC_JOURNAL row count to be deleted: 28877578
->before Purging: Tue, 05 Jun 2007 04:44:06 Caculating EC_KEYDATA row count to be deleted: 2574086
->before Purging: Tue, 05 Jun 2007 04:49:22 Caculating EC_MESSAGES row count to be deleted: 11004357
->before Purging: Tue, 05 Jun 2007 04:49:30 Caculating WSG_TXN_EVENTS row count to be deleted: 692795
->before Purging: Tue, 05 Jun 2007 04:49:32 Caculating WSG_TXN_MASTER row count to be deleted: 407629
->before Purging: Tue, 05 Jun 2007 04:49:38 Caculating EC_TEMP_MESSAGES row count to be deleted: 732051
->after Purging: Tue, 05 Jun 2007 07:30:03 Caculating EC_JOURNAL row count to be deleted: 25637212
->after Purging: Tue, 05 Jun 2007 07:30:41 Caculating EC_KEYDATA row count to be deleted: 2295929
->after Purging: Tue, 05 Jun 2007 07:35:28 Caculating EC_MESSAGES row count to be deleted: 9777055
->after Purging: Tue, 05 Jun 2007 07:35:36 Caculating WSG_TXN_EVENTS row count to be deleted: 618228
->after Purging: Tue, 05 Jun 2007 07:35:40 Caculating WSG_TXN_MASTER row count to be deleted: 367729
->after Purging: Tue, 05 Jun 2007 07:35:48 Caculating EC_TEMP_MESSAGES row count to be deleted: 663803


Total deleted row count for table: EC_JOURNAL is:3240366
Total deleted row count for table: EC_KEYDATA is:278157
Total deleted row count for table: EC_MESSAGES is:1227302
Total deleted row count for table: WSG_TXN_EVENTS is:74567
Total deleted row count for table: WSG_TXN_MASTER is:39900
Total deleted row count for table: EC_TEMP_MESSAGES is:68248


Total Archive Log Disk Space:34G, Free Disk Space:18G,Disk Used For Purge:1944MB

Tue, 05 Jun 2007 07:35:48 -> Purge task completed