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

More from SAPBC.RU

Your Message To SAP Basis Expert

Leave Reply
Your email address will not be published.