Chapter 22. Advanced IO Techniques

In this chapter we build on the IO tuning fundamentals of the last chapter and consider some specific technologies and IO optimizations.

Oracle’s Automatic Storage Management (ASM) provides a storage management layer tightly integrated with the Oracle software stack. DBAs can use ASM to implement striping, mirroring, and load balancing on top of directly attached vanilla disks or on logical disks exposed by a storage array. ASM can be used to implement many of the optimizations discussed in the previous chapter, and offers unique monitoring and tuning opportunities.

Spinning magnetic disk devices continue to be the basis for the vast majority of database storage. However, Solid State Disk (SSD) is becoming ...

Get Oracle now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.