Solution : https://service.sap.com/sap/support/notes/863811 (SAP Service marketplace login required)
Summary :
Starting with Oracle 10g, it is advised to regularly update statistics for Oracle dictionary and X$ tables, a departure from previous versions where these tables by default lacked statistics. This is necessary to optimize performance. BRCONNECT 7.00 facilitates this process and should be executed with the command: `brconnect -u / -c -f stats -t ORADICT_STATS`. It is recommended to perform these updates quarterly. For automatic updates, refer to Note 1235952. BR*Tools, specifically BRCONNECT, are pertinent in this context.
Key words :
prerequisites consulting solution brconnect 7, terms br tools, oracle dictionary tables, older oracle versions, oracle dictionary statistics, oracle 10g, brconnect reason, call brconnect, optimizer statistics, fixed objects
Related Notes :
| 1235952 | Minor functional enhancements in BR*Tools (2) |
| 838725 | Oracle dictionary statistics and system statistics |