1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_PART_COL_STATISTICS to DATABASE_PROPERTIES
  4. ALL_TAB_STAT_PREFS

3.116 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(128)

NOT NULL

Owner of the table

TABLE_NAME

VARCHAR2(128)

NOT NULL

Name of the table

PREFERENCE_NAME

VARCHAR2(30)

Name of the preference

PREFERENCE_VALUE

VARCHAR2(4000)

Value of the preference

See Also: