How to rebuilt the mass indexs with the RSORAISQN

[Former Member]

Hi All,

How to work with the report rsoraisqn....

we are not understanding with what options we should execute the report as for all selection cretaria we do not get any output.

We also checked note 970538 - Collective note RSORAISQN and get need to run the following

grant UNLIMITED TABLESPACE to <dbuser>;

grant CREATE TABLE to <dbuser>;

grant ALTER TABLESPACE to <dbuser>;

grant SELECT ON DBA_INDEXES to <dbuser>;

grant SELECT ON DBA_TABLES to <dbuser>;

grant SELECT ON DBA_SEGMENTS to <dbuser>;

But Still in confusion that "what will be the <dbuser> here.....

"Before granting the privileges select the current privileges for the dbuser from dba_sys_privs and dba_tab_privs and keep them as a backup"...plz suggest on this also..

please suggest me how to work with this report.........

Best Regards,

Rableen Khurana..

[Former Member]

This message was moderated.

[Former Member]

Hello Rabeleen,

RSORAISQN - Analyzing Index quality and rebuild

Goto se38 and enter the report RSORAISQN and execute...

1). You need to select the Index - example REBUILD_IDX_ARFC

2). Select Radio Button - > Start WorkingSet and Coalesce and click execute

Above will show you the report what is the performance % of the index.

2). if you want to rebuild the Index

1). select the Respective Index - example - REBUILD_IDX_ARFC

2). Select Radio Button - > Start WorkingSet and Rebuild Index --> Uncheck ANALYZE Radio button and click execute

Above will Rebuild the Index on the tables...

REBUILD_IDX_ARFC - is for Analyzing quality and Rebuilding Index on RFC tables.

Also check the note 712098 - RSORAISQ: Index Storage Quality Management, in order to fix authorization problem.

http://www.se80.co.uk/sapreports/r/rsor/rsoraisqn.htm

http://sapnwnewbie.blogspot.com/2011/12/rebuilding-sap-indexes.html

Thanks,

Arjun