V$INSTANCEV$INSTANCE 展示当前实力的状态。ColumnDatatypeDescriptionINSTANCE_NUMBERNUMBERInstance number used for instance registration (corresponds to the INSTANCE_NUMBER initialization parameter)See Also: "INS
V$PROCESSV$PROCESS 展示当前数据库的活动进程信息。ColumnDatatypeDescriptionADDRRAW(4 | 8)Address of the process state objectPIDNUMBEROracle process identifierSOSIDVARCHAR2(24)Operating system (process, thread) id
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1069.htmV$BH displays the status and number of pings for every buffer in the SGA. This is a Real Application Clusters view.ColumnDatatype
http://docs.oracle.com/database/121/REFRN/refrn30109.htmV$LATCH_CHILDRENV$LATCH_CHILDREN displays statistics about child latches. This view includes all columns of V$LATCH plus the CHILD# column. Note
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN13025ADR(Automatic Diagnostic Repository) Directory structure for a Database Instance 通过V$DIAG_INFO视图查看ADR分布位置信息：SELECT *&
http://docs.oracle.com/cd/E11882_01/server.112/e40402/statviews_4069.htm
SQL> desc v$archived_log; Name &
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
