By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.