Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Update statistics in Oracle 11.2.0.3.10 - Please advise

Hello All,

To increase the Oracle performance, we are planning to execute the below commands at OS level during non business hours in ECC, BW and GRC systems.

1) brconnect -u / -c -f stats -t system_stats

2) brconnect -u / -c -f stats -t oradict_stats

3) brconnect -c -u / -f stats -t all -f collect -p 4 

Is there any sequence to follow to execute these below 3 commands in ECC/BW and GRS systems.

Please let us know whether we need to follow any procedure before executing the above 1 and 2 command. Also let us know whether we can schedule these 3 commands once in three months. Please advise us

Regards

Subbu

Former Member
Not what you were looking for? View more on this topic or Ask a question