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