Oracle 视图 V$PASSWORDFILE_INFO 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$PASSWORDFILE_INFO用于查看当前数据库中密码文件的状态以及它们有多大。该视图显示了这些文件是否省略、存档并被锁定，v$pwfile_users 列显示了具有SYSDBA和SYSOPER系统权限的用户。
这个视图可以通过以下方式使用:
1. 通过使用下面的查询可以检查当前数据库密码文件的大小：
SELECT MAX(BYTES/1024/1024) FROM V$PASSWORDFILE_INFO;
2. 我们可以使用V$PWFILE_INFO视图来查看是否有受保护的SYSDBA和SYSOPER系统身份，如果有，它们的使用者列表会显示出来：
SELECT USERNAME from V$PWFILE_USERS;
官方英文解释
V$PASSWORDFILE_INFO provides information about the database password file.
This view can be queried from the root or from a pluggable database (PDB) in a multitenant container database (CDB). When queried, this view always returns one row.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Fully qualified password file name/location. |
|
|
|
Shows the format of the password file. Possible values include:
|
|
|
|
Indicates whether the password file is stored in Oracle ASM. Possible values:
|
|
|
|
Indicates whether the password file is stored in Oracle Exascale. Possible values:
|
|
|
|
The ID of the container to which the data pertains. Because there is only one password file for a CDB that is common for the entire CDB, the only value possible for |
Footnote 1 This column is available starting with Oracle Database 21c.
Note:
If the database password file name or location was recently changed, and you do not see the change reflected in this view, you can run the following SQL statement:
SQL> ALTER SYSTEM FLUSH PASSWORDFILE_METADATA_CACHE;This statement flushes the metadata cache and updates the database to use the new password file. It also updates this view with the current password file information.
