Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Adding column to ORACLE table taking ages

user5716448Feb 28 2022

Hi,

Version 11.2.0.3

32 million row table

issuing command

alter table <table_name> add <column> nvarchar2(50);

been running over 15 minutes.

How can we check how far progressed not seeing anything in v$session_longops

How can we speed this up?

What causes this - other tables far quicker to add columns to.?

Thanks

Comments
Post Details
Added on Feb 28 2022
7 comments
438 views