Questions related to alter table shrink cascade
1. Are there any situations where enabling row movement will not be advisable? We have a high transactional OLTP 800 GB database (10.2.0.4 version). I have recently started to administer it and is used by a third party vendor product.
2. How to tell if there are rowid based triggers on a table? I ran compact command on a table in one of the test databases and it right away disabled triggers on that table automatically. Is that normal behavior?
3. While shrink command is running, will there be any effect on performance of the database?
2. How to tell if there are rowid based triggers on a table? I ran compact command on a table in one of the test databases and it right away disabled triggers on that table automatically. Is that normal behavior?
3. While shrink command is running, will there be any effect on performance of the database?
4. If I cancel out of shrink command after say 1 hour, will the work done during that hour be repeated next time I issue the command on the same table again?
0