CHAPTER4
Physical Database Layouts and Storage Management
Chapter 3 discussed the logical components of the database, tablespaces, and how to not only create the right number and types of tablespaces but also place table and index segments in the appropriate tablespace, based on their usage patterns and function. In this chapter, I’ll focus more on the physical aspects of a database, the datafiles, and where to store them to maximize I/O throughput and overall database performance.
The assumption throughout this chapter is that you are using locally managed tablespaces with automatic segment space management. In addition to reducing the load ...
Get Oracle Database 12c 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.
