Applying Other Tuning Tips
This section presents a number of miscellaneous tuning tips related to file systems, load and index performance, and relinking of the oracle binary to allow shared memory segments larger than 2 Gbytes in size.
Using Oracle with File Systems
The issues associated with using database files on file systems are discussed elsewhere in this book:
“Unix File System Enhancements” on page 21 outlines the enhancements made in Solaris to improve UFS database performance.
“Raw Devices vs. UFS” on page 242 discusses the performance implications of UFS.
“UFS Files and Paging” on page 284 explores UFS files in the context of system monitoring.
The bottom line is that if you decide to place your data files on UFS, use Direct I/O as ...
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.