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

本站中文解释

Oracle视图V$INSTANCE用于查看正在运行的Oracle实例的详细信息。它包含了Oracle实例的版本，状态，以及有关其用户权限，表空间，实例会话，字符集，连接模式，实例中的活动会话数等详细信息。

使用步骤：

1. 使用Oracle客户端连接你想要查看的数据库实例；

2. 执行以下查询：

select * from v$instance;

该查询将返回Oracle实例的实例名，版本，服务级别等等，所有查询出的信息可以由您来核对真实情况。

官方英文解释

V$INSTANCE displays the state of the current instance.

Instance number used for instance registration (corresponds to the INSTANCE_NUMBER initialization parameter)

See Also: INSTANCE_NUMBER

The legacy database version used before Oracle Database 18c. This column displays the same value as the VERSION column

The version string with the new Oracle Database version scheme introduced in Oracle Database 18c.

Indicates whether the instance is mounted in cluster database mode (YES) or not (NO)

FAILED Archiver failed to archive a log last time but will try again within 5 minutes

NULL ALTER SYSTEM SWITCH LOGFILE is hung but there is room in the current online redo log

Indicates whether the instance is in unrestricted mode, allowing logins by all users (ALLOWED, or in restricted mode, allowing logins by database administrators only (RESTRICTED)

Indicates whether the instance is an active instance (PRIMARY_INSTANCE) or an inactive secondary instance (SECONDARY_INSTANCE), or UNKNOWN if the instance has been started but not mounted

QUIESCING ALTER SYSTEM QUIESCE RESTRICTED has been issued: no new user transactions, queries, or PL/SQL statements are processed in this instance. User transactions, queries, or PL/SQL statements issued before the ALTER SYSTEM QUIESCE RESTRICTED statement are unaffected. DBA transactions, queries, or PL/SQL statements are also unaffected.

QUIESCED ALTER SYSTEM QUIESCE RESTRICTED has been issued: no user transactions, queries, or PL/SQL statements are processed. DBA transactions, queries, or PL/SQL statements are unaffected. User transactions, queries, or PL/ SQL statements issued after the ALTER SYSTEM QUIESCE RESTRICTED statement are not processed.

A single ALTER SYSTEM QUIESCE RESTRICTED statement quiesces all instances in an Oracle RAC environment. After this statement has been issued, some instances may enter into a quiesced state before other instances; the system is quiesced when all instances enter the quiesced state.

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.

REGULAR: A regular Oracle RAC instance. This value is also always used for any non-Oracle RAC instance.

RAC: If the database is a regular Oracle RAC database which may have multiple instances.

RACONENODE: If the database is Oracle RAC, but allows only one instance to run at any time the RAC One Node mode.

UNKNOWN: If the database s type can t be determined. This might happen when the database is registered as a DB resource with CRS but the CRS service has failed to return valid database type information. Typically, this indicates that either the CRS service is down or it is in a faulty state.

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

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