Oracle教程 2023-03-27

Oracle 视图 V$ASM_AUDIT_CONFIG_PARAMS 官方解释，作用，如何使用详细说明

本站中文解释

V$ASM_AUDIT_CONFIG_PARAMS视图是Oracle基础架构组件Automatic Storage Management（ASM）中审计系统视图，它存储ASM实例审计参数的当前状态。通过使用这个视图，我们可以查看ASM实例的审计状态以及可用参数，从而支持最佳实践，来维护数据库内容的安全性和准确性。

要使用V$ASM_AUDIT_CONFIG_PARAMS视图，首先要确保ASM实例中的审计功能已经被正确启用，并且可以正确记录和跟踪ASM操作的变更。要完成这一点，我们可以通过执行如下语句：

ALTER SYSTEM SET audit_sys_operations=true scope=spfile;

然后，可以使用以下查询来查看V$ASM_AUDIT_CONFIG_PARAMS视图：

SELECT * FROM V$ASM_AUDIT_CONFIG_PARAMS;

官方英文解释

In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_AUDIT_CONFIG_PARAMS displays information about the currently configured audit trail properties that are used by the DBMS_AUDIT_MGMT package.

In a database instance, V$ASM_AUDIT_CONFIG_PARAMS displays no rows.

Column	Datatype	Description
`PARAMETER_NAME`	`VARCHAR2(64)`	Name of the property
`PARAMETER_VALUE`	`VARCHAR2(64)`	Value of the property
`AUDIT_TRAIL`	`VARCHAR2(64)`	Audit trails for which the property is configured: `OS AUDIT TRAIL` and `UNIFIED AUDIT TRAIL`
`PARAMETER_UNIT`	`VARCHAR2(64)`	Provides description of units of audit properties (file size in KB and file age in day(s))
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.

本站中文解释

官方英文解释

相关推荐