Shrink FND_LOBS table during production operation
Should I attempt to shrink FND_LOBS table during production operations (24X7) when least activities present?
Will it lock records for POs, GL JE, Invoices, etc.? This operation is estimated to take many hours.
Will it impact performance significantly?
Any throughts on other methods to shrink this historical very large table or optimize it from storage and performance prespective?
The commands:
alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space) enable row movement;
alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space cascade);
alter table applsys.fnd_lobs modify lob (FILE_DATA) (shrink space compact cascade);