By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
In the "old" days, let's say 20 years ago, it was necessary to have installed a REORGANIZING procedure, normally run at weekly intervals, to maintain the efficiency of the database in operational mode. Is this type of procedure not available anymore, or not needed, or is it totally part of Oracle's internals? Thank you very much for your support and consideration.
Oracle does not need any scheduled reorganizations like databases did many years ago. It used to be that data became fragmented and hampered application performance. Fragmentation in the database typically does not cause you problems in today's Oracle database. In fact, Oracle's Locally Managed Tablespaces forces segment fragmentation, all without affecting application performance.