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?
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-lReceived on Wed Feb 06 2013 - 07:04:13 CET