Skip to Content
avatar image
Former Member

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

Greetings to everyone,

We come across the following error while we run 'oradict_stats' string below. On having surveyed the internet we haven't hit on anything confirm or compeling with resolution for this error. There is also another line where in it say its a bug # 5099019. On the basis of the search on the internet in this direction, it seem that if we use "set "_fix_control"='5099019:ON'" may rectify this bug.

Our question is will the line "set "_fix_control"='5099019:ON'" for sure do the trick & resolve both the error. "bug # 5099019 & ORA-06512: at "SYS.DBMS_STATS", line 14611".

Our current environment is ECC5.0 Production server on AIX 5.3 / Oracle 10.2.0.4

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

BR0280I BRCONNECT time stamp: 2009-09-11 17.35.11

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRCONNECT time stamp: 2009-09-11 17.35.24

BR0301E SQL error -20003 at location stats_oradict_collect-4, SQL statement:

'BEGIN DBMS_STATS.GATHER_DICTIONARY_STATS (ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE AUTO', GRANULARITY => 'ALL', CASCADE => TRUE, OPTIONS => 'GATHER', NO_INVALIDATE => FALSE); END;'

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

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

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

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

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

ORA-06512: at line 1

BR1313E Collection of Oracle dictionary statistics failed

Will appreciate if anyone can share there inputs to resolve this error.

Thanks in advance

gab

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 14, 2009 at 07:25 PM

    Hello Gab

    how you fix this problem?

    I have the same error

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

    I have installed the patch but if I set the oracle parameter "_fix_control"='5099019:ON'" the DB didn´t start by oracle error ORA-00940 invalid ALTER command

    thanks

    Hernando

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2009 at 11:07 AM

    check #761745

    Nesimi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2009 at 11:45 AM

    Hi ,

    See the note

    Note 838725 - Oracle 10.2: Dictionary and system statistics

    It is released recently & have the solution for same error message.

    Thanks,

    Shambo

    Add comment
    10|10000 characters needed characters exceeded