Views Containing Oracle ACFS Information

You can use the views in Table 12-1 to obtain information about Oracle Automatic Storage Management Cluster File System (Oracle ACFS). These views are accessible from the Oracle ASM instance.

Note:

  • To display information about Oracle ACFS file systems or volumes that are located on nodes in an Oracle Flex ASM configuration, you must connect to the Oracle ASM proxy instance instead of the local Oracle ASM instance. For information about Oracle Flex ASM, refer to "Managing Oracle Flex ASM".

  • When viewing space usage values in Oracle ACFS views on Windows systems, the values may differ from sizes in Windows folders. The mechanism used by Folder Properties on Windows systems only accounts for files and should be considered an approximate value.


Table 12-1 Oracle ASM dynamic views for Oracle ACFS information

View Description

V$ASM_ACFS_ENCRYPTION_INFO

Contains encryption information for each Oracle ACFS file system.

V$ASM_ACFS_SECURITY_INFO

Contains security realm information for each Oracle ACFS file system.

V$ASM_ACFS_SEC_ADMIN

Contains information about Oracle ACFS security administrator in the cluster.

V$ASM_ACFS_SEC_CMDRULE

Contains information about Oracle ACFS security command rules for each Oracle ACFS file system.

V$ASM_ACFS_SEC_REALM

Contains information about every realm in the Oracle ACFS security realm for each Oracle ACFS file system.

V$ASM_ACFS_SEC_REALM_FILTER

Contains information about every filter in the Oracle ACFS security realm for each Oracle ACFS file system. A filter is a defined as commandrule/ruleset pair in a realm.

V$ASM_ACFS_SEC_REALM_GROUP

Contains information about every group in the Oracle ACFS security realm for each Oracle ACFS file system.

V$ASM_ACFS_SEC_REALM_USER

Contains information about every user in the Oracle ACFS security realm for each Oracle ACFS file system.

V$ASM_ACFS_SEC_RULE

Contains information about every Oracle ACFS security rule for each Oracle ACFS file system.

V$ASM_ACFS_SEC_RULESET

Contains information about every Oracle ACFS security ruleset for each Oracle ACFS file system.

V$ASM_ACFS_SEC_RULESET_RULE

Contains information about every rule in Oracle ACFS security ruleset for each Oracle ACFS file system.

V$ASM_ACFSSNAPSHOTS

Contains snapshot information about every mounted Oracle ACFS file system.

V$ASM_ACFSTAG

Contains all tag name information about files on all mounted Oracle ACFS file systems

V$ASM_ACFSVOLUMES

Contains information about mounted Oracle ADVM volumes, correlated with V$ASM_FILESYSTEM.

V$ASM_AUDIT_CLEAN_EVENTS

Contains information about the history of audit trail cleanup or purge events in an Oracle ASM instance.

V$ASM_AUDIT_CLEANUP_JOBS

Contains information about the configured audit trail purge jobs in an Oracle ASM instance.

V$ASM_AUDIT_CONFIG_PARAMS

Contains information about the currently configured audit trail properties in an Oracle ASM instance that are used by the DBMS_AUDIT_MGMT PL/SQL package.

V$ASM_AUDIT_LAST_ARCH_TS

Contains information about the last archive timestamps set for audit trail cleanup or purges in an Oracle ASM instance.

V$ASM_FILESYSTEM

Contains information about every mounted Oracle ACFS file system.

V$ASM_VOLUME

Contains information about each Oracle ADVM volume that is a member of an Oracle ASM instance.

V$ASM_VOLUME_STAT

Contains information about statistics for each Oracle ADVM volume.


Example 12-1 shows information displayed from the V$ASM_ACFS_ENCRYPTION_INFO view. The FS_NAME column contains the mount point. The VOL_DEVICE contains the name of the Oracle ADVM device.

See Also:

Oracle Database Reference for information about the V$ASM_ACFS_ENCRYPTION_INFO view

Example 12-2 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.

See Also:

Oracle Database Reference for information about the V$ASM_ACFS_SECURITY_INFO view

Example 12-3 shows information displayed from the V$ASM_ACFS_SEC_RULE view. The FS_NAME column contains the mount point.

Example 12-4 shows information displayed from the V$ASM_ACFS_SEC_RULESET view. The FS_NAME column contains the mount point.

Example 12-5 shows information displayed from the V$ASM_ACFS_SEC_RULESET_RULE view. The FS_NAME column contains the mount point.

Example 12-6 shows information displayed from the V$ASM_ACFSSNAPSHOTS view. The FS_NAME column contains the mount point. The VOL_DEVICE contains the name of the Oracle ADVM device.

See Also:

Oracle Database Reference for information about the V$ASM_ACFSSNAPSHOTS view

Example 12-7 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.

See Also:

Oracle Database Reference for information about the V$ASM_ACFSVOLUMES view

Example 12-8 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. See "fsck" and "acfschkdsk".

See Also:

Oracle Database Reference for information about the V$ASM_FILESYSTEM view

Example 12-9 shows information displayed from the V$ASM_VOLUME view for volumes contained in the DATA disk group.

See Also:

Oracle Database Reference for information about the V$ASM_VOLUME view

Example 12-10 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.

See Also:

Oracle Database Reference for information about the V$ASM_VOLUME_STAT view

Example 12-11 shows tag names for the /acfsmounts/acfs1 file system displayed from the V$ASM_ACFSTAG view.

See Also:

Oracle Database Reference for information about the V$ASM_ACFSTAG view

Example 12-1 Viewing encryption information in V$ASM_ACFS_ENCRYPTION_INFO

SELECT SUBSTR(fs_name,1,24) FILESYSTEM, SUBSTR(vol_device,1,20) DEVICE, set_status, 
   enabled_status, algorithm, key_length, last_rekey_time FROM V$ASM_ACFS_ENCRYPTION_INFO;

FILESYSTEM               DEVICE                 SET_STA ENABLED_ ALGORIT KEY_LEN LAST_REKE
------------ ----------- ---------------------- ------- -------- ------- ------- ---------
/acfsmounts/acfs1        /dev/asm/volume1-228   YES     ENABLED  AES     192

Example 12-2 Viewing security information in V$ASM_ACFS_SECURITY_INFO

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

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

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

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

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

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

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

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

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

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