How to avoide Tablespace fragmentation

In previuos post we disscused how to find tablespace frgmantation.Here we will disscus how to avoide table fragmentation in oracle. Once we identify tablespace fragmentation , what do you do about it?  Honeycomb fragmentation is easy to fix.  All that needs to be done is to combine adjacent free segments into one by issuing a coalesce  statement: [...]

Read Full Post »

The possible causes for Excessive Undo generation

1)Transactions with huge undo. ——————————- It is obvious to see high undo usage when there are huge transactions. If that is going to be the case this growth should be expected behavior. 2)The Higher value setting of UNDO_RETENTION. ———————————————— The higher value of UNDO_RETENTION will increase much undo. As it can’t be marked undo extents [...]

Read Full Post »