Information about Intelligent Data Placement is displayed in the columns of the V$ASM_DISK, V$ASM_DISK_IOSTAT, V$ASM_FILE, and V$ASM_TEMPLATE views.
Example 6-9 shows queries for Intelligent Data Placement information in the PRIMARY_REGION and MIRROR_REGION columns of the V$ASM_FILE view.
Example 6-10 displays Intelligent Data Placement information in the PRIMARY_REGION and MIRROR_REGION columns of the V$ASM_TEMPLATE view.
For information about setting Intelligent Data Placement, see "Intelligent Data Placement".
Example 6-9 Viewing Intelligent Data Placement information with V$ASM_FILE
SELECT dg.name AS diskgroup, f.file_number, f.primary_region, f.mirror_region, f.hot_reads,
f.hot_writes, f.cold_reads, f.cold_writes
FROM V$ASM_DISKGROUP dg, V$ASM_FILE f
WHERE dg.group_number = f.group_number and dg.name = 'DATA';
DISKGROUP FILE_NUMBER PRIM MIRR HOT_READS HOT_WRITES COLD_READS COLD_WRITES
-------------------- ----------- ---- ---- ---------- ---------- ---------- -----------
DATA 257 COLD COLD 0 0 119770 886575
DATA 258 COLD COLD 0 0 1396 222282
DATA 259 COLD COLD 0 0 2056 199
DATA 260 COLD COLD 0 0 42377 1331016
DATA 261 COLD COLD 0 0 4336300 1331027
...
Example 6-10 Viewing Intelligent Data Placement information with V$ASM_TEMPLATE
SELECT dg.name AS diskgroup, t.name, t.stripe, t.redundancy, t.primary_region, t.mirror_region
FROM V$ASM_DISKGROUP dg, V$ASM_TEMPLATE t
WHERE dg.group_number = t.group_number and dg.name = 'DATA' ORDER BY t.name;
DISKGROUP NAME STRIPE REDUND PRIM MIRR
------------------------------ ------------------------------ ------ ------ ---- ----
DATA ARCHIVELOG COARSE MIRROR COLD COLD
DATA ASMPARAMETERFILE COARSE MIRROR COLD COLD
DATA AUDIT_SPILLFILES COARSE MIRROR COLD COLD
DATA AUTOBACKUP COARSE MIRROR COLD COLD
DATA AUTOLOGIN_KEY_STORE COARSE MIRROR COLD COLD
DATA BACKUPSET COARSE MIRROR COLD COLD
DATA CHANGETRACKING COARSE MIRROR COLD COLD
DATA CONTROLFILE FINE HIGH COLD COLD
DATA DATAFILE COARSE MIRROR COLD COLD
DATA DATAGUARDCONFIG COARSE MIRROR COLD COLD
DATA DUMPSET COARSE MIRROR COLD COLD
DATA FLASHBACK COARSE MIRROR COLD COLD
DATA FLASHFILE COARSE MIRROR COLD COLD
DATA INCR XTRANSPORT BACKUPSET COARSE MIRROR COLD COLD
DATA KEY_STORE COARSE MIRROR COLD COLD
DATA OCRFILE COARSE MIRROR COLD COLD
DATA ONLINELOG COARSE MIRROR COLD COLD
DATA PARAMETERFILE COARSE MIRROR COLD COLD
DATA TEMPFILE COARSE MIRROR COLD COLD
DATA VOTINGFILE COARSE MIRROR COLD COLD
DATA XTRANSPORT COARSE MIRROR COLD COLD
DATA XTRANSPORT BACKUPSET COARSE MIRROR COLD COLD
22 rows selected.