Category Archives: Uncategorized

With tighter maintenance windows supporting 24/7 shops, online reorganization one of the few things a DBA can resort to migrate data between tablespaces, get rid of columns, split partitions and so on. So, online reorganization can be a great feature. … Continue reading →

I used to support a fraud system whose database size was about 10TB. From time to time, the system would face (for hours) severe latch: cache buffers chains contention. After some research – using scripts from blog.tanelpoder.com – I was able to … Continue reading →