Select Hangs After Upgrade From 11.2.0.4 To 12.2.0.1 Waiting on 'PGA memory operation' (Doc ID 2443753.1)

Last updated on AUGUST 07, 2020

Applies to:

Symptoms

• The database was recently upgraded from 11.2.0.4 to 12.2.0.1 on Linux platform
• The following select hangs on "PGA memory operation":
  
  SELECT T1.COL1,
    T1.COL2,
    T1.COL3,
    T1.COL4,
    T1.COL5
  FROM  Table45 T1
  WHERE (T1.COL2 IS NOT NULL )
  AND (T1.COL1 IS NOT NULL )
  AND (T1.COL3 IS NOT NULL )
  AND (COL2 IN
    (SELECT TO_NUMBER(COL6) FROM Table_2
    ))
  AND ( COL1 = 'this is a test' ) ORDER BY T1.COL2 ASC,
    T1.COL3 ASC
  ;
  
  
  
  

Changes

 The database was upgraded from 11.2.0.4 to 12.2.0.1.

Cause

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