Name: dbInternals
Telephone: +

The importance of DBA_ROLLBACK_SEGS – 1 of 2

September 3, 2020 Backup Recovery

Unless you have been a DBA for more than 10 years, you might not have even heard of DBA_ROLLBACK_SEGS. Back in the days of Oracle6 and Oracle7, when there was no Interwebs and every kid had to walk to school uphill both ways in the snow, Oracle had rollback segments. Before we had undo tablespaces, Read More »

Captain Smith’s Log

September 3, 2020 Backup Recovery

Everyone knows the story of the Titanic. She hit an iceberg on her maiden voyage which ruptured 5 of her 16 watertight compartments. Like a RAID array, her hull was designed with redundancy in mind, and could afford the failure of up to 4 of the compartments. Unfortunately the collision damaged the 5 forward compartments, Read More »

Menu

09/03/2020

The importance of DBA_ROLLBACK_SEGS – 1 of 2

Captain Smith’s Log