CHAPTER 17 Managing Large Databases

In Chapter 6, “Monitoring Space Usage,” we talked about bigfile tablespaces and how they not only allow the total size of the database to be much larger than in previous versions of Oracle, but also ease administration by moving the maintenance point from the datafile to the tablespace.

In Chapter 4, “Physical Database Layouts and Storage Management,” we presented an overview of Automatic Storage Management (ASM) and how it can ease administration, enhance performance, and improve availability. The DBA can add one or more disk volumes to a rapidly growing VLDB (Very Large Database) without bringing down the instance.

In this chapter, we’ll revisit many of these database features, but with an emphasis on how ...

Get Oracle Database 10g DBA 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.