EarlyWatch Alert
/sdf/rsoradld_new TIMEOUT and oracle dictionary statistics
We have long runtimes of the program /sdf/rsoradld_new during the data collection for the EarlyWatch Alert. This results in a timeout. Read Note 1247198 – /SDF/RSORADLD_NEW timeout In our case timeout occured on V$VIEW. Solution: Note 984955 – Timeout with selection of V$-Views Note 838725 – Oracle dictionary statistics and system statistics BRCONNECT command to create Oracle dictionary statistics: OS> brconnect -u / -c -f stats -t oradict_stats When you use this call, BRCONNECT internally calls the two procedures GATHER_DICTIONARY_STATS and GATHER_FIXEC_OBJECTS_STATS. Creating Oracle system statistics (NOWORKLOAD) using brconnect $ brconnect -u / -c -f stats -t system_stats Creating Oracle … Continue Reading