Oracle教程

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

本站中文解释

Oracle视图DBA_ACCHK_EVENTS提供一种查看所有访问控制审查器事件的有效方法，其显示的结果包括事件的分组、时间戳、实例和对象名称。

使用DBA_ACCHK_EVENTS视图，可以做大量的安全系统审核，包括对数据库访问控制的审核，以及确定用户可见的拥有者和目标模式。此外，可以使用DBA_ACCHK_EVENTS视图来识别具有外部登录权限的特权用户，以及数据库中的存储过程、函数和其他对象。

要使用DBA_ACCHK_EVENTS视图，首先要确保安全系统审核器已启用，并通过按照ALTER SYSTEM SETВ dtv_enable=TRUEВ 语句，使之启用。

接下来，可以使用SELECT * FROM DBA_ACCHK_EVENTS语句来检索事件信息。可以将WHERE子句用于定义查询条件，例如某特定用户的行为，或者某特定对象被发现的特定用法。

如果需要的话，也可以将GROUP BY子句用于对结果集进行分组，例如，显示所有用户的每个行为发生的次数。同样，还可以使用ORDER BY子句对结果集进行排序，例如，在按照日期顺序显示某个审计事件。

总而言之，DBA_ACCHK_EVENTS视图可用于审查所有访问控制审查器事件，以进行安全性审核，识别异常的数据库访问行为，并分析现有数据库对象的可见性。

官方英文解释

DBA_ACCHK_EVENTS displays information about events that occurred during an Application Continuity Protection Check (ACCHK) workload run.

Each row in this view represents one trace record for an event. You can use this view in conjunction with the DBA_ACCHK_STATISTICS view. Join the SESSION_ID and SERIAL# columns in this view with the SESSION_ID and SERIAL# columns in DBA_ACCHK_STATISTICS to view Application Continuity protection statistics for a particular session.

The ACCHK_READ role allows users with no administrative privileges to query this view.

Column Datatype NULL Description

INST_ID

NUMBER

Identifier for the instance in which the trace record was generated

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

TIMESTAMP

TIMESTAMP(3) WITH TIME ZONE

Time at which the event occurred

SESSION_ID

NUMBER

ID of the session that generated the trace record

SERIAL#

NUMBER

Serial number of the session that generated the trace record

SERVICE_NAME

VARCHAR2(64)

Service name of the session that generated the trace record

PROGRAM

VARCHAR2(84)

Name of the operating system program that generated the trace record

MODULE

VARCHAR2(64)

Name of the module that generated the trace record

ACTION

VARCHAR2(64)

Name of the action that generated the trace record

SQL_ID

VARCHAR2(13)

SQL identifier of the SQL statement that generated the trace record

CALL_NAME

VARCHAR2(20)

Name of the user call that generated the trace record

EVENT_TYPE

VARCHAR2(16)

Event type. Possible values:

  • DISABLED – The event caused capture or replay to be disabled. Refer to the ERROR_CODE column for more information.

  • NEVER ENABLED – Neither Application Continuity nor Transparent Application Continuity was enabled for the session when the event occurred.

  • NOT ENABLING – The event describes why the database could not reenable protection after protection was disabled. Refer to the ERROR_CODE column for more information.

  • REPLAY FAILED – The event describes why the session did not fail over. This event only occurs if Application Continuity could not fail over. Refer to the ERROR_CODE column for more information.

ERROR_CODE

NUMBER

If an error occurred, this column displays the error code: ORA-number. Otherwise, the value of this column is 0.

Note:

This view is available starting with Oracle Database 21c.

See Also:

“DBA_ACCHK_STATISTICS”


数据运维技术 » Oracle 视图 DBA_ACCHK_EVENTS 官方解释，作用，如何使用详细说明
分享到：

相关推荐