Monitoring Extent Movement Progress

You may also like...

2 Responses

  1. Isaac Munoz Moreno says:

    Hi Mike,

    I’d like to share my experience: I have ran +5 “alter tablespace… reduce max” simultaneously without issues (i.e. slow performance, etc.) of course during low transactionality… one thing I’ve noticed is that if a backup (online) kicks off, it will pause the extent movement for the tablespace(s)… then you need to run the ALTER again after backup is complete.

    Regards

Leave a Reply

Your email address will not be published. Required fields are marked *