FAQ
=
Hi



Has anyone experienced this error running Enterprise Man= ager 10 Grid
Control using the embedded 9.0.1.5 database( Why in the hell is thi= s
version embedded :@) on redhat linux ES 3.0



ORA-00600: internal error code, arguments: [19004], [], = [], [], [], [],
[],[]

This happends when running some ugly sql query made by EM. Accordi= ng to
Metalink this error might be becaust of DBMS_STATS may produ= ce incorrect
histogram data which results in subsequence ORA-600 [19004] er= rors. (The
histogram buckets are out of order). So the recommended workarou= nd is: Set
NLS_SORT=3Dbinary in the session before collecting statistics. Any
suggestions?

Search Discussions

  • David Sharples at Mar 16, 2005 at 6:28 am
    well did you do oracle's suggestion?
    On Wed, 16 Mar 2005 11:09:51 +0000, Birkir Bjornsson wrote:
    =
    Hi
    ORA-00600: internal error code, arguments: [19004], [], = [], [], [], [],
    [],[]

    This happends when running some ugly sql query made by EM. Accordi= ng to
    Metalink this error might be becaust of DBMS_STATS may produ= ce incorrect
    histogram data which results in subsequence ORA-600 [19004] er= rors. (The
    histogram buckets are out of order). So the recommended workarou= nd is: Set
    NLS_SORT=3Dbinary in the session before collecting statistics. Any
    suggestions?
    --
    http://www.freelists.org/webpage/oracle-l
  • Birkir Bjornsson at Mar 16, 2005 at 6:44 am
    No not yeat, I would have to set it globally for the Database since these q=
    ueries come from EM. But I guess that it should be okei, but just wanted to=
    see if anyone had has this problem before I go ahead and make the change.

    Kind Regards
    Birkir

    -----Upphafleg bo=F0-----
    Sendandi: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce@freelists.o=
    rg] Fyrir h=F6nd David Sharples
    Sent: 16. mars 2005 11:24
    Vi=F0takandi: oracle-l_at_freelists.org
    Efni: Re: ORA-00600: internal error code, arguments: [19004], [], [], [], [=
    ], [], [], []

    well did you do oracle's suggestion?

    On Wed, 16 Mar 2005 11:09:51 +0000, Birkir Bjornsson wrot=
    e:
    =3D
    Hi
    =
    ORA-00600: internal error code, arguments: [19004], [], =3D [], [], [], [= ],
    [],[]
    =
    This happends when running some ugly sql query made by EM. Accordi=3D ng= to
    Metalink this error might be becaust of DBMS_STATS may produ=3D ce incorr= ect
    histogram data which results in subsequence ORA-600 [19004] er=3D rors. (= The
    histogram buckets are out of order). So the recommended workarou=3D nd is= : Set
    NLS_SORT=3D3Dbinary in the session before collecting statistics. Any
    suggestions?
    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedMar 16, '05 at 6:13a
activeMar 16, '05 at 6:44a
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2018 Grokbase