O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required