The Importance of DBA_ROLLBACK_SEGS – 3 of 4

Does anyone notice a pattern here with the post titles?   Anyway, I was loading my priceless collection of Dilbert strips into my database when it crashed and burned: Trying to restart the database, my undo tablespace is gone: SQL> startup ORACLE instance started. Total System Global Area 2499805184 bytes Fixed Size 2927480 bytes Variable Size Read More »

Captain Smith’s Log

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 »