Skip to Content
Former Member
Jun 29, 2011 at 02:21 PM

Index Storage Quality


Hi All,

We are in phase of setting automatic intimation for any index whose storage quality is below to 50%.

So our plan is that we should get any alert for indexes whose storage quality is below to 50% quaterly. For it we have identified one report RSORAISQN which shows will work for us in such way that we will scedule it and by spool files email we will get out indexes.

But issue is 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 assigned

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>;

permissions but still same situation on output.

Please let us know is there any other way available to check storage quality of all indexes and if report RSORAISQN is only option then how can we execute it.

Shivam Mittal