Showing posts from October, 2023
ORA-08104: this index object 530080 is being online built or rebuilt Issue :- while dropping an index the following error thrown drop index inx_lltoftthflgfeas; ORA-08104: this index object 530080 is being online built or rebuilt Reason A process…
When and How to rebuild indexes in Oracle Why to Rebuild index? • Every so often, we need to rebuild indexes in Oracle, because indexes become fragmented over time. • This causes their performance that of your database queries, to d…
How to monitor the unused indexes in Oracle • Keeping a lot of indexes on a table, can affect the performance of the transaction like insert, update, delete on the table. • if we are inserting a new ROW, a new entry will be added to …
