Solution : https://service.sap.com/sap/support/notes/706478 (SAP Service marketplace login required)
Summary :
SAP Note addresses table growth and associated performance issues due to large volumes of data and index fragmentation, particularly in administrative Basis tables. To mitigate such challenges, it underscores regular deletion or archiving of data, reconstruction of table indexes on certain database systems like Oracle, to counteract performance declines and unnecessary space occupancy. Additionally, it provides guidance on preventing the compilation of database statistics during non-representative times. For space recovery post-deletion in databases like Oracle, table reorganization is recommended. Specific detailed strategies and additional resources from various other SAP Notes and the Data Management Guide are advised for effective database management.
Key words :
components bc-db-mss microsoft sql serverbc-db-ora oraclehan-db sap hana database priority recommendations / additional info category, customer component sv-bo-db database performance issues, table txmilograw 67014 reorganizing update requests 49545 deleting unnecessary work items 48400 reorganization, bdoc message related object links 449891 temporary database objects, table dbtablog 67014 reorganizing update requests 375566 large number, bdoc message related object links 206439 reorganization, find large row store tables 1529387 tables mdmfdbevent, bi administration cockpit 923610 memory parameter recommendations, bw query views 1969700 sql statement collection, /ilm-> data archiving-> media library-> literature
Related Notes :
| 1998391 | Mass deletion of BW Query Views |
| 1969700 | SQL statement collection for SAP HANA |
| 1968912 | Mass deletion of BW Workbooks |
| 1929538 | HANA Statistics Server - Out of Memory |
| 1905137 | |
| 1855041 | Sizing Recommendation for Master Node in BW-on-HANA |
| 1736976 | Sizing Report for BW on HANA |
| 1634681 | Database migration: Report to find large row store tables |
| 1529387 | Tables MDMFDBEVENT, MDMFDBID,MDMFDBPR increase significantly |
| 1438410 | SQL: Script collection for Oracle |
| 1419451 | RSWR_BOOKMARK_DELETE: Report to delete the Bookmarks |
| 1411834 | DBA Cockpit: GVD_* tables, RSORAHCL, history |
| 1388287 | RSRD_BOOKMARK_REORGANISATION: Specified time not used |
| 1338276 | |
| 1334342 | Deactivating the BW trace tool (RSTT) globally |
| 1146889 | FPRW: Deleting logs for receivable adjustments |
| 1142427 | Trace cannot be deleted regularly |
| 1095924 | Correction: Deletion/analyis report for error handling logs |
| 1080813 | DBA Cockpit: Changing history update (Oracle database) |
| 1018114 | Additional date restrictions for deleting statistics data |
| 988703 | ALLOCATIONS: Information about deleting extracts |
| 966854 | Reorganization - New report |
| 948831 | Event trace - Preparing a UC conversion |
| 934848 | Collective note: (FAQ) BI Administration Cockpit |
| 923610 | Memory parameter recommendations for banking systems |
| 911392 | Deleting change pointers which are no longer required |
| 771929 | FAQ: Index fragmentation |
| 766349 | FAQ: Oracle SQL optimization |
| 756335 | Statistics in tables w/ heavily fluctuating volumes of data |
| 745639 | FAQ: Oracle enqueues |
| 732470 | Contract: Logging data changes |
| 730447 | Table analysis: New data store |
| 694895 | Performance and tables RSMON*, RS*DONE |
| 666290 | Deleting "orphaned" job logs |
| 618868 | FAQ: Oracle performance |
| 608174 | Table CCMOBJKEYS adds up entries |
| 589899 | Deleting unusable entries in table RSZIXWWW |
| 536414 | CRM 3.0/3.1 SAP Composite Note: Middleware reorganization |
| 513454 | REP: High-performance operation with change pointers |
| 512184 | Background processing: Periodically delete job log |
| 505608 | ALE: Reorganizing IDOCREL |
| 493156 | Performance of BDoc message related object links |
| 449891 | Temporary database objects in BW 3.x |
| 434902 | ALLOCATION: Many entries in table DBTABLOG |
| 403704 | BRCONNECT - Enhanced function for Oracle DBA |
| 385219 | Reorganization of BW workbooks |
| 375566 | Large number of entries in tRFC and qRFC tables |
| 332677 | Rebuilding fragmented indexes |
| 206439 | Reorganization of tables in CRM Middleware |
| 195157 | Application log: Deletion of logs |
| 182963 | Huge increase in Table TXMILOGRAW |
| 67014 | Reorganizing update requests |
| 49545 | Deleting unnecessary work items |
| 48400 | Reorganization of TemSe and Spool |
| 46358 | Shutdown of the log of workflow events |
| 41300 | Table DBTABPRT is very large |
| 40088 | EDI/IDoc: Deleting and reorganizing IDocs |
| 36781 | Table APQD is very large |
| 36283 | Buffer synchronization |
| 16083 | Standard jobs, reorganization jobs |
| 11838 | Deleting short dumps from the SNAP table |
| 3992 | Purpose of the table INDX |