Component : Database Administration with Oracle -

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

Summary :
SAP Note explains collecting Oracle 9i system statistics using DBMS_STATS, managed via BRCONNECT, to optimize the cost-based optimizer (CBO). Although system statistics collection is generally inadvisable in the SAP environment without expert advice, BRCONNECT enhances this functionality, offering commands and options like '-u' and '-i ' for execution. Care is needed with Oracle 9i due to necessary DBA privileges, which change in Oracle 10g where the OPS$ mechanism can be utilized, negating the '-i' option altogether. Regular statistic updates are advised for optimum performance in Oracle 10G as of BRCONNECT 7.00.

Key words :
sysdbasql> grant create job, cost-based optimizer reason, relevant ops$ database user, updating system statistics automatically, cost-based optimizer, create job privilege, system database user, access paths optimally, standard package dbms_stats, operating system resources

Related Notes :

1235952	Minor functional enhancements in BR*Tools (2)
927295	FAQ: Oracle system statistics
838725	Oracle dictionary statistics and system statistics
750631	Approximations for cost calculation of the CBO
514205	Corrections in BR*Tools version 6.20
403706	Corrections in BR*Tools Version 6.10