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

Hello,

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,
Sunny

Options: ReplyQuote




Sorry, only registered users may post in this forum.

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.