../E40402-16.epub /> ../E40402-16.mobi />

ALL_TAB_STAT_PREFS

ALL_TAB_STAT_PREFS displays information about statistics preferences for the tables accessible to the current user.

Related Views

  • DBA_TAB_STAT_PREFS displays information about statistics preferences for all tables in the database.

  • USER_TAB_STAT_PREFS displays information about statistics preferences for the tables owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the table
TABLE_NAME VARCHAR2(30) NOT NULL Name of the table
PREFERENCE_NAME VARCHAR2(30) NOT NULL Name of the preference
PREFERENCE_VALUE VARCHAR2(1000)   Value of the preference