Hello,
There is so much stale and verbose info on the Internet on the topic of optimizing segments - I'm hoping you can clarify a few questions I have.
- In Oracle 12.2 what is the optimal way to manually run (via SQLPlus) the Oracle space adviser job that shows which tables have segments that need to be compacted?
- In Oracle 12.2 what is the optimal way to show the results (via SQLPlus) of the above run job showing the owner and table_name to be compacted?
Thanks,
Michael