on 04-18-2014 7:08 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
If your system is productive it should only have only one client... thus you could just truncate the application tables instead of deleting their content. Truncate command is instantaneous.
Why are you deleting a client from a (copy of a) productive system ?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ouu, truncate?Please,tell me more about this..
Hello
So in you scenario the SQL truncate command can help.
In fact it is a DDL (data defintion language) command, it is just resetting the table, removing all content in one pass and not deleting every row as the delete (DML command) does.
In fact it could be seen as recreating the table as empty... It might be interesting to set the
'reuse storage' clause to keep the space allocated to the table if you are planning to copy some data again to that table.
It should be used with precaution as it is not creating undo/redo info but in your scenario it is not a problem.
Regards
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.