RE: Drawing a blank and can't find a quick answer - view for incremental stats enabled tables?
Date: Wed, 21 Mar 2018 15:31:26 +0000
Message-ID: <196DB2D4BDE5804EAF3158CCC1C698BC92A925B3_at_lopez.pti-nps.com>
Use the DBMS_STATS function against DBA_TAB_PARTITIONS, like this…
COL TABLE_OWNER FORMAT A10
COL TABLE_NAME FORMAT A30
COL INCREMENTAL FORMAT A10
SELECT DISTINCT TABLE_OWNER,
TABLE_NAME, DBMS_STATS.GET_PREFS('INCREMENTAL',TABLE_OWNER, TABLE_NAME) AS INCREMENTALFROM DBA_TAB_PARTITIONS
WHERE TABLE_OWNER IN ('<SCHEMS_YOU_CARE_ABOUT>') ORDER BY 1,2
;
HTH,
T. J.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Taylor Sent: Wednesday, March 21, 2018 9:59 AM To: ORACLE-L <oracle-l_at_freelists.org> 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:
But I can't find it - we're on 12.1.0.2.
Thanks,
DBMS_STATS.get_prefs and pass in the table table and owner but surely there's a view that I can query?
Chris
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 21 2018 - 16:31:26 CET