VIEW: SYS.DBA_TAB_STAT_PREFS

Source

View Text - Preformatted

select u.name, o.name, p.pname, p.valchar
from  sys.optstat_user_prefs$ p, obj$ o, user$ u
where p.obj#=o.obj#
  and u.user#=o.owner#
  and o.type#=2

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, P.PNAME
, P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P
, OBJ$ O
, USER$ U WHERE P.OBJ#=O.OBJ#
AND U.USER#=O.OWNER#
AND O.TYPE#=2