Re: Query tuning help

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Wed, 6 Feb 2013 11:34:13 +0530
Message-ID: <CAEq4C0eZw0piY3pph77rFS=+11bBZm4BX58FQHNHdBA6HiEzsg_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 06 2013 - 07:04:13 CET