Re: ETL Query Performance Bad Only on Sundays
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 21 Feb 2018 19:42:36 +0300
Message-ID: <CAOVevU6rNHfzw5WAF+ehdiv96hmGsQkZ2OBmPYVVuoh+g3gb8A_at_mail.gmail.com>
Date: Wed, 21 Feb 2018 19:42:36 +0300
Message-ID: <CAOVevU6rNHfzw5WAF+ehdiv96hmGsQkZ2OBmPYVVuoh+g3gb8A_at_mail.gmail.com>
Hi Alfredo,
You can create SQL Profile with parameter force_match => true, in this case
oracle will use this sql profile for the queries with the
same FORCE_MATCHING_SIGNATURE.
You can use execute this script
https://github.com/xtender/xt_scripts/blob/master/profiles/create_sql_profile_lc.sql
and
input current SQL_ID.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 21 2018 - 17:42:36 CET