Use Intelligent Data Placement

Intelligent Data Placement works best for: 
  • Data files that are accessed at different rates
  • Disk groups more than 25% full
  • Disks with the geometry exposed to ASM (JBOD)
Intelligent Data Placement requires disk group attributes. 
  • COMPATIBLE.ASM = 11.2.0 or higher
  • COMPATIBLE.RDBMS = 11.2.0 or higher
Alter Diskgroup Template
ALTER DISKGROUP data ADD TEMPLATE datafile_hot
  ATTRIBUTE ( 
    HOT
    MIRRORHOT);
note: The ALTER DISKGROUP TEMPLATE SQL statement includes a disk region clause for setting hot/mirrorhot or cold/mirrorcoldregions in a template

Alter Diskgroup Modified File
ALTER DISKGROUP data MODIFY FILE '+data/orcl/datafile/users.259.679156903'
  ATTRIBUTE ( 
    HOT
    MIRRORHOT);

 IDP information can be retrieved by querying 
V$ASM_DISK 
V$ASM_DISK_IOSTAT 
V$ASM_FILE  
V$ASM_TEMPLATE
on columns 
hot_reads
hot_writes
hot_bytes_read
hot_bytes_written
cold_reads
cold_writes
cold_bytes_read
cold_bytes_written
AWR
V$FILEMETRIC 
V$FILEMETRIC_HISTORY
Posted by