Other Data Layout Issues

To conclude the data layout discussion we examine symlinks, RAID performance with databases, and some of the pros and cons of Veritas and Solaris Volume Manager.

Database File Naming Using Symlinks

Whether raw devices or file system files are used for database files, it can prove inconvenient to move a file to a different location since file names are hardcoded at the time tablespaces are created. A simple and elegant solution to this problem is to create tablespaces using symlinks rather than direct file names.

For example, suppose the customer table consists of three database files placed on Veritas raw volumes: /dev/vx/rdsk/ourdata/vol23a, /dev/vx/rdsk/ourdata/vol34, and /dev/vx/rdsk/ourdata/vol16. Rather than hardcode ...

Get Configuring and Tuning Databases on the Solaris™ Platform now with the O’Reilly learning platform.

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