RSORAISQ: Index Storage Quality Management for Oracle



Share this article :

You can use report RSORAISQ to examine the indexes in the system and save a history of the analyses performed. You can use the data saved in this way to develop a strategy for your system and develop a plan as to when certain indexes should be rebuilt (either on a regular basis or after certain administrative tasks have been performed).

Possible reasons for the rebuild

• You want to release the unused space again.
• Accesses to the object are slow or consume an unnecessary amount of database resources (high number of get buffers).

Report RSORAISQ provides the following functions:

• Analysis of the memory quality of one or more indexes
• Display of indexes that have already been analyzed
• Rebuild of one or more indexes

Reference:
• SAP Note 712098.
• RSORAISQ is now replaced by RSORAISQN.

Related posts

BR0973W: Operation too old or has not been run in clean-up period
Activate SAP High Contrast Theme
Assign / Move SM37 Job to Another SAP Application Server
SLICENSE: System No. Empty / Installation Number INITIAL
© 2018 ITsiti. All Rights Reserved
Powered by KEEM