Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Query to list the Tables for which STALE_PERCENT is different than the global value.

Veera_VJul 18 2017 — edited Jul 19 2017

Hi,

DB Version: 12c R1

Using below we can identify the STALE_PERCENT for a specific table.

SELECT DBMS_STATS.GET_PREFS('STALE_PERCENT', 'XXSCHEMAXX', 'XXTABLEXX')  -> eg: 3, table level

Using below we can identify the default STALE_PERCENT value in DB level.

SELECT DBMS_STATS.GET_PREFS('STALE_PERCENT') FROM dual; -> eg: 10 default , database level

Is there anyway to list all the tables having STALE_PERCENT value is different than the default value set in DB level.

Thanks in advance.

-Veera
This post has been answered by Mark D Powell on Jul 18 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2017
Added on Jul 18 2017
#general-database-discussions
6 comments
2,522 views