brconnect scripts - update stats purpsoe

[#1]

Hi,

Our installation is SAP ECC 6.0 (EHP 0) with Oracle 12c & AIX 7.1

We used to execute following scripts, one a month.

brconnect -c -u / -f stats -t all -f collect -p 5
brconnect -u / -c -o summary -f stats -t all -m +I -f allsel,collect,method,precision,space,keep -p 6
brconnect -c -u / -f stats -t oradict_stats
brconnect -c -u / -f stats -t system_stats

1. Can you pl guide to clarify, whats the purpose of executing following scripts?

2. Is executing once a month, frequency is enough for this?

Thanks

Zerandib

[janos_mucsi-besze]

Hi,

Here are the answer:

- the 1st command collects CBO statistics

- the 2nd command collects space statistics as well

- the 3rd command collects Oracle Dictionary Statistics

- the 4th command collects System Statistics

More information about the meaning of each argument located in below link:

-f stats | SAP Help Portal

brconnect -c -u / -f stats -t all -f collect -p 5
brconnect -u / -c -o summary -f stats -t all -m +I -f allsel,collect,method,precision,space,keep -p 6
brconnect -c -u / -f stats -t oradict_stats
brconnect -c -u / -f stats -t system_stats