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!

Alter table modify very slow

Mr.D.Mar 7 2014 — edited Mar 18 2014

Hi,

i'm trying to modify a semantic of a column in a table.

ALTER TABLE MYTAB MODIFY (MYCOL VARCHAR2(100 CHAR));

This command produce db file sequential read wait event and it's very very slow.

On some other table it performs a scattered read.

I'm in 11.2.0.3 EE on Linux 64bit

How can i avoid db file sequential read wait event?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 15 2014

Added on Mar 7 2014

#general-database-discussions, #oracle, #table

7 comments

890 views