Oracle 11g R2 offers another new exciting ASM feature, Intelligent Data Placement (IDP) that enables you to denote disk regions on a bunch of ASM disks for improved performance. When the disk region settings are in place, you can improve I/O performance by placing the more frequently accessed files (data) on the outermost (HOT) tracks which will have greater speed and higher bandwidth. In addition, files that have similar access patterns are located closely to each other to reduce the latency. Moreover, IDP allows the placement of primary and mirror extents into different HOT or COLD regions. The IDP settings can be specified for a file or in disk group templates, which also can be modified after the disk group is created, provided that the COMPATIBLE.ASM
and COMPATIBLE.RDBMS
disk group attributes are set to 11.2 or higher.
IDP works best in the following circumstances:
When disk groups are more than 25% full
When database data files access at different...