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.
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 |
---|---|
Contains encryption information for each Oracle ACFS file system. |
|
Contains security realm information for each Oracle ACFS file system. |
|
Contains information about Oracle ACFS security administrator in the cluster. |
|
Contains information about Oracle ACFS security command rules for each Oracle ACFS file system. |
|
|
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. |
|
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. |
|
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 snapshot information about every mounted Oracle ACFS file system. |
|
Contains all tag name information about files on all mounted Oracle ACFS file systems |
|
Contains information about mounted Oracle ADVM volumes, correlated with |
|
Contains information about the history of audit trail cleanup or purge events in an Oracle ASM instance. |
|
Contains information about the configured audit trail purge jobs in an Oracle ASM instance. |
|
Contains information about the currently configured audit trail properties in an Oracle ASM instance that are used by the |
|
Contains information about the last archive timestamps set for audit trail cleanup or purges in an Oracle ASM instance. |
|
Contains information about every mounted Oracle ACFS file system. |
|
Contains information about each Oracle ADVM volume that is a member of an Oracle ASM instance. |
|
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.
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.
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.
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.
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".
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.
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.
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.
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