?–
?–
?–
?–
?–
?–
?–
?–
?–
?–
?–
?–
CHAPTER
6
Monitoring Space Usage
163
164 Oracle Database 11g DBA Handbook
good DBA has a toolset in place to monitor the database, both proactively
monitoring various aspects of the database, such as transaction load, security
enforcement, space management, and performance monitoring, and effectively
reacting to any potentially disastrous system problems. Transaction management,
performance tuning, memory management, and database security and auditing are
covered in Chapters 7, 8, and 9. In this chapter, we??™ll address how a DBA can effectively and
efficiently manage the disk space used by database objects in the different types of tablespaces:
the SYSTEM tablespace, the SYSAUX tablespace, temporary tablespaces, undo tablespaces, and
tablespaces of different sizes.
To reduce the amount of time it takes to manages disk space, it is important for the DBA to
understand how the applications will be using the database as well as to provide guidance during the
design of the database application. Designing and implementing the database application, including
tablespace layouts and expected growth of the database, have been covered in Chapters 3, 4, and 5.
In this chapter, I??™ll also provide some scripts that need not much more than SQL*Plus and the
knowledge to interpret the results. These scripts are good for a quick look at the database??™s health
at a given point in time??”for example, to see if there is enough disk space to handle a big SQL*Loader
job that evening or to diagnose some response-time issues for queries that normally run quickly.
Pages:
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301