SAP Note 706478 - Preventing Basis tables from increasing considerably

Component : Database performance issues - Microsoft SQL ServerBC-DB-ORA OracleHAN-DB SAP HANA Database

Solution : https://service.sap.com/sap/support/notes/706478 (SAP Service marketplace login required)

Key words :

Related Notes :

1998391Mass deletion of BW Query Views
1969700SQL statement collection for SAP HANA
1968912Mass deletion of BW Workbooks
1929538HANA Statistics Server - Out of Memory
1905137
1855041Sizing Recommendation for Master Node in BW-on-HANA
1736976Sizing Report for BW on HANA
1634681Database migration: Report to find large row store tables
1529387Tables MDMFDBEVENT, MDMFDBID,MDMFDBPR increase significantly
1438410SQL: Script collection for Oracle
1419451RSWR_BOOKMARK_DELETE: Report to delete the Bookmarks
1411834DBA Cockpit: GVD_* tables, RSORAHCL, history
1388287RSRD_BOOKMARK_REORGANISATION: Specified time not used
1338276
1334342Deactivating the BW trace tool (RSTT) globally
1146889FPRW: Deleting logs for receivable adjustments
1142427Trace cannot be deleted regularly
1095924Correction: Deletion/analyis report for error handling logs
1080813DBA Cockpit: Changing history update (Oracle database)
1018114Additional date restrictions for deleting statistics data
988703ALLOCATIONS: Information about deleting extracts
966854Reorganization - New report
948831Event trace - Preparing a UC conversion
934848Collective note: (FAQ) BI Administration Cockpit
923610Memory parameter recommendations for banking systems
911392Deleting change pointers which are no longer required
771929FAQ: Index fragmentation
766349FAQ: Oracle SQL optimization
756335Statistics in tables w/ heavily fluctuating volumes of data
745639FAQ: Oracle enqueues
732470Contract: Logging data changes
730447Table analysis: New data store
694895Performance and tables RSMON*, RS*DONE
666290Deleting "orphaned" job logs
618868FAQ: Oracle performance
608174Table CCMOBJKEYS adds up entries
589899Deleting unusable entries in table RSZIXWWW
536414CRM 3.0/3.1 SAP Composite Note: Middleware reorganization
513454REP: High-performance operation with change pointers
512184Background processing: Periodically delete job log
505608ALE: Reorganizing IDOCREL
493156Performance of BDoc message related object links
449891Temporary database objects in BW 3.x
434902ALLOCATION: Many entries in table DBTABLOG
403704BRCONNECT - Enhanced function for Oracle DBA
385219Reorganization of BW workbooks
375566Large number of entries in tRFC and qRFC tables
332677Rebuilding fragmented indexes
206439Reorganization of tables in CRM Middleware
195157Application log: Deletion of logs
182963Huge increase in Table TXMILOGRAW
67014Reorganizing update requests
49545Deleting unnecessary work items
48400Reorganization of TemSe and Spool
46358Shutdown of the log of workflow events
41300Table DBTABPRT is very large
40088EDI/IDoc: Deleting and reorganizing IDocs
36781Table APQD is very large
36283Buffer synchronization
16083Standard jobs, reorganization jobs
11838Deleting short dumps from the SNAP table
3992Purpose of the table INDX