Finding stats gather
From: Pap <oracle.developer35_at_gmail.com>
Date: Tue, 12 Dec 2023 18:18:25 +0530
Message-ID: <CAEjw_fgc-MN=hzi_o6rnsgWmze5VArECfpKNi0mc0ZEYFcfX3w_at_mail.gmail.com>
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?
Date: Tue, 12 Dec 2023 18:18:25 +0530
Message-ID: <CAEjw_fgc-MN=hzi_o6rnsgWmze5VArECfpKNi0mc0ZEYFcfX3w_at_mail.gmail.com>
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-lReceived on Tue Dec 12 2023 - 13:48:25 CET