We are are doing a simulation of upgrading our SAP instances from oracle 9 to 10 as per the SAP oracle upgrade guide for unix , we have reached the post upgrade steps where we have to run
brconnect -u / -c -f stats -t system_stats
brconnect -u / -c -f stats -t oradict_stats
The above statements take more than 2 days to finish, why do they take such a long time and how can we speed up their runs as we will have to run these when we do the real production upgrade meaning downtime