扫二维码与项目经理沟通
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流
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:
|
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:
|
LOG_SWITCH_WAIT | VARCHAR2(15) | Event that log
switching is waiting for:
|
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:
|
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:
A single |
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:
|
INSTANCE_MODE | VARCHAR2(11) | Mode of the Oracle Real
Application Clusters (Oracle RAC) instance. Possible values:
|
EDITION | VARCHAR2(7) | The edition of the
database. Possible values include:
|
FAMILY | VARCHAR2(80) | For internal use only. |
我们在微信上24小时期待你的声音
解答本文疑问/技术咨询/运营咨询/技术建议/互联网交流