Re: Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?
From: Powell, Mark <mark.powell2_at_dxc.com>
Date: Wed, 21 Mar 2018 18:25:27 +0000
Message-ID: <CS1PR8401MB0743949CFE272EC14A91A055CCAA0_at_CS1PR8401MB0743.NAMPRD84.PROD.OUTLOOK.COM>
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: Wednesday, March 21, 2018 10:58 AM To: ORACLE-L
Subject: Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?
Date: Wed, 21 Mar 2018 18:25:27 +0000
Message-ID: <CS1PR8401MB0743949CFE272EC14A91A055CCAA0_at_CS1PR8401MB0743.NAMPRD84.PROD.OUTLOOK.COM>
Try dba_tab_stat_prefs
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: Wednesday, March 21, 2018 10:58 AM To: ORACLE-L
Subject: Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?
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 - 19:25:27 CET