Re: Finding stats gather

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 12 Dec 2023 19:05:20 +0100 (CET)
Message-ID: <1901730334.2076893.1702404320469_at_ox.hosteurope.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: _at_OracleSK

> Pap <oracle.developer35_at_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

Received on Tue Dec 12 2023 - 19:05:20 CET

This message: [ Message body ]
Next message: Pap: "Re: Finding stats gather"
Previous message: Amit Saroha: "Re: ORA-600"
In reply to Pap: "Finding stats gather"
Next in thread: Pap: "Re: Finding stats gather"
Reply: Pap: "Re: Finding stats gather"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message