This discussion is archived
1 Reply Latest reply: Jul 12, 2012 3:58 AM by 874539 RSS

Index Compression Questions

874539 Newbie
Currently Being Moderated
HI All,

I need some your valuable answer for question as below.. before that I want to say we are using Oracle 11(11.2.0.2) in our SAP landscape.

1.How we can check large index that we can compress?

2.How to check all Index name at once that we need to compress?

3.How much compression degree (examples 1,4,7,8) we can set for index compression, or how we know it?

4.Is there a ways to make a package with the help of we can compress all index ?

Just an examples that actual I am looking for

alter index "SAPSR3"."EBAN~1" rebuild compress 5 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~1" noparallel;
---------------------------------------
alter index "SAPSR3"."EBAN~2" rebuild compress 5 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~2" noparallel;
---------------------------------------
alter index "SAPSR3"."EBAN~3" rebuild compress 4 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~3" noparallel;
---------------------------------------
alter index "SAPSR3"."EBAN~4" rebuild compress 2 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~4" noparallel;
---------------------------------------
alter index "SAPSR3"."EBAN~B" rebuild compress 2 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~B" noparallel;
---------------------------------------
alter index "SAPSR3"."EBAN~SRV" rebuild compress 2 parallel 4 pctfree 1;
alter index "SAPSR3"."EBAN~SRV" noparallel;
---------------------------------------
alter index "SAPSR3"."SOC3~0" rebuild compress 2 parallel 4 pctfree 1;
alter index "SAPSR3"."SOC3~0" noparallel;
---------------------------------------

Thanks
RR

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points