brtools
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
Brtools permissions
For set correct permission and owners for brtools execute: chmod 4774 brarchive brbackup brconnect chown <orasid>:sapsys brarchive brbackup brconnect Note 113747 – Owners and authorizations for BR*Tools Solution The following settings are required to call the BR*Tools correctly, especially when using transaction DB13 or DBACOCKPIT: (1) ora<sid> and <sid>adm on DB server have a search path on /sapmnt/<SID>/exe. (All br* are contained in this directory.) ora<sid> belongs to the dba group, <sid>adm belongs to the sapsys group, (2) <sid>adm on the database server has the rhosts entry: “+ <sid>adm”. (3) The ops$<sid>adm Oracle user must be created in the DB and must … Continue Reading