Oracle - createview.dms - Creating Views never error's and taking long time

1. Add _optimizer_cost_based_transformation=off to the init.ora file
2  Make sure that the posted recommended init.ora parameters for Oracle 11g are in place:

_gby_hash_aggregation_enabled=false

_unnest_subquery = false

3. Stop and then restart the database.
4. Rerun createview.dms and report the total time.