turn gc cr request and cache buffers chins

SQL> select sql_id ,count(*) from gv$session where event='latch: cache buffers chains' group by sql_id;

SQL_ID          COUNT(*)
------------- ----------
1bwdphtn50h3c          1
6dhnxr55b9ca4          1
7gw9cf0rdjdmw        158
czv83dcd4akag          1
d1tuft7r11zrx          1
                       1

6 rows selected.

 

SQL> select sql_id ,count(*) from gv$session where event='gc cr request' group by sql_id;

SQL_ID          COUNT(*)
------------- ----------
5t82sc2xc20s9          1
5ux4yaahcjvy0          1
7gw9cf0rdjdmw        200
7thtt9by286zb          1
7wtw883trcfsb          1
ahxjfnc2brwj4          1
bd2dzz2c6nfzd          1
by4xzc1k285w5          1
c016c2xp7xzap          1
c6h5twm4ud2n8          1
d55w9vkpdn1n9          1
djy7dn5mw500f          1
ds1j8ba0kkkn8          1
dt4rqb36gbjb0          1
fanfpzv8q10vp          1

15 rows selected.

SQL> select to_char(sql_text) from v$sql where sql_id='7gw9cf0rdjdmw';

TO_CHAR(SQL_TEXT)
----------------------------------------------------------------------------------------------------------------------------------
SELECT T.DAYS_IN_TRANSIT FROM WIN_CARRIER_DAYS_TRANSIT_RNG T WHERE T.DISTRIBUTOR_ID = :B3 AND T.CARRIER_METHOD_ID = :B2 AND :B1 BE
TWEEN T.START_ZIP AND T.END_ZIP AND ROWNUM = 1