This content has been marked as final. Show 7 replies
Is your query doing INSERT ... AS SELECT ...?
this problem occured from "HASH GROUP BY" so you can modify sql statement used hint as bellow
SELECT /*+ no_use_hash_aggregation */ FROM WHERE GROUP BY ?
alter session set "_gby_hash_aggregation_enabled"=false ;
pls take a look this doc
ORA-00600 [QESHQBNEXTBUFFER.1] While Inserting into Table [ID 421341.1]
This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition.
Suggestion use My Oracle Support. http://support.oracle.com
1 - use note: ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1], to check bug.
If you don't find anything about:
2 - Report this error to Oracle Support Services opening a SR.
I am just running "BEGIN DBMS_STATS.GATHER_SCHEMA_STATS(...." not any Insert or select query.
it sounds like a support kind of question then :) (sorry for the confusion)
Could you please suggest on this too?
no, I think you should open an SR for this ...