Update statistics in Oracle 220.127.116.11.10 - Please advise
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