V$INSTANCE视图

V$INSTANCE 展示当前实力的状态。See Also: “INSTANCE_NUMBER”STARTED – After STARTUP
NOMOUNTMOUNTED – After STARTUP MOUNT or
ALTER DATABASE CLOSEOPEN – After STARTUP or ALTER DATABASE OPEN免费云主机域名OPEN MIGRATE – After ALTER DATABASE OPEN {
UPGRADE | DOWNGRADE }STOPPEDSTARTEDFAILED – Archiver failed to archive a log last time but
will try again within 5 minutesARCHIVE LOGCLEAR LOGCHECKPOINTNULL – ALTER SYSTEM SWITCH LOGFILE is hung but there is
room in the current online redo logACTIVESUSPENDEDINSTANCE RECOVERYNORMAL – 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.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 rootn: Where n is the
applicable container ID for the rows containing dataPossible values:REGULAR: A regular Oracle RAC instanceREAD MOSTLY: An Oracle RAC instance which has very few
database writesPossible values include:CORE EE: CORE Enterprise EditionCORE SE: CORE Standard EditionEE: Enterprise EditionPO: Personal EditionSE: Standard EditionXE: Express Edition

相关推荐: 浅析oracle b-tree index搜索原理

索引与表一样，也属于段（segment）的一种。里面存放了用户的数据，跟表一样需要占用磁盘空间。只不过，在索引里的数据存放形式与表里的数据存放形式非常的不一样。在理解索引时，可以想象一本书，其中书的内容就相当于表里的数据，而书前面的目录就相当于该表的索引。同时…