This is the dba_tables view, I believe, so you can't change the query itself. Check that you do not have statistics on any tables in the SYS schema -- use of the Cost-based Optimizer could produce performance problems on this type of view.