Oracle Database 11g Release 2 adds intelligent data placement (IDP) support for JBOD (just a bunch of disks) configurations for ASM disk groups. IDP leverages geometry of disks and will place hot files on the outer most edge of the spindles and cold files in the inner rings of the drives. In addition, files that are accessed with similar patterns are placed close to each other to reduce latency.

IDP is supported by both ASM Configuration Assistant (ASMCA) and Enterprise Manager.

The outermost tracks provide greater speed and higher bandwidth. IDP works at disk group attribute level or at the file level and can be modified after the disk group is created. IDP is suited for situations where:
1. Disk groups that are > 25% full
2. Database datafiles are accessed at different rates
3. JBOD configurations – LUNs carved out of SANs are not suited for IDP

You can set IDP for only new files. Existing files must go through a rebalance operation to leverage IDP. In order to leverage IDP, both COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to a value of 11.2.0 or higher. IDP can be set with the following SQL syntax:

 
1.  ALTER DISKGROUP DATA ADD TEMPLATE
2.  ALTER DISKGROUP DATA MODIFY TEMPLATE
3.  ALTER DISKGROUP DATA MOFIFY FILE

For example:

alter diskgroup data add template hotfiles attributes (hot mirrorhot);

IDP information can be retrieved by querying V$ASM_DISK, V$ASM_DISK_IOSTAT, V$ASM_FILE and V$ASM_TEMPLATE views.

Columns from V$ASM_DISK that are of particular interest are:

 
 HOT_READS					    NUMBER
 HOT_WRITES					    NUMBER
 HOT_BYTES_READ 				    NUMBER
 HOT_BYTES_WRITTEN				    NUMBER
 COLD_READS					    NUMBER
 COLD_WRITES					    NUMBER
 COLD_BYTES_READ				    NUMBER
 COLD_BYTES_WRITTEN			    NUMBER
 HOT_USED_MB					    NUMBER
 COLD_USED_MB					    NUMBER

New columns in v$asm_template that apply to IDP are:

 
 PRIMARY_REGION 				    VARCHAR2(4)
 MIRROR_REGION				    VARCHAR2(4)

Posted by Charles Kim, Oracle ACE

Posted in ASM | Tagged
Share this post, let the world know

Leave a Reply

Your email address will not be published. Required fields are marked *

*