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 live online training, plus books, videos, and digital content from nearly 200 publishers.