< Previous  | TOC | Index | Next  >

Accessing dynamic performance views

 To access dynamic performance views

1. Confirm that the Veritas mapping library for Oracle file mapping has been enabled.

   SQL> select lib_idx idx, lib_name name, vendor_name vname, \

   path_name path from v$map_library;

   IDX NAME VNAME PATH

   ---------------------------------------------------------------

2. Veritas ORAMAP API Veritas /opt/VRTSdbed/lib/libvxoramap_64.so After storage mapping has been enabled, Oracle datafiles can be mapped using the DBMS_STORAGE_MAP package.

   The following example shows how to map a datafile using SQL:

   SQL> execute dbms_storage_map.map_file('/oradata/system01.dbf','DATAFILE', TRUE);

   For more information about various features and capabilities of the DBMS_STORAGE_MAP package, see your Oracle documentation.

3. Use SQL commands to display the mapping information that is captured in Oracle's dynamic performance views.

   To display the contents of v$map_file for a Quick I/O file:

   SQL> select file_name name, file_map_idx idx, \

   file_status status, file_type type, file_structure str, \

   file_size fsize, file_nexts nexts from v$map_file;

NAME IDX STATUS TYPE STR FSIZE NEXTS

---------------------------------------------------------------------------

/oradata/system01.dbf 0 VALID DATAFILE FILE 512008 2

To display the contents of v$map_file_extent.

SQL> select * from v$map_file_extent;

FILE_MAP_IDX EXT_NUM EXT_ELEM_OFF EXT_SIZE EXT_FILE_OFF EXT_TY ELEM_IDX

--------------------------------------------------------------------------------------

0 0 11534336 512000 0 DATA 0

0 1 36504 8 512000 DATA 0

To display the contents of v$map_element:

SQL> select elem_idx idx, elem_name, elem_type type, elem_size, \

elem_nsubelem nsub, elem_descr, stripe_size from \

v$map_element;

IDX ELEM_NAME TYPE ELEM_SIZE NSUB ELEM_DESCR

--------------------------------------------------------------------------------------

0 /dev/vx/rdsk/ramdg/oradata MIRROR 12582912 1 MIRROR

1 vxvm:ramdg/oradata-01 STRIPE 12582912 2 STRIPE

2 /dev/vx/rdmp/EMC0_16 PARTITION 17846400 2 HOST DEVICE

3 /dev/rhdisk13 MIRROR 17846400 2 MIRROR

4 EMC000184502242:02:0c:01 DISK 1.43E+08 0 DISK

5 EMC000184502242:31:0c:01 DISK 1.43E+08 0 DISK

6 /dev/rhdisk41 MIRROR 17846400 2 MIRROR

7 /dev/vx/rdmp/EMC0_12 PARTITION 17846400 2 HOST DEVICE

8 /dev/rhdisk14 MIRROR 17846400 2 MIRROR

9 EMC000184502242:01:0d:01 DISK 1.43E+08 0 DISK

10 EMC000184502242:32:0d:01 DISK 1.43E+08 0 DISK

11 /dev/rhdisk42 MIRROR 17846400 2 MIRROR

To display the contents of v$map_subelement:

SQL> select * from v$map_subelement;

CHILD_IDX PARENT_IDX SUB_NUM SUB_SIZE ELEM_OFFSET SUB_FLAGS

--------- ---------- -------- -------- ----------- ---------

1 0 0 12582912 0 0

2 1 0 6291456 0 0

7 1 1 6291456 0 0

3 2 0 17846400 0 0

6 2 1 17846400 0 0

4 3 0 1.43E+08 0 0

5 3 1 1.43E+08 0 0

4 6 0 1.43E+08 0 0

5 6 1 1.43E+08 0 0

8 7 0 17846400 0 0

11 7 1 17846400 0 0

9 8 0 1.43E+08 0 0

10 8 1 1.43E+08 0 0

9 11 0 1.43E+08 0 0

10 11 1 1.43E+08 0 0

To display all the elements within the I/O stack for a specific file.

SQL> with fv as

2 (select file_map_idx, file_name from v$map_file

3 where file_name = '/oradata/system01.dbf')

4 select

5 fv.file_name, lpad(' ', 4 * (level - 1)) || \

el.elem_name elem_name, el.elem_size, el.elem_type, \

el.elem_descr

6 from

7 v$map_subelement sb, v$map_element el, fv,

8 (select unique elem_idx from v$map_file_io_stack io, fv

where io.file_map_idx = fv.file_map_idx) fs

10 where el.elem_idx = sb.child_idx

11 and fs.elem_idx = el.elem_idx

12 start with sb.parent_idx in

13 (select distinct elem_idx

14 from v$map_file_extent fe, fv

15 where fv.file_map_idx = fe.file_map_idx)

16 connect by prior sb.child_idx = sb.parent_idx;

FILE_NAME ELEM_NAME ELEM_SIZE ELEM_TYPE ELEM_DESCR

--------------------------------------------------------------------------------------

/oradata/system01.dbf vxvm:ramdg/oradata-01 12582912 STRIPE STRIPE

/oradata/system01.dbf /dev/vx/rdmp/EMC0_16 17846400 PARTITION HOST DEVICE

/oradata/system01.dbf /dev/rhdisk13 17846400 MIRROR MIRROR

/oradata/system01.dbf EMC000184502242:02:0c:01 1.43E+08 DISK DISK

/oradata/system01.dbf EMC000184502242:31:0c:01 1.43E+08 DISK DISK

/oradata/system01.dbf /dev/vx/rdmp/EMC0_12 17846400 PARTITION HOST DEVICE

/oradata/system01.dbf /dev/rhdisk14 17846400 MIRROR MIRROR

/oradata/system01.dbf EMC000184502242:01:0d:01 1.43E+08 DISK DISK

/oradata/system01.dbf EMC000184502242:32:0d:01 1.43E+08 DISK DISK