Administering Terabyte Tables - An Interview with Data Warehouse DBA Jim Dojonovic
Consider this to be yet another “Stop the Presses Blog”. I originally intended to discuss the different toolsets that DBAs can use to reclaim unused space allocated to Oracle objects. This installment was to be the follow-up to my previous blog on the Segment Analyzer. But we have hit an important milestone here at Giant Eagle, so I thought I would deviate from my intended topic for one blog.
If you have been following this series, you’ll know that my unit is responsible for administering several large data warehouses. The warehouse that we most recently converted to 10G has a single, partitoned table that has just grown to one terabyte in size. The entire database is multiple terabytes and rapidly growing at hundreds (and hundreds) of MEGs per month. We estimate that within 2 years, the database will be close to 10 terabytes in size. I thought it might be interesting to interview our “big data” DBA, Jim Dojonovic. Jim is responsible for administering our data warehouses.