SELECT /*+ PARALLEL(S,8) PARALLEL(Q,8) */
DISTINCT T.LOG_IO, T.PHY_IO ,T.CR_GET
,S.*
FROM GV$SQL Q
,GV$SESSION S
,GV$TRANSACTION T
WHERE S.SQL_ID = Q.SQL_ID
AND S.INST_ID = Q.INST_ID
AND SQL_TEXT LIKE '%INTO IDBADM.ODS_RT_TC_LCDR_DTL X%'
AND SQL_TEXT NOT LIKE '%GV$%'
AND S.SADDR = T.SES_ADDR(+)
AND S.INST_ID = T.INST_ID(+)
ORDER BY S.OWNERID DESC
,S.SID
;