cancel
Showing results for 
Search instead for 
Did you mean: 

GVD_LATCHCHILDS

benoit-schmid
Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

stefan_koehler
Active Contributor
0 Kudos

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

benoit-schmid
Contributor
0 Kudos

Hello,

>

> If you still want to keep that history information - you have to live with it.

> Stefan

But do you know how many days of history it keeps.

As you can see it can grow 100 MB per day.

Thanks in advance for your answer.

benoit-schmid
Contributor
0 Kudos

Hello,

As I run Oracle 10, I have disabled RSOTAHCL in TCOLL table.

Regards,

Former Member
0 Kudos

Hi

The following thread will be of help to you.

Regards

Shan