Data Layout Recommendations

Effective data layout does not come for free; planning and discipline are required. The benefits far outweigh the cost, though. A carefully planned data layout strategy is easier to understand and maintain and can avert performance bottlenecks.

The Beauty of Simplicity

I remember on one occasion spending time with a user, tracking down a performance problem. The database in question used no more than 30 disks, yet we spent well over an hour trying to figure out which physical devices were associated with the small number of logical devices used by the database. I was astonished at the mazelike ingenuity with which logical volumes had been created, with a combination of Veritas, symlinks, and automounts. The performance ...

Get Configuring and Tuning Databases on the Solaris™ Platform 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.