Hello all
How can I speed up the removal of the big productive client?
I use:
1) No Archive log mode
2) Parralel processing
I reran the removal of 4 times. Total removed about 500 million entires from 1 200 billion
There are very few tables, but I think it is a large tables
Please,see part of the client deletion information.
Current Action:
Copy/Delete Tables
Process
Server
Table
Time
MVKE
15:46:36
00002
CDCLS
16:28:49
00004
BDCP2
16:25:52
00005
MARC
15:48:07
00007
CKMLPR
16:09:21
00008
MSTA
15:46:41
00009
FAGLFLEXA
15:36:21
00010
FAGL_SPLINFO
15:33:26
00011
MOFF
15:46:17
00014
MBEWH
16:30:05
00016
CDHDR
16:28:52
Statistics for this Run
- No. of Tables
65979 of
66248
- Number of Exceptions
3
- Deleted Lines
62747951
Sm66:
SAPLSCCR Direct Read MSTA
SAPLSCCR Direct Read CDHDR
SAPLSCCR Direct Read CKMLPR
SAPLSCCR Direct Read MOFF
SAPLSCCR Direct Read MBEWH
SAPLSCCR Direct Read BDCP2
SAPLSCCR Direct Read MARC
SAPLSCCR Direct Read FAGLFLEXA
SAPLSCCR Direct Read CDCLS
SAPLSCCR Direct Read FAGL_SPLIN
SAPLSCCR Direct Read MVKE
Only direct read, and nothing else.