cancel
Showing results for 
Search instead for 
Did you mean: 

DVM - reorg and compression output analysis

bglobee
Active Participant
0 Kudos
247

Dear Community,

I am currently executing the analysis in DVM for table and index compression/reorg saving potential.

I get the results with 100% saving potential on index compression. SAP says that Oracle uses CBO to calculate these values?

any idea what index compression type is considered to achieve these compression potential results?

Thanks

Balaji

Accepted Solutions (0)

Answers (1)

Answers (1)

VigneshPrabhu99
Contributor
0 Kudos

Hello balaji.srinivassingh

It should be CRA (Compression and Reorganization Analysis) as per User Guide (refer page 50).

Please check below links for more information

Reorganization and Compression - Incl. HANA Sizing | SAP Help Portal


Thanks,

Vignesh

dvm-cra.jpg

bglobee
Active Participant
0 Kudos

my question is about the logic followed by CRA itself. it shows 100% saving potential for few tables which is just unreal.

VigneshPrabhu99
Contributor
0 Kudos

Debug program AGS_DVM_CRA_ANALYSIS_START if you want to analyse in depth.

bglobee
Active Participant
0 Kudos

does not help. the logic lies in ora script that is called within. i will check with SAP support