on 06-29-2011 3:21 PM
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
Hi Shivam,
You can find the 3 different method to see index storage quality in the SAP Note 771929 - FAQ: Index fragmentation
Additionally, check the note 712098 - RSORAISQ: Index Storage Quality Management, in order to fix authorization problem.
In order to generate the list, you should analyze it first. Then you will be able to see the result.
Best regards,
Orkun Gedik
Edited by: Orkun Gedik on Jun 29, 2011 6:42 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Shivam,
first of all, why do you care about the Index Storage Quality?
If you want to reclaim wasted space, an index rebuild might make sense. (But fragmentation will come back, no doubt about that.)
If you want to improve the performance, then an index rebuild will very rarely make sense.
Read this presentation, it is very good and demystifies the Index Storage Quality:
http://richardfoote.files.wordpress.com/2007/12/index-internals-rebuilding-the-truth.pdf
Summary: Don't worry about Index Storage Qualtiy, be happy!
Regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.