ORA-12850 Caused by SELECT FROM UNIFIED_AUDIT_TRAIL (Doc ID 2656023.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

• ORA-12850 error happened intermittently when SELECT FROM UNIFIED_AUDIT_TRAIL.
• "_px_compilation_debug" trace of PPA7 process shows that ORA-12850 error raised after Slave Plan Signature and QC Plan Signature mismatched.
  
  Slave Plan Signature:  SQL Plan Signature (0xb25a54df0):
  qkn_qksctxPlanSig    = e973964
  ctx_qksctxPlanSig    = 1
  rwo_qksctxPlanSig    = 2fd0512f
  px_qksctxPlanSig     = 0
  dfo_qksctxPlanSig    = 1d2facd7
  gd_qksctxPlanSig     = 0
  sm_qksctxPlanSig     = 0
  obj_qksctxPlanSig    = b9cd79ce　*<<<<<<<<<<<<
  pgatgt_qksctxPlanSig = 1
  vpd_qksctxPlanSig    = 0
  eopn_qksctxPlanSig   = 0
  phv2_qksctxPlanSig   = 8d9ffcc
  phvfull_qksctxPlanSig = 8d9ffcc
  phvfinal_qksctxPlanSig= 0
  QC Plan Signature from Parse Msg:  SQL Plan Signature (0x7f12a0dd012c):
  qkn_qksctxPlanSig    = e973964
  ctx_qksctxPlanSig    = 1
  rwo_qksctxPlanSig    = 2fd0512f
  px_qksctxPlanSig     = 0
  dfo_qksctxPlanSig    = 1d2facd7
  gd_qksctxPlanSig     = 0
  sm_qksctxPlanSig     = 0
  obj_qksctxPlanSig    = 45957ca7　*<<<<<<<<<<<<
  pgatgt_qksctxPlanSig = 1
  vpd_qksctxPlanSig    = 0
  eopn_qksctxPlanSig   = 0
  phv2_qksctxPlanSig   = 8d9ffcc
  phvfull_qksctxPlanSig = 8d9ffcc
  phvfinal_qksctxPlanSig= 0
  Policies in slave's cursor
  Policies in slave uga (QC's policies)
  ... ...
  2020-03-05 19:48:05.276*:PX_Control:kxfx.c@5882:kxfxsStatus():
         joining FALSE ParseState KXFXUPARSE2 (3)　
  2020-03-05 19:48:05.409*:PX_Control:kxfx.c@10462:kxfxmai():
         In signal-handler after catching 12850
  
  
  

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.