Re: DBA_HIST_SQLSTAT "oddity" - Executions & Executions_Delta = 0
From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Fri, 25 Jan 2013 10:24:20 +0530
Message-ID: <CAEq4C0cejGYfaV6Wi2BNqSdKR9yc8ttRbKtUDVmHn0ekJXvcQw_at_mail.gmail.com>
Hi chris,
if you know the sql_id of the statement. you could try
Date: Fri, 25 Jan 2013 10:24:20 +0530
Message-ID: <CAEq4C0cejGYfaV6Wi2BNqSdKR9yc8ttRbKtUDVmHn0ekJXvcQw_at_mail.gmail.com>
Hi chris,
if you know the sql_id of the statement. you could try
exec dbms_workload_repository.add_colored_sql('&sql_id');
to include the sql in awr (this setting over rides top_n setting)
best regards
sriram kumar
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 25 2013 - 05:54:20 CET