Skip to Content
author's profile photo Former Member
Former Member

DB statistics can be done at the end of upgrade of Oracle10->11

Hello

Might be a strange question but I guess executing DB statistics can be done at the end of upgrade of Oracle10->11

i.e.

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

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

and

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

Thank you as this takes too much time of beein attended

Kr

Jan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jan 29, 2014 at 08:25 PM

    Hello Jan

    Collecting statistics is one of the post upgrade tasks.

    But when you start the DBUA for the upgrade and if it warns you about stale statistics then you can run the statistics collection.

    Check the upgrade guide as it is clearly mentioned in it.

    https://websmp210.sap-ag.de/~form/sapnet?_SHORTKEY=00200797470000089041&_SCENARIO=01100035870000000202&_OBJECT=011000358…

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 29, 2014 at 08:31 PM

    Hello

    Yes of course, you should update the statistics this is part of the post upgrade tasks.

    Do not forget also to:

    - apply the latest version of the script from note 1020260 - Delivering Oracle statistics

    - apply recommendations from note 974781 - Oracle internal maintenance jobs to disable Oracle automatic job for statistics update.


    Setting the here under option in Br*Tools configuration file (initSID.sap) you can make sure that system & DDIC statistics are compute during statistic update.

    1235952 - Minor functional enhancements in BR*Tools (2)

    To activate this update, set the following init<DBSID>.sap parameters:

    stats_dict_cycle = <days>

    stats_system_cycle = <days>


    Regards,



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.