Skip to Content

Update statistics getting failed

Hi All,

I am getting an error while updating the statistics  as below.

BR0301E SQL error -20003 in thread 4 at location stats_tab_collect-69, SQL statement:

'EXECUTE stmt_1d'

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"ACCTIT"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASC

ADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20003: Specified bug number (9196440) does not exist

ORA-06512: at "SYS.DBMS_STATS", line 15223

ORA-06512: at "SYS.DBMS_STATS", line 15245

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3.ACCTIT

I have gone through Note and tried to relink all. But still problem persists.

1667086 - ORA-20003 - Specified bug number (<number>) does not exist.

I also found no Mopatch/Opatch directories  under oracle home. I have restored them from one of my backup.

Do I need to run again below scripts .

@?/rdbms/admin/dbmsstat.sql

  @?/rdbms/admin/prvtstas.plb

  @?/rdbms/admin/prvtstat.plb

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 16, 2013 at 09:56 AM

    Hi,

    Try to run this command and see if it fixes it .

    sql>GRANT CREATE JOB TO SAPDBA;

    Another thing what is the Oracle version as i can see the bug fix in the below note for 11.2.0

    1431798 - Oracle 11.2.0: Database Parameter Settings

    Note 1667086 - ORA-20003 - Specified bug number (<number>) does not exist.

    Looks to be similar hope you are checking the correct oracle home.

    '9196440:ON' UNIX SBP 11201x_date ( date >= 201009 )
    UNIX SBP 11202x_date ( date >= 201011 )
    UNIX SGR 11202x_date ( date >= 201106 )
    UNIX SXD 11202x_date ( date >= 201106 )
    UNIX 11.2.0.3
    WIN 11.2.0.1.nP ( n >= 4 )
    WIN 11.2.0.2
    WIN 11.2.0.3


    Thanks

    Rishi Abrol

    Add comment
    10|10000 characters needed characters exceeded

    • Dear All,

      My issue is resolved  guess update statistics is going on smooth now.

      Just I have run the below scripts in startup restrict mode. This worked out for me. Thank you Rishi& Ashish for your quick response and suggestions.

      @?/rdbms/admin/dbmsstat.sql

        @?/rdbms/admin/prvtstas.plb

        @?/rdbms/admin/prvtstat.plb

      Thank you.

      Regard's

      Sai

  • avatar image
    Former Member
    Nov 16, 2013 at 09:13 AM

    Hello Saikumar Mudragada,

    What is your Oracle db version and SBP level ? you can apply latest SBP patch for your db.

    you should also check your oracle parameters, specially FIX_CONTROL parameters.


    1431798  - Oracle 11.2.0: Database Parameter Settings


    1171650  - Automated Oracle DB parameter check

    best regards

    ashish


    Add comment
    10|10000 characters needed characters exceeded