Shrink table space strategy
Date: Sun, 2 Jan 2022 23:11:16 -0300
Message-ID: <CAJdDhaNposG+XGVnWq3VGu29CMmdFS-35Fj9ASq4pRVBszd70A_at_mail.gmail.com>
Hello,
I have big tables with millions of lines in the production environment ...
We have a request to delete old data in these tables. The filter will be
defined by the business rules, considering data and some status ...
Partition is an option but not at this moment. Business rules are complex
to define the best partition and tables are too many (+-150).
Considering that shrink table causes lock in the table, what is the best
strategy :
a.) delete a lot of lines, rebuild indexes (the maximum is possible) and
execute shrink a few times
I did not find how to execute the shrink online without lock.
Regards
b.) delete few lines and execute shrink many times and rebuild indexes few
times.
c.) are there other ways to do it ???
Eriovaldo
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jan 03 2022 - 03:11:16 CET