well did you do oracle's suggestion? On Wed, 16 Mar 2005 11:09:51 +0000, Birkir Bjornsson <birkir@xxxxxxxx> 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? -- //www.freelists.org/webpage/oracle-l