Re: Query tuning help
- From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- To: lambu999@xxxxxxxxx
- Date: Wed, 6 Feb 2013 11:34:13 +0530
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
Other related posts:
