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

_KEYS

Oracle视图V$RO_USER_ACCOUNT_KEYS提供有关Oracle Restart管理文件元数据的信息。它描述了位于使用Oracle Restart恢复必需的只读用户账户的文件夹的位置，这些文件夹是RMAN还原数据文件的前提。此视图还显示了SYSMAN所拥有的用户账户，包括系统权限、密码等。

可以通过以下语句查询V$RO_USER_ACCOUNT_KEYS视图：

SELECT * FROM V$RO_USER_ACCOUNT_KEYS;

官方英文解释 V$RO_USER_ACCOUNT is populated only on Oracle databases that are open in read-only mode. When a database is read-only, security data cannot be stored in normal catalogue tables. Instead, the security data is stored in an in-memory table that is queried through this view.

In an Oracle Data Guard environment, some of the security information for user accounts on the standby is inherited from the primary server. For example, if the account is locked out unlimited on the primary, then it will be locked on the standby database(s). The information stored on the standby is volatile information that user actions on the standby database(s) can affect, such as the number of failed logins, and the time the account was locked on the standby due to failed access attempts. Note that failed login attempts on standbys do not affect the account status on primaries.

If this view is queried from the root in a multitenent container database (CDB), then only common users and the SYS user are returned.

If this view is queried from a pluggable database (PDB), only rows that pertain to the current PDB are returned.

The number of failed login attempts. The count is not cumulative; it is reset upon successful logon to the account

The ID of the container where the failed login occurred.

For users that are not common users, the CON_IDis the PDB ID where the failed login attempt occurred.

For common users, the CON_ID is 0.

The login attempts that occurred on a PDB are not displayed when you query V$RO_USER_ACCOUNT from another PDB. You only see the failed login attempts of any users (that are not common users) if those failed login attempts occurred on the same PDB from which you are querying V$RO_USER_ACCOUNT.

The failed login attempts of common users (and of the SYS user) are only displayed when V$RO_USER_ACCOUNT is queried from the root of a CDB, not when it is queried from a PDB.

In a non-CDB, the value is always 0.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$RO_USER_ACCOUNT 官方解释，作用，如何使用详细说明