ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx]

ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Apr 06 11:00:30 2015
Sweep [inc][1123067]: completed
Mon Apr 06 11:00:30 2015


This can be resolved by following the Oracle Document

(Doc ID 12591399.8)

"Description

Partition pruning for joins between local partitioned tables and

remote tables may fail with ORA-600 [qesmagetpamr-nullctx] or other unexplained ORA- errors like ORA-14091.

Workaround

Set _subquery_pruning_enabled=FALSE "

BUT, there is another workaround

Flush Shared pool and the alert log gets cleared.

alter system flush shared_pool;