Updating the statistics on these tables for the optimizer may have major benefits in some cases. The cost of the update is trivial (a couple of seconds or less), and the savings can be substantial. This could be useful in environment where you have dozens to hundreds of cubes being updated at random points in the day.

create or replace PROCEDURE gather_olap_stats IS
BEGIN
dbms_stats.gather_table_stats('sys','aw_prop$',cascade=>true);
dbms_stats.gather_table_stats('sys','aw$',cascade=>true);
dbms_stats.gather_table_stats('sys','aw_obj$',cascade=>true);
dbms_stats.gather_table_stats('sys','ps$',cascade=>true);
END;
/