Date: Tue, 12 Dec 2023 19:05:20 +0100 (CET)
From: Stefan Koehler <contact@soocs.de>
To: oracle.developer35@gmail.com, Oracle L <oracle-l@freelists.org>
Message-ID: <1901730334.2076893.1702404320469@ox.hosteurope.de>
In-Reply-To: <CAEjw_fgc-MN=hzi_o6rnsgWmze5VArECfpKNi0mc0ZEYFcfX3w@mail.gmail.com>
References: <CAEjw_fgc-MN=hzi_o6rnsgWmze5VArECfpKNi0mc0ZEYFcfX3w@mail.gmail.com>
Subject: Re: Finding stats gather
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: contact@soocs.de

Hello Pap,
I guess the easiest way would be to audit DBMS_STATS usage for a short period of time.

-- Set audit_trail to "db,extended", if not already done
SQL> alter system set audit_trail=db,extended scope=spfile;
-- Restart database (only needed, if audit_trail needs to be set)
SQL> audit execute on sys.dbms_stats;
SQL> select * from dba_audit_object where obj_name = 'DBMS_STATS';


Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher
Website: www.soocs.de
Twitter: @OracleSK

> Pap <oracle.developer35@gmail.com> hat am 12.12.2023 13:48 CET geschrieben:
> 
> 
> Hi All,
> We have a customer database in which restore_table_stats gets triggered(as we see it from dba_optstat_operations) and we want to find where exactly it's getting triggered from. Basically the source(which might be app code) of this command. We don't see it in gv$sql or dba_hist_sqltext and can't tie it up with ASH/AWR views. Is there any way to find this out?
> 
> 
> Regards
> Pap
--
http://www.freelists.org/webpage/oracle-l