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 system statistics (WORKLOAD) using brconnect
$ brconnect -u / -c -f stats -t system_stats -i <minutes>