Why does Oracle hang on "ALTER TABLE ADD ... NOT NULL"?
My case is similar, my talble has 3 million rows. It hangs about 2 hours and I abort it. 

I found  the reason is some other sessions lock this table. After I killed the sessions, It completes adding column in miliseconds.

I don't know why Oracle don't throw "resource busy" when adding column.