Solution : https://service.sap.com/sap/support/notes/974781 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the deactivation of unnecessary Oracle database maintenance jobs within an SAP system, specifically for Oracle versions 10.2 and 11.2. It outlines how internal tasks like GATHER_STATS_JOB, AUTO_SPACE_ADVSIOR_JOB, and specific Oracle Configuration Manager jobs can be disabled because they are handled by BRCONNECT or are unsupported. This deactivation prevents unnecessary database load and potential interference with ongoing activities. The note includes SQL commands for disabling these jobs and confirms that this does not impact SAP operations, as the maintenance functions are managed through SAP BR*Tools.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category consulting validity, attributes database system oracle header data released, __%pdfstyle%__ / } symptom internal maintenance jobs, automatic segment advisor jobauto_space_advisor_jobthe job auto_space_advisor_job starts, central technical note 838725 oracle dictionary statistics, optimize space 838725 oracle dictionary statistics, system statistics 828268 oracle database 10g, / __%pdfstyle%__font-size, software component version references, system statistics 927813 oracle 10g
Related Notes :
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 1431793 | Oracle 11.2.0: Upgrade Scripts |
| 1001925 | Increased number of disk accesses with Oracle 10g |
| 927813 | Oracle 10g: Using Oracle Segment Advisor to optimize space |
| 838725 | Oracle dictionary statistics and system statistics |
| 828268 | Oracle Database 10g: New functions |