Select Hangs After Upgrade From 126.96.36.199 To 188.8.131.52 Waiting on 'PGA memory operation'
(Doc ID 2443753.1)
Last updated on AUGUST 07, 2020
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later Information in this document applies to any platform.
The database was recently upgraded from 220.127.116.11 to 18.104.22.168 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 ;
The database was upgraded from 22.214.171.124 to 126.96.36.199.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!