Hi, What is version of the DB?. Given that WFCTOTAL is the biggest table in the SQL, how selective are the conditions? AND A7.NOTPAIDSW =0 AND A7.APPLYDTM >=A5.PPSTARTDATEDTM AND A7.APPLYDTM <=A5.PPENDDATEDTM if you are on 11gr1/11gr2, could you run this with a /*+MONITOR*/ hint and once the query is complete, from the same session could you spool and execute select dbms_sqltune.report_sql_monitor (session_id=>sys_context('userenv','sid'), report_level=>'ALL') as report from dual; and send the output? Best regards Sriram kumar -- //www.freelists.org/webpage/oracle-l