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

网络编程 Oracle 视图 DBA_LOCK_INTERNAL 官方解释，作用，如何使用详细说明 10-18

_AUDIT

Oracle视图DBA_LOCK_INTERNAL_AUDIT是一个只读视图，用于监视和报告有关锁定的内部审计活动的信息。它报告的字段可以表明哪个用户发出的命令导致哪种类型的锁定，以及相关操作的执行时间。

DBA_LOCK_INTERNAL_AUDIT可以通过执行以下查询来使用：

SELECT *
FROM DBA_LOCK_INTERNAL_AUDIT
WHERE username = ‘username’;

这将会返回给定用户名的所有相关锁定内部审计活动，包括持有锁定的行数和操作时间等。

DBA_LOCK_INTERNAL displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.

Column	Datatype	Description
`SESSION_ID`	`NUMBER`	Session holding or acquiring the lock
`LOCK_TYPE`	`VARCHAR2(56)`	Lock type See Also: For a listing of lock types, see Oracle Enqueue Names
`MODE HELD`	`VARCHAR2(40)`	Lock mode
`MODE REQUESTED`	`VARCHAR2(40)`	Lock mode requested
`LOCK_ID1`	`VARCHAR2(1130)`	Type-specific lock identifier, part 1
`LOCK_ID2`	`VARCHAR2(40)`	Type-specific lock identifier, part 2
`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

标签：视图,内部审计,是一个,操作,报告