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.