[PERFORM] Fragmentation/Vacuum, Analyze, Re-Index

[DM]

Hello All,

How to identify if a table requires full vacuum? How to identify when to do
re-index on an existing index of a table?

Is there any tool for the above?

Thanks
Deepak Murthy