Compact Most Needed Table Segments

Michael8773

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

John Thorton

https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN014

John Thorton

Michael8773 wrote: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.Show the results (via SQLPlus) of the above run job showing the owner and table_name to be compacted.Thanks,Michael

QUESTIONS?

I don't see any questions?

Post SQL that shows how you compact segments.

How do I ask a question on the forums?

Michael8773

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?

John Thorton

https://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN014