Question on Auto Stats gather
From: yudhi s <learnerdatabase99_at_gmail.com>
Date: Fri, 16 Sep 2022 17:28:41 +0530
Message-ID: <CAEzWdqe_qOXDUmgJEg0T3RzcJU7txa=7B_apmVsN28Sn-c1ptw_at_mail.gmail.com>
Hello , This is Oracle database version 19.15. I got a few answers from the internet but nothing clear on how gather_auto is different from auto stats. So want to know from experts on this
Date: Fri, 16 Sep 2022 17:28:41 +0530
Message-ID: <CAEzWdqe_qOXDUmgJEg0T3RzcJU7txa=7B_apmVsN28Sn-c1ptw_at_mail.gmail.com>
Hello , This is Oracle database version 19.15. I got a few answers from the internet but nothing clear on how gather_auto is different from auto stats. So want to know from experts on this
The question is regarding the automatic stats collection which runs
scheduled windows by oracle
1)Will it do the same thing or same object gathering, if we will gather
stats manually with option 'list/gather auto' for all the schema?
2)What is the difference between 'gather auto' and 'gather stale' then? Or
is it true that "gather auto"= "gather stale"+"gather empty"?
Regards
Yudhi
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 16 2022 - 13:58:41 CEST