rman hanging, temp tablespace issues

[ebrian]

You could try to perform the following:

SQL> exec dbms_stats.gather_fixed_objects_stats;