Solution : https://service.sap.com/sap/support/notes/706478 (Connexion à SAP Service Marketplace requise)
Résumé :
La note SAP traite de la croissance significative des tables et des problèmes de performance associés dus au volume important de données et à la fragmentation des index, principalement dans les tables administratives de base. Pour atténuer ces défis, elle souligne la nécessité de supprimer ou d'archiver régulièrement les données, de reconstruire les index des tables sur certains systèmes de bases de données comme Oracle, afin de contrer les baisses de performance et l'occupation inutile d'espace. De plus, elle fournit des directives pour éviter la compilation des statistiques de la base de données pendant des périodes non représentatives. Pour récupérer de l'espace après la suppression dans des bases de données comme Oracle, une réorganisation des tables est recommandée. Des stratégies spécifiques et des ressources supplémentaires d'autres notes SAP et du guide de gestion des données sont conseillées pour une gestion efficace de la base de données.
Mots Clés :
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
Notes associées :
| 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 |