Simple operations on Columns hanging Database:-10.2.0.3
Hi All,
While I am performing simple operations like ,
ALTER TABLE table_name ADD column_name datatype;
ALTER TABLE table_name DROP COLUMN column_name;
ALTER TABLE tablename SET UNUSED COLUMN column_name;
Such operations are hanging for hours......
But if I bounce the database this operations are completing quite easily.
But as it is a production I can not bounce it so frequently.
I also observed that there are no locked objects.
Please Help me......
Thanks.