Solution : https://service.sap.com/sap/support/notes/970538 (SAP Service marketplace login required)
Summary :
RSORAISQN is a report for mass analyzing and defragmenting nonpartitioned B*Tree indexes. It utilizes heuristic algorithms for analysis and offers methods like coalesce or rebuild online for defragmentation. This tool is strategically designed for restorability, controlled termination, and provides multiple parallelism options along with storage quality history. Additionally, it supports monitoring and runtime estimation for ongoing operations and can target indexes both locally and remotely. To operate, explicit DB user privileges are required including UNLIMITED TABLESPACE and CREATE TABLE, among others. Known issues are documented in corresponding SAP notes. Additional concerns include potential problems during index rebuilding or coalescing, such as extensive archival logging and resource usage.
Key words :
converting column overflows integer note 1116076rsoraisqn - textelements, massive archivelog generation massive resource consumption, note1 1446751rsoraisqn - compute_bcd_overflow note 1292268rsoraisqn - ora-14107, required note 1286665rsoraisqn - parallel degree, parallel rebuild note 1118603rsoraisqn - ora-01455, controlled stopable offers, parallelism offers history, storage qualities offers, 'index coalesce' problems, 'index rebuild online'
Related Notes :
| 771929 | FAQ: Index fragmentation |