Using Views to Display Oracle ACFS Information
Views Containing Oracle ACFS Information
包含Oracle ACFS信息的视图
您可以使用表12-1中的视图来获取关于Oracle自动存储管理集群文件系统(Oracle ACFS)的信息。这些视图可以从Oracle ASM实例中访问。
注意:
要显示位于Oracle Flex ASM配置节点上的Oracle ACFS文件系统或卷的信息，必须连接到Oracle ASM代理实例，而不是本地的Oracle ASM实例。
在Windows系统上查看Oracle ACFS视图中的空间使用值时，这些值可能与Windows文件夹中的大小不同。Windows系统中文件夹属性所使用的机制只针对文件，应该将其视为一个近似值。
Oracle ASM dynamic views for Oracle ACFS information
| View | Description |
|---|---|
|
Contains encryption information for each Oracle ACFS file system. 包含每个Oracle ACFS文件系统的加密信息。 |
|
|
Contains security realm information for each Oracle ACFS file system. 包含每个Oracle ACFS文件系统的安全域信息。 |
|
|
Contains information about Oracle ACFS security administrator in the cluster. 包含关于集群中Oracle ACFS安全管理员的信息。
|
|
|
Contains information about Oracle ACFS security command rules for each Oracle ACFS file system. 包含关于每个Oracle ACFS文件系统的Oracle ACFS安全命令规则的信息。 |
|
|
Contains information about every realm in the Oracle ACFS security realm for each Oracle ACFS file system.
|
|
|
Contains information about every filter in the Oracle ACFS security realm for each Oracle ACFS file system. A filter is a defined as
|
|
|
Contains information about every group in the Oracle ACFS security realm for each Oracle ACFS file system. 包含关于每个Oracle ACFS文件系统的Oracle ACFS安全域中的每个组的信息。 |
|
|
Contains information about every user in the Oracle ACFS security realm for each Oracle ACFS file system.
|
|
|
Contains information about every Oracle ACFS security rule for each Oracle ACFS file system. 包含关于每个Oracle ACFS文件系统的每个Oracle ACFS安全规则的信息。 |
|
|
Contains information about every Oracle ACFS security ruleset for each Oracle ACFS file system.
|
|
|
Contains information about every rule in Oracle ACFS security ruleset for each Oracle ACFS file system.
|
|
|
Contains information for Oracle ACFS file systems that are initialized for replication. This view only contains records for Oracle ASM releases prior to 12.2. To display Oracle ACFS replication information for Oracle ASM releases 12.2 or higher, use the 包含为复制而初始化的Oracle ACFS文件系统的信息。
这个视图只包含12.2之前的ASM版本的记录。若要显示Oracle ACFS 12.2或更高版本的Oracle ACFS复制信息，请使用acfsutil repl命令。 |
|
|
Contains replicated tag information for Oracle ACFS file systems that are initialized for replication. This view only contains records for Oracle ASM releases prior to 12.2. To display Oracle ACFS replication information for Oracle ASM releases 12.2 or higher, use the 包含为复制而初始化的Oracle ACFS文件系统的复制标记信息。 这个视图只包含12.2之前的ASM版本的记录。若要显示Oracle ACFS 12.2或更高版本的Oracle ACFS复制信息，请使用acfsutil repl命令。 |
|
|
Contains snapshot information about every mounted Oracle ACFS file system.
|
|
|
Contains all tag name information about files on all mounted Oracle ACFS file systems 包含所有挂载的Oracle ACFS文件系统上有关文件的所有标记名信息 |
|
|
Contains information about mounted Oracle ADVM volumes, correlated with 包含有关已挂载的Oracle ADVM卷的信息，这些卷与V$ASM_FILESYSTEM相关。 |
|
|
Contains information about every mounted Oracle ACFS file system. 包含关于每个已挂载的Oracle ACFS文件系统的信息。 |
|
|
Contains information about each Oracle ADVM volume that is a member of an Oracle ASM instance. 包含关于Oracle ASM实例成员的每个Oracle ADVM卷的信息。 |
|
|
Contains information about statistics for each Oracle ADVM volume. 包含每个Oracle ADVM卷的统计信息。 |
Viewing encryption information in V$ASM_ACFS_ENCRYPTION_INFO
查看V$ASM_ACFS_ENCRYPTION_INFO中的加密信息
这个例子显示了来自V$ASM_ACFS_ENCRYPTION_INFO视图的信息。FS_NAME列包含挂载点。VOL_DEVICE包含Oracle ADVM设备的名称。
SELECT SUBSTR(fs_name,1,24) FILESYSTEM, SUBSTR(vol_device,1,20) DEVICE, enabled_status FROM V$ASM_ACFS_SECURITY_INFO; FILESYSTEM DEVICE PREPARE ENABLED_ ------------------------- ---------------------- ------- -------- /acfsmounts/acfs1 /dev/asm/volume1-228 YES ENABLED
Example 12-2 Viewing security information in V$ASM_ACFS_SECURITY_INFO
This example shows information displayed from the V$ASM_ACFS_SECURITY_INFO view. The FS_NAME column contains the mount point. The VOL_DEVICE contains the name of the Oracle ADVM device.
SELECT SUBSTR(fs_name,1,24) FILESYSTEM, SUBSTR(vol_device,1,20) DEVICE, prepared_status,
enabled_status FROM V$ASM_ACFS_SECURITY_INFO;
FILESYSTEM DEVICE PREPARE ENABLED_
------------------------- ---------------------- ------- --------
/acfsmounts/acfs1 /dev/asm/volume1-228 YES ENABLED
Example 12-3 Viewing security rules information in V$ASM_ACFS_SEC_RULE
This example shows information displayed from the V$ASM_ACFS_SEC_RULE view. The FS_NAMEcolumn contains the mount point.
SELECT SUBSTR(rule_name,1,24) rule, SUBSTR(rule_type,1,12) type,
SUBSTR(rule_value,1,16) value, SUBSTR(fs_name,1,24) filesystem
FROM V$ASM_ACFS_SEC_RULE;
RULE TYPE VALUE FILESYSTEM
------------------------ ------------ ---------------- ------------------------
medHistRule1a TIME 22:00:00 /acfsmounts/acfs1
medHistRule1c TIME 08:00:00 /acfsmounts/acfs1
medHistRule1b USERNAME medMaintenance /acfsmounts/acfs1
medHistRule1d USERNAME medBrowse /acfsmounts/acfs1
SYSTEM_RULE_Auditor GROUPNAME myaudit_mgr_grp /acfsmounts/acfs1
SYSTEM_RULE_AuditManager GROUPNAME myauditor_grp /acfsmounts/acfs1
SYSTEM_RULE_Always TIME 00:00:00 /acfsmounts/acfs1
Example 12-4 Viewing security ruleset information in V$ASM_ACFS_SEC_RULESET
This example shows information displayed from the V$ASM_ACFS_SEC_RULESET view. The FS_NAME column contains the mount point.
SELECT SUBSTR(ruleset_name,1,36) ruleset, ruleset_option r_option, SUBSTR(fs_name,1,24) filesystem
FROM V$ASM_ACFS_SEC_RULESET;
RULESET R_OPTION FILESYSTEM
------------------------------------ -------- -----------------
medRuleSet1 ALL_TRUE /acfsmounts/acfs1
medRuleSet2 ALL_TRUE /acfsmounts/acfs1
SYSTEM_RULESET_Auditor ALL_TRUE /acfsmounts/acfs1
SYSTEM_RULESET_AuditManager ALL_TRUE /acfsmounts/acfs1
SYSTEM_RULESET_AuditMgr_Auditor ANY_TRUE /acfsmounts/acfs1
SYSTEM_RULESET_AlwaysDeny ANY_TRUE /acfsmounts/acfs1
Example 12-5 Viewing security ruleset information in V$ASM_ACFS_SEC_RULESET_RULE
This example shows information displayed from the V$ASM_ACFS_SEC_RULESET_RULE view.
SELECT SUBSTR(ruleset_name,1,36) ruleset, substr(rule_name,1,24) rule,
SUBSTR(fs_name,1,36) filesystem FROM V$ASM_ACFS_SEC_RULESET_RULE;
RULESET RULE FILESYSTEM
------------------------------------ ------------------------ ------------------
medRuleSet1 medHistRule1a /acfsmounts/acfs1
medRuleSet1 medHistRule1b /acfsmounts/acfs1
medRuleSet2 medHistRule1c /acfsmounts/acfs1
medRuleSet2 medHistRule1d /acfsmounts/acfs1
SYSTEM_RULESET_Auditor SYSTEM_RULE_Auditor /acfsmounts/acfs1
SYSTEM_RULESET_AuditManager SYSTEM_RULE_AuditManager /acfsmounts/acfs1
SYSTEM_RULESET_AuditMgr_Auditor SYSTEM_RULE_Auditor /acfsmounts/acfs1
SYSTEM_RULESET_AuditMgr_Auditor SYSTEM_RULE_AuditManager /acfsmounts/acfs1
SYSTEM_RULESET_AlwaysDeny SYSTEM_RULE_Always /acfsmounts/acfs1
Example 12-6 Viewing snapshot information in V$ASM_ACFSSNAPSHOTS
This examle shows information displayed from the V$ASM_ACFSSNAPSHOTS view. The FS_NAMEcolumn contains the mount point. The VOL_DEVICE contains the name of the Oracle ADVM device.
SELECT SUBSTR(FS_NAME,1,24) FILESYSTEM, SUBSTR(VOL_DEVICE,1,22) DEVICE, SUBSTR(SNAP_NAME,1,12) SNAPSHOT, CREATE_TIME TIME, SUBSTR(PARENT,1,10) PARENT, SUBSTR(TYPE,1,4) TYPE FROM V$ASM_ACFSSNAPSHOTS; FILESYSTEM DEVICE SNAPSHOT TIME PARENT TY ------------------------ ---------------------- ------------ --------- ---------- -- /acfsmounts/acfs1 /dev/asm/volume1-229 snaprw 13-MAR-12 NULL RW /acfsmounts/acfs1 /dev/asm/volume1-229 snaprw_child 13-MAR-12 snaprw RW /acfsmounts/acfs2 /dev/asm/volume2-321 snapro 13-MAR-12 NULL RO
Example 12-7 Viewing volume information with V$ASM_ACFSVOLUMES
This example shows information displayed from the V$ASM_ACFSVOLUMES view. The PRIMARY_VOL column contains TRUE if the volume is the primary volume for the file system.
SELECT fs_name, vol_device, primary_vol, total_mb, free_mb FROM V$ASM_ACFSVOLUMES; FS_NAME VOL_DEVICE PRIMARY_VOL TOTAL_MB FREE_MB ------------------ ---------------------- ----------- --------- ---------- /acfsmounts/acfs1 /dev/asm/volume1-228 TRUE 1024000 578626.522 /acfsmounts/acfs2 /dev/asm/volume2-375 TRUE 1024000 685761.463 ...
Example 12-8 Viewing volume information with V$ASM_FILESYSTEM
This example shows information displayed from the V$ASM_FILESYSTEM view.
The STATE column contains the status of the file system, either AVAILABLE or OFFLINE. An offline file system can only be dismounted; other attempts at access result in errors. Offline means that either the Oracle ASM instance is down, the disk group has been forced dismounted, or less commonly, a metadata I/O failure occurred or serious metadata corruption was detected. With a metadata I/O failure, the file system is also marked as corrupt.
The CORRUPT column indicates whether the file system needs the fsck or acfschkdsk command run on it.
SELECT fs_name, available_time, block_size, state, corrupt FROM V$ASM_FILESYSTEM; FS_NAME AVAILABLE BLOCK_SIZE STATE CORRUPT -------------------------- --------- ---------- ------------- ------- /acfsmounts/acfs1 19-JUL-09 4 AVAILABLE FALSE /acfsmounts/acfs2 19-JUL-09 4 AVAILABLE FALSE
Example 12-9 Viewing volume information with V$ASM_VOLUME
This example shows information displayed from the V$ASM_VOLUME view for volumes contained in the DATA disk group.
SELECT dg.name AS diskgroup, v.volume_name, v.volume_device, v.mountpath
FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME v
WHERE dg.group_number = v.group_number and dg.name = 'DATA';
DISKGROUP VOLUME_NAME VOLUME_DEVICE MOUNTPATH
---------------- ----------------- ----------------------- ------------------
DATA VOLUME1 /dev/asm/volume1-228 /acfsmounts/acfs1
DATA VOLUME2 /dev/asm/volume2-375 /acfsmounts/acfs2
Example 12-10 Viewing volume information with V$ASM_VOLUME_STAT
This example shows information displayed from the V$ASM_VOLUME_STAT view for volumes contained in the DATA disk group. The BYTES_READ column contains the total number of bytes read for the volume. The BYTES_WRITTEN column contains the total number of bytes written for the volume.
SELECT dg.name AS diskgroup, v.volume_name, v.bytes_read, v.bytes_written
FROM V$ASM_DISKGROUP dg, V$ASM_VOLUME_STAT v
WHERE dg.group_number = v.group_number and dg.name = 'DATA';
DISKGROUP VOLUME_NAME BYTES_READ BYTES_WRITTEN
------------------------------ ------------------------------ ----------- -------------
DATA VOLUME1 12370105856 43510272
DATA VOLUME2 2685728 32201504
Example 12-11 Viewing tag name information with V$ASM_ACFSTAG
This example shows tag names for the /acfsmounts/acfs1 file system displayed from the V$ASM_ACFSTAG view.
SELECT SUBSTR(TAG_NAME,1,8) TAG_NAME, SUBSTR(FS_NAME,1,20) FS_NAME,
SUBSTR(PATH_NAME,1,42) PATH_NAME FROM V$ASM_ACFSTAG WHERE TAG_NAME='tag5';
TAG_NAME FS_NAME PATH_NAME
-------- --------------------- --------------------------------------
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1/d2/d3/d4/d5/f6
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1/d2/d3/d4/d5
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1/d2/d3/d4
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1/d2/d3
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1/d2
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/d1
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1/f1
tag5 /acfsmounts/acfs1 /acfsmounts/acfs1
See Also:
Oracle Database Reference for information about the Oracle ACFS dynamic views
Oracle ACFS Support for Oracle Database File Mapping Views
Oracle ACFS supports Oracle Database file mapping views to the Oracle ASM device level.
Note:
This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2).
The following database mapping views are supported by Oracle ACFS:
-
V$MAP_FILE -
V$MAP_FILE_EXTENT -
V$MAP_ELEMENT -
V$MAP_FILE_IO_STACK
These V$MAP views are only refreshed by executing the procedure DBMS_STORAGE_MAP.MAP_ALL. The Oracle ACFS file mapping interface does not utilize the external fmputl process or its supporting libraries.
Note:
-
Oracle ACFS does not provide support for Oracle Database file mapping on Windows.
-
Oracle ACFS does not provide support for the
V$MAP_SUBELEMENTview.
Before running any queries on the V$MAP views, ensure that the FILE_MAPPING initialization is set to TRUE, then run the DBMS_STORAGE_MAP.MAP_ALL procedure to build the mapping information for the entire I/O subsystem associated with the database. For example, connect as SYSDBA to the database instance and run the following:
SQL> ALTER SYSTEM SET file_mapping=true; SQL> EXEC DBMS_STORAGE_MAP.MAP_ALL(10000);
The SQL statements in Example 12-12 to Example 12-15 are run from the Oracle Database instance.
Example 12-12 Viewing Oracle ASM information with V$MAP_ELEMENT
This example displays information from the V$MAP_ELEMENT view.
SQL> SELECT ELEM_NAME, ELEM_IDX, ELEM_TYPE, ELEM_SIZE, ELEM_DESCR
FROM V$MAP_ELEMENT;
ELEM_NAME ELEM_IDX ELEM_TYPE ELEM_SIZE ELEM_DESCR
------------ ---------- ---------- ---------- -----------------
+/dev/xvdd1 0 ASMDISK 117184512 TEST_0001
+/dev/xvdc1 1 ASMDISK 117184512 TEST_0000
Example 12-13 Viewing Oracle ACFS Data File Information with V$MAP_FILE
This example displays information from the V$MAP_FILE view.
SQL> SELECT FILE_NAME, FILE_MAP_IDX, FILE_TYPE, FILE_STRUCTURE, FILE_SIZE,
FILE_NEXTS FROM V$MAP_FILE WHERE REGEXP_LIKE(FILE_NAME, '*users01.dbf');
FILE_NAME FILE_MAP_IDX FILE_TYPE FILE_STRU FILE_SIZE FILE_NEXTS
------------------------- ------------ --------- --------- --------- ----------
/dbdata1/orcl/users01.dbf 4 DATAFILE FILE 10256 41
Example 12-14 Viewing Element and File Offset Information with V$MAP_FILE_EXTENT
This example displays the element offset versus file offset information for each extent with V$MAP_FILE_EXTENT, specifying FILE_MAP_IDX equal to 4, which is the file map index of the /dbdata/orcl/users01.dbf file.
SQL> SELECT FILE_MAP_IDX, EXT_NUM, EXT_ELEM_OFF, EXT_SIZE, EXT_FILE_OFF,
EXT_TYPE, ELEM_IDX FROM V$MAP_FILE_EXTENT WHERE FILE_MAP_IDX=4;
FILE_MAP_IDX EXT_NUM EXT_ELEM_OFF EXT_SIZE EXT_FILE_OFF EXT_TY ELEM_IDX
------------ ---------- ------------ ---------- ------------ ------ ----------
4 0 58105664 192 0 DATA 0
4 1 58154752 256 192 DATA 1
4 2 58089472 256 448 DATA 0
...
4 39 58140928 256 9920 DATA 1
4 40 58108160 88 10176 DATA 0
41 rows selected.
Example 12-15 Viewing Extent Information With V$MAP_FILE_IO_STACK
This example displays information from V$MAP_FILE_IO_STACK specifying FILE_MAP_IDXequal to 4. The V$MAP_FILE_IO_STACK view is similar to V$MAP_FILE_EXTENT, but the display groups contiguous extents which are on the same device or element and of the same size.
SQL> SELECT FILE_MAP_IDX, ELEM_IDX, CU_SIZE,STRIDE, NUM_CU,ELEM_OFFSET,
FILE_OFFSET FROM V$MAP_FILE_IO_STACK WHERE FILE_MAP_IDX=4;
FILE_MAP_IDX ELEM_IDX CU_SIZE STRIDE NUM_CU ELEM_OFFSET FILE_OFFSET
------------ ---------- ---------- ---------- ---------- ----------- -----------
4 0 256 1024 10 58089472 448
4 0 192 0 1 58105664 0
4 0 256 1024 9 58105856 960
4 0 88 0 1 58108160 10176
4 1 256 1024 10 58138624 704
4 1 256 1024 10 58154752 192
6 rows selected.