Statistics
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Statistics

Hybrid View

  1. #1
    Join Date
    Sep 2001
    Posts
    34

    Question

    Hello DBAs !!!
    Since few days, Statistics don't work correctly in my dev server. When i look the stats log file on morning, I see this error :
    ------------------------------------------------------------------
    BEGIN dbms_utility.analyze_SCHEMA('SCHEMA1','COMPUTE',NULL,NULL,'FOR ALL COLUMNS'); END;

    *
    ERROR at line 1:
    ORA-00600: internal error code, arguments: [16515], [D], [40], [7202], [4], [0], [], []
    ORA-06512: at "SYS.DBMS_DDL", line 179
    ORA-06512: at "SYS.DBMS_UTILITY", line 331
    ORA-06512: at line 1

    ------------------------------------------------------------------
    I don't know why this error occurs.
    Can anyone help me or give me some idea ?

    Thx

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    What do you have in your init.ora parameters:

    optimizer_features_enable and compatible?

    Have you tried to delete statistics and run again?

    There are a lot of information in metalink about this error.

    All in metalink point to delete statistics and run again

    Regards

    Angel

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Run first

    Code:
    alter session set "_enable_type_dep_selectivity" = true;
    and then

    Code:
    BEGIN dbms_utility.analyze_SCHEMA('SCHEMA1','COMPUTE',NULL,NULL,'FOR ALL COLUMNS'); END;
    If that doesn't help, delete the statistics and try again, if that doesn't help, open an iTart with Metalink.

    Do you get the arror if you analyze table by table, i.e.,

    Code:
    analyze table TABLE_NAME compute statistics;
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Julian,

    What do exactly the parameter _enable_type_dep_selectivity?

    Thanks

    Angel

  5. #5
    Join Date
    Sep 2001
    Posts
    34
    Thx a lot
    I will try as soon as possible.

    But how can i delete statistics ?

    -------------------------------
    Sorry but i'm a junior DBA
    -------------------------------

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    BEGIN
    dbms_utility.analyze_schema('SCHEMA','DELETE',NULL,NULL,'FOR ALL COLUMNS');
    END;
    /
    Regards

    Angel

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by aarroyob
    Julian,

    What do exactly the parameter _enable_type_dep_selectivity?

    Thanks

    Angel
    It is an anti-bug parameter that might help avoiding the 600-error when collecting statistics. Might help, might not.

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Sep 2001
    Posts
    34
    Thx a lot !!!!
    I will try all your solutions.


  9. #9
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Thanks as always for share your knowledge with us Julian

    Cheers

    Angel

  10. #10
    Join Date
    Sep 2001
    Posts
    34
    For information :
    Delete statistics don't work.
    I'll try in few days to set the parameter enable_type_dep_selective in the init.ora when I could restart the DB.

    Thx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width