Could you please provide a sql query to find list of tables on which re-org is required. Specify space could be released by re-org operation.
This is typically a fool's errand. I'm sure you could find tables for which some space could be released back to the TS, but the next time you INSERT into the table (or even UPDATE resulting in growth of rows) you'll just have to go to the expense of re-acquiring that space. Does a retail store re-organize their shelves as stock is sold, just to re-organize again as new stock comes in to replenish that which was sold?
What is the real business problem you are trying to solve?