Hi,
Recently I faced a problem , my 9i database had a latch free wait event on statpack report

I found a SQL consume almost full of my shared pool

All of the hash value are same ,So I query v$sql_shared_cursor view to find out why

Then I got INST_DRTLD_MISMATCH column's value is Y which mens:

Insert direct load does not match the existing child cursor

the SQL is :

INSERT INTO FWCATNS_STG_SWIN@DEVFWCP (CONTROLLOT, SWIN, SWINDESCRIPTION, STAGE) SELECT TRIM(A.CONTROL), TRIM(SWINCODE), TRIM(SWINDESC), TRIM(SWINSTAGE) FROM FWCATNS_STG_CPSWIN_SAP A, (SELECT CONTROL, MAX(SAPTIMESTAMP) AS SAPTIMESTAMP FROM FWCATNS_STG_CPSWIN_SAP WHERE FLAG = 'M' GROUP BY CONTROL) B WHERE A.CONTROL = B.CONTROL AND A.SAPTIMESTAMP = B.SAPTIMESTAMP AND A.FLAG = 'M'


Then I got confused, there is no /*+appned*/ hint on it

after searched,I got no idea about that, please give me advise or direction



Thanks