Skip to Content
avatar image
Former Member

Update statistics in Oracle 11.2.0.3.10 - Please advise

Hello All,

To increase the Oracle performance, we are planning to execute the below commands at OS level during non business hours in ECC, BW and GRC systems.

1) brconnect -u / -c -f stats -t system_stats

2) brconnect -u / -c -f stats -t oradict_stats

3) brconnect -c -u / -f stats -t all -f collect -p 4 

Is there any sequence to follow to execute these below 3 commands in ECC/BW and GRS systems.

Please let us know whether we need to follow any procedure before executing the above 1 and 2 command. Also let us know whether we can schedule these 3 commands once in three months. Please advise us

Regards

Subbu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 07, 2015 at 11:52 AM

    You should have searched for the notes before posting here. see below note.

      838725 - Oracle dictionary statistics and system statistics

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 12:54 PM

    Subbu Samb wrote:

    Hello All,

    To increase the Oracle performance, we are planning to execute the below commands at OS level during non business hours in ECC, BW and GRC systems.

    1) brconnect -u / -c -f stats -t system_stats

    2) brconnect -u / -c -f stats -t oradict_stats

    3) brconnect -c -u / -f stats -t all -f collect -p 4

    Is there any sequence to follow to execute these below 3 commands in ECC/BW and GRS systems.

    Please let us know whether we need to follow any procedure before executing the above 1 and 2 command. Also let us know whether we can schedule these 3 commands once in three months. Please advise us

    Regards

    Subbu

    Question:

    why do you want to execute them at OS level?

    Use DB13 to schedule the number 3, it is a standard that should be scheduled every day (the parallel option should depend on the amount of power your system has and the load at night)

    Set the parameters STATS_DICT_CYCLE and STATS_SYSTEM_CYCLE on the init<sid>.sap and the commands 1 and 2 will be automatically done by the 3rd command after the amount of days indicated on the parameters (recommended 3 months) take a look at the note 1235952 were they are explained.

    Add comment
    10|10000 characters needed characters exceeded