Oracle Database 11g DBA Handbook

CHAPTER 16Managing Large Databases

In Chapter 6, 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, I 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 they can be leveraged in a VLDB environment. Although these features surely provide ...