ORACLE
Oracle dictionary statistics and system statistics | Create new statistics for all tables without a necessity check
We have Note 838725 – Oracle dictionary statistics and system statistics Creating Oracle dictionary statistics using BRCONNECT BRCONNECT command to create Oracle dictionary statistics: OS> brconnect -u / -c -f stats -t oradict_stats Creating Oracle system statistics using BRCONNECT Creating Oracle system statistics (NOWORKLOAD) using brconnect $ brconnect -u / -c -f stats -t system_stats Create new statistics for all tables without a necessity check brconnect -u / -c -f stats -t all -f collect
Example ALTER DATABASE DATAFILE AUTOEXTEND ON MAXSIZE UNLIMITED
ALTER DATABASE DATAFILE ‘/oracle/SID/sapdata4/sr3731_4/sr3731.data4’ AUTOEXTEND ON MAXSIZE UNLIMITED;
ORACLE Shared Pool Size
Note 690241 – The Shared SQL Area in the Shared Pool and large SQL Stmnts SPS = (cpus / 4 * 350 MB) + (cache / 1024 * 5) + 300 MB
/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