on 07-02-2010 7:56 AM
Hello,
On my sap PRD system I have the GVD_* tables that grows fast.
Would you know how I could trace what is happening why there are growing and how to stop them growing.
For example:
GVD_LATCHCHILDS
-
Scale: Day | Size (Kbyte) Extents | NextExtSize | |
Date | Total Delta | Total Delta | Total |
-
02.07.2010 | 842,752 | 49,152 | 174 | 6 | 0 |
01.07.2010 | 793,600 | 72,704 | 168 | 9 | 0 |
30.06.2010 | 720,896 | 98,304 | 159 | 12 | 0 |
29.06.2010 | 622,592 | 90,112 | 147 | 11 | 0 |
28.06.2010 | 532,480 | 49,152 | 136 | 6 | 0 |
27.06.2010 | 483,328 | 106,496 | 130 | 13 | 0 |
26.06.2010 | 376,832 | 98,304 | 117 | 12 | 0 |
25.06.2010 | 278,528 | 98,304 | 105 | 12 | 0 |
24.06.2010 | 180,224 | 90,112 | 93 | 11 | 0 |
23.06.2010 | 90,112 | 24,576 | 82 | 3 | 0 |
22.06.2010 | 65,536 | 0 | 79 | 0 | 0 |
21.06.2010 | 65,536 | 0 | 79 | 0 | 0 |
20.06.2010 | 65,536 | 0 | 79 | 0 | 0 |
19.06.2010 | 65,536 | 0 | 79 | 0 | 0 |
Thanks in advance for your help.
Hello,
depending on your SAP release you can delete (or truncate) the content of this table - check sapnote #1080813 for detail.
If you got the oracle knowledge to use AWR and you can deactivate the collection of data into the GVD_* tables - check sapnote #1411834 for detail.
If you still want to keep that history information - you have to live with it.
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.