We are planning to run the following space management command:
alter table XXX shrink space cascade
on a production database (Oracle 10g). The
XXX table is a transactional table heavily used for updates/inserts/deletes by many applications.
I am wondering if running the
shrink command during the peak time (online) will cause a severe performance degradation, or may lock the table and so block all the applications?
Can you clarify the impact of the
shrink command on the access to the databese table