Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 21 Mar 2018 09:58:52 -0500
Message-ID: <CAP79kiQwR0576eFnQtXUs2y6D1eKkW4uCG_Y3rcYhe7fgYBpsA_at_mail.gmail.com>
Is there a system view that shows which tables INCREMENTAL stats have been setup on?
Date: Wed, 21 Mar 2018 09:58:52 -0500
Message-ID: <CAP79kiQwR0576eFnQtXUs2y6D1eKkW4uCG_Y3rcYhe7fgYBpsA_at_mail.gmail.com>
Is there a system view that shows which tables INCREMENTAL stats have been setup on?
I know I can do:
DBMS_STATS.get_prefs and pass in the table table and owner but surely
there's a view that I can query?
But I can't find it - we're on 12.1.0.2.
Thanks,
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 21 2018 - 15:58:52 CET