Originally posted by ashley75
thanks jeff,

question is "is that true dbms_stats.gather_database_stats will collect stat on SYS???"
All you need to find this out is to check DBA_TABLES (or DBA_INDESES etc etc) for any of the segments owned by SYS. If you find statistical information for them there (for example number of rows for tables or number of keys for indexes) then it apparently collects statistics for SYS objects....