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 we make leaves us with certain limitations. Let's say, for instance, that we have a database that stores relatively typical data that best fits into the hybrid database category. We can be generally satisfied with the choice of an 8K block size to...