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

Define SAP Support Package Queue
BDLS: SAP Tool Conversion of Logical System Names
SAP: Can't open shared memory administration (rc=3)
Errors occurred during post-handling RS_AFTER_IMPORT for DTPA L
© 2017 ITsiti. All Rights Reserved
Powered by KEEM