tablespace autoextend on next size not obeyed
From: Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
Date: Thu, 17 Jun 2021 11:28:05 +0300
Message-ID: <CA+riqSUVZqzVWJtcyM_ULN4GEGXZ0_MV1-08eJqN8bwDW3C2Sw_at_mail.gmail.com>
Hello listers,
Date: Thu, 17 Jun 2021 11:28:05 +0300
Message-ID: <CA+riqSUVZqzVWJtcyM_ULN4GEGXZ0_MV1-08eJqN8bwDW3C2Sw_at_mail.gmail.com>
Hello listers,
Does anyone have experienced the behavior of big file tablespace resize operations in chunks of 64M with a very large number of resize operations? If yes, how did you mitigate this behavior?
I see some tablespaces being incremented with over 15k Resize operations of 64M in size but sometimes times defined size by autoextend on next (10G) is used.
The problem is the huge number of resize operations are replied in the standby database and looks to struggle to handle both redo apply and resize operations creating significant apply lag .
Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 17 2021 - 10:28:05 CEST