Examining Tablespace Usage and Projections
Probably the least disputed purely DBA job function is database space management, meaning the creation, monitoring, and overall administration of tablespaces and their associated data files. Even “do it all” consultants and senior developers who perform DBA tasks prefer to leave space management to someone else. One reason is that space has a tendency to reach some threshold or limit during normal sleeping hours, when batch jobs execute and pagers going off irritate spouses the most. Welcome to the world of production support!
Thus many DBAs performing database space management generally attempt to fulfill two goals. First, to avoid short-term space issues such as failure to allocate an extent for any ...
Get TOAD® Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
