Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compact Most Needed Table Segments

Michael8773Dec 8 2017 — edited Dec 12 2017

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.

  1. 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?
  2. 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

This post has been answered by John Thorton on Dec 8 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2018
Added on Dec 8 2017
3 comments
146 views