Improving the performance of single instance Oracle on file systems, January 2008

17
This provided a workaround to a problem on 11i v2 where it takes a long time for Oracle processes
to attach to the database.
8
This workaround is not needed on 11i v3.
For the Online JFS configurations, an 8 K block size was chosen and mounted on the logical volumes.
Test method
To help to ensure consistency of results, different workloads were used in increments of 20 clients and
each data point was repeated. A driver automation program was written to ease the collection of this
data and reduce the chance of user errors that might affect the results.
An excerpt of the automation program is shown in Figure B-1 with a description of the related
functions.
8
This problem is caused by a side-effect of a fix for another issue that was implemented in patch PHKL_33364 on 11.23 to avoid a memory race
condition. The effect forces each Oracle process to lock each page of the SGA. Setting bit 8 of the device driver minor number defers memory
locking until actual IO takes place on a page.