OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide

Using advanced tablespace management techniques

While the previous section covered the necessary basics for managing tablespaces, there are a few advanced topics that are important as well. While these techniques are not always needed in every database, they extend the basic functionality of Oracle space management in new and useful ways.

Using non-standard block size tablespaces

If we recall our earlier discussion of database block sizes, we presented a spectrum of block sizes and their applications. We said that certain types of databases can benefit from small block sizes, while others perform the best with larger sizes. While it is useful to be able to select from several different database block sizes when we create the database, the choice ...