文章详情

登录

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

选择考试省份

  • 北京
  • 上海
  • 天津
  • 重庆
  • 河北
  • 山东
  • 辽宁
  • 黑龙江
  • 吉林
  • 甘肃
  • 青海
  • 河南
  • 江苏
  • 湖北
  • 湖南
  • 江西
  • 浙江
  • 广东
  • 云南
  • 福建
  • 海南
  • 山西
  • 四川
  • 陕西
  • 贵州
  • 安徽
  • 广西
  • 内蒙
  • 西藏
  • 新疆
  • 宁夏
  • 兵团

请输入下面的图形验证码

提交验证

短信预约提醒成功

V$INSTANCE视图

2024-04-02 19:55

关注

V$INSTANCE

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

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

See Also: "INSTANCE_NUMBER"

INSTANCE_NAMEVARCHAR2(16)Name of the instance
HOST_NAMEVARCHAR2(64)Name of the host machine
VERSIONVARCHAR2(17)Database version
STARTUP_TIMEDATETime when the instance was started
STATUSVARCHAR2(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 }

PARALLELVARCHAR2(3)Indicates whether the instance is mounted in cluster database mode (YES) or not (NO)
THREAD#NUMBERRedo thread opened by the instance
ARCHIVERVARCHAR2(7)Automatic archiving status:

  • STOPPED

  • STARTED

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

LOG_SWITCH_WAITVARCHAR2(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

LOGINSVARCHAR2(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_PENDINGVARCHAR2(3)Indicates whether a shutdown is pending (YES) or not (NO)
DATABASE_STATUSVARCHAR2(17)Status of the database:

  • ACTIVE

  • SUSPENDED

  • INSTANCE RECOVERY

INSTANCE_ROLEVARCHAR2(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_STATEVARCHAR2(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.

BLOCKEDVARCHAR2(3)Indicates whether all services are blocked (YES) or not (NO)
CON_IDNUMBERThe 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_MODEVARCHAR2(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

EDITIONVARCHAR2(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

FAMILYVARCHAR2(80)For internal use only.


阅读原文内容投诉

免责声明：

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

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

软考中级精品资料免费领

  • 历年真题答案解析
  • 备考技巧名师总结
  • 高频考点精准押题

  • 2024年上半年信息系统项目管理师第二批次真题及答案解析（完整版）

    难度     813人已做
    查看

  • 【考后总结】2024年5月26日信息系统项目管理师第2批次考情分析

    难度     354人已做
    查看

  • 【考后总结】2024年5月25日信息系统项目管理师第1批次考情分析

    难度     318人已做
    查看

  • 2024年上半年软考高项第一、二批次真题考点汇总（完整版）

    难度     435人已做
    查看

  • 2024年上半年系统架构设计师考试综合知识真题

    难度     224人已做
    查看

相关文章

发现更多好内容

猜你喜欢

AI推送时光机

V$INSTANCE视图

数据库2024-04-02

V$PROCESS视图

数据库2024-04-02

V$LATCH_CHILDREN视图

数据库2024-04-02

V$ACTIVE_SESSION_HISTORY视图的使用

数据库2024-04-02

什么是v$SQL视图

数据库2024-04-02

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

Oracle中V$视图和DBA_视图有什么区别
数据库2024-04-19

ADG备库v$archived_log 视图更新

数据库2024-04-02

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

数据库2023-07-05

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

数据库2023-03-08

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

详解12c的v$pwfile_user视图和Oracle11g区别
数据库2024-04-23

Oracle v$session视图显示客户端IP地址

Oracle v$session视图显示客户端IP地址
数据库2018-03-02

通过v$wait_chains视图诊断数据库hang和Contention

数据库2024-04-02

如何清除v$archived_log视图中的过期信息

数据库2024-04-02

如何理解Oracle11g和12c的v$pwfile_user视图及区别

数据库2024-04-02

通过 v$parameter 视图看参数修改级别(11g, 18c, 19c)

数据库2024-04-02

通过案例学调优之--动态视图（v$bh和x$bh)

数据库2024-04-02

Vue的v-if和v-show的区别图文介绍

数据库2023-03-06

如何利用v$session视图中client_info字段追踪客户端IP地址

数据库2024-04-02

Python+OpenCV绘制多instance的Mask图像

数据库2024-04-02

vue中v-for数据状态值变了但视图没改变如何解决

数据库2023-07-02
位置：首页-资讯-数据库
咦！没有更多了？去看看其它编程学习网 内容吧
首页课程
资料下载问答资讯