- Data files that are accessed at different rates
- Disk groups more than 25% full
- Disks with the geometry exposed to ASM (JBOD)
- COMPATIBLE.ASM = 11.2.0 or higher
- COMPATIBLE.RDBMS = 11.2.0 or higher
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
/mirrorcold
regions in a templateAlter 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