ORA-00600: internal error code, arguments: [32695]

A proccess is getting the following error when execute a query;

ORA-00600: internal error code, arguments: [32695], [hash aggregation can’t be done], [], [], [], [], [], []

Look for this error at MOS, I can see it is a bug. (if you have access to Support refer note 729447.1). It recommend upgrade until fixed version or apply two workaround, putting disable for all database or our session with;

alter system set “_gby_hash_aggregation_enabled” = false;

alter session set “_gby_hash_aggregation_enabled” = false;

Other option is patch statement (or create an outline) using the next hint.

/*+ NO_USE_HASH_AGGREGATION */

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s