Forum Stats

  • 3,769,598 Users
  • 2,252,990 Discussions
  • 7,875,115 Comments

Discussions

Compact Most Needed Table Segments

Michael8773
Michael8773 Member Posts: 115 Red Ribbon
edited Dec 12, 2017 3:34PM in General Database Discussions

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

Tagged:

Best Answer

Answers

This discussion has been closed.