Unusual SQL performance in RAC when using "collection iterator pickler fetch" operation
OS - Red Hat Enterprise Linux Server release 7.9 (Maipo)
Database - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
On a 2-Node RAC cluster this sql statement is run:
SELECT F.FACILITY_TASK, F.PRIORITY FROM FACILITY_TASKS_FOR_RESV F WHERE F.RESORT = :B4 AND F.RESV_NAME_ID = :B3 AND F.RESERVATION_DATE = :B2 AND INSTR( ',' || :B1 || ',',',' || F.FACILITY_TASK || ',' ) <> 0 ORDER BY F.PRIORITY
On Node 1 its runtime average is about .007995283 seconds.
On node 2 its runtime average is sometimes about .00756986 seconds, however there is a second sql cursor child that has a runtime average of 141.937777 seconds.
0