Instant DDL on ADD Column puts queries in opening tables state
Posted by: Sunny Nagra
Date: February 02, 2022 09:32AM


I am new to this forum and had a question.

I have a large-ish DB running on 8.0.27 and every time I try to add a column using the algorithm=instant option, queries that aren't even querying against the table being altered start to show up in 'opening tables' state.

This brings our site to a halt and have to wait until this is completed. I last ran an alter table on a 68G table and this brought our site down for at least 10 mins.

Can anyone point me the correct direction as to what would be causing this and how I can resolve this?

Kind regards,

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.