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

本站中文解释

Oracle视图DBA_APP_PDB_STATUS用于查看应用程序容器(PDB)的信息,该视图包含容器的状态、类型和信息。它也可以报告PDB是否由控制文件驱动恢复的。

使用以下 SQL 语句来检索所有应用程序容器的状态信息:

SELECT * FROM DBA_APP_PDB_STATUS;

或者,可以提供特定的应用程序容器名称来检索细节:

SELECT * FROM DBA_APP_PDB_STATUS WHERE CON_ID = ”;

官方英文解释

DBA_APP_PDB_STATUS provides information about applications in all the application PDBs in the current application container. It provides this information when queried in the application root.

The view should be queried in the application root.

This view can be used to show which version of an application has been synced to which application PDBs.

Column Datatype NULL Description

CON_UID

NUMBER

Unique ID of the PDB

APP_NAME

VARCHAR2(128)

Name of the application

APP_ID

NUMBER

Id of the application

APP_VERSION

VARCHAR2(30)

Version of the application

APP_STATUS

VARCHAR2(12)

Status of the application


数据运维技术 » Oracle 视图 DBA_APP_PDB_STATUS 官方解释,作用,如何使用详细说明