V$INSTANCE视图

2024-04-02 19:55

短信预约 -IT技能 免费直播动态提醒

V$INSTANCE

V$INSTANCE 展示当前实力的状态。

Column	Datatype	Description
`INSTANCE_NUMBER`	`NUMBER`	Instance number used for instance registration (corresponds to the `INSTANCE_NUMBER` initialization parameter) See Also: "INSTANCE_NUMBER"
`INSTANCE_NAME`	`VARCHAR2(16)`	Name of the instance
`HOST_NAME`	`VARCHAR2(64)`	Name of the host machine
`VERSION`	`VARCHAR2(17)`	Database version
`STARTUP_TIME`	`DATE`	Time when the instance was started
`STATUS`	`VARCHAR2(12)`	Status of the instance: `STARTED` - After `STARTUP NOMOUNT` `MOUNTED` - After `STARTUP MOUNT` or `ALTER DATABASE CLOSE` `OPEN` - After `STARTUP` or `ALTER DATABASE OPEN` `OPEN MIGRATE` - After `ALTER DATABASE OPEN { UPGRADE \| DOWNGRADE }`
`PARALLEL`	`VARCHAR2(3)`	Indicates whether the instance is mounted in cluster database mode (`YES`) or not (`NO`)
`THREAD#`	`NUMBER`	Redo thread opened by the instance
`ARCHIVER`	`VARCHAR2(7)`	Automatic archiving status: `STOPPED` `STARTED` `FAILED` - Archiver failed to archive a log last time but will try again within 5 minutes
`LOG_SWITCH_WAIT`	`VARCHAR2(15)`	Event that log switching is waiting for: `ARCHIVE LOG` `CLEAR LOG` `CHECKPOINT` NULL - `ALTER SYSTEM SWITCH LOGFILE` is hung but there is room in the current online redo log
`LOGINS`	`VARCHAR2(10)`	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`)
`SHUTDOWN_PENDING`	`VARCHAR2(3)`	Indicates whether a shutdown is pending (`YES`) or not (`NO`)
`DATABASE_STATUS`	`VARCHAR2(17)`	Status of the database: `ACTIVE` `SUSPENDED` `INSTANCE RECOVERY`
`INSTANCE_ROLE`	`VARCHAR2(18)`	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
`ACTIVE_STATE`	`VARCHAR2(9)`	Quiesce state of the instance: `NORMAL` - Database is in a normal state. `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.
`BLOCKED`	`VARCHAR2(3)`	Indicates whether all services are blocked (`YES`) or not (`NO`)
`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
`INSTANCE_MODE`	`VARCHAR2(11)`	Mode of the Oracle Real Application Clusters (Oracle RAC) instance. Possible values: `REGULAR`: A regular Oracle RAC instance `READ MOSTLY`: An Oracle RAC instance which has very few database writes
`EDITION`	`VARCHAR2(7)`	The edition of the database. Possible values include: `CORE EE`: CORE Enterprise Edition `CORE SE`: CORE Standard Edition `EE`: Enterprise Edition `PO`: Personal Edition `SE`: Standard Edition `XE`: Express Edition
`FAMILY`	`VARCHAR2(80)`	For internal use only.

免责声明：

① 本站未注明“稿件来源”的信息均来自网络整理。其文字、图片和音视频稿件的所属权归原作者所有。本站收集整理出于非商业性的教育和科研之目的，并不意味着本站赞同其观点或证实其内容的真实性。仅作为临时的测试数据，供内部测试之用。本站并未授权任何人以任何方式主动获取本站任何信息。

② 本站未注明“稿件来源”的临时测试数据将在测试完成后最终做删除处理。有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341

阅读原文内容投诉

V$INSTANCE视图

下载Word文档到电脑，方便收藏和打印～

下载Word文档

猜你喜欢

Oracle中V$视图和DBA_视图有什么区别

在Oracle数据库中，V$视图和DBA_视图都是用来访问数据库的动态性能和配置信息的视图，但两者有一些区别：V$视图（动态性能视图）：V$视图提供了当前数据库实例中的动态性能信息，如内存使用情况、会话信息、锁信息等。这些视图是实时更新的，

2024-04-19

Oracle动态视图v$active_session_history怎么应用

这篇文章主要介绍“Oracle动态视图v$active_session_history怎么应用”的相关知识，小编通过实际案例向大家展示操作过程，操作方法简单快捷，实用性强，希望这篇“Oracle动态视图v$active_session_hi

2023-07-05

Oracle动态视图v$active_session_history实战示例

目录oracle动态视图实战之v$active_session_history先看下官方解释实际工作中主要应用结合我们的AWR报告关键点Oracle动态视图实战之v$active_session_history先看下官方解释Samples

2023-03-08

详解12c的v$pwfile_user视图和Oracle11g区别

我们一起看看详解12c的v$pwfile_user视图和Oracle11g区别。V$PWFILE_USERS 列出的是password文件里已授予sysdba、sysoper权限的用户，如果查询没有记录，那就有可能没有了password文件了，没有了密码文件当然sqlplus sys/xx as sysdba这种用sys用sysdba用户就无法登录了。下面介绍一下11g和12c的v$pwfile_user视图。