oracle常用动态性能表(有书签)

C(V$)V$zzC.1OracleSYSCATALOG.SQLCATALOG.SQLC.1.1V$V_$V$V$V_$OracleTraceOracleTraceV$C.1.2GV$OracleGV$GlobalV$V$V$V$CACHE_LOCKV$LOCK_ACTIVITYV$LOCKS_WITH_COLLISIONSV$ROLLNAMEGV$GV$V$V$GV$INST_IDINST_IDV$INST_IDV$SELECT*FROMGV$LOCKWHEREINST_ID=2ORINST_ID=525V$GV$OPS_ADMIN_GROUPGV$zPARALLEL_MAX_SERVERSzOPS_ADMIN_GROUPC.1.2SYSSYSDBAROLEC.21V$ACCESSSIDNUMBEROWNERVARCHAR2(64)OBJECTVARCHAR2(1000)TYPEVARCHAR2(12)2V$ACTIVE_INSTANCESINST_NUMBERNUMBERINST_NAMEVARCHAR2(60)3V$AQQIDNUMBERWAITINGNUMBERWAITINGREADYNUMBERREADYEXPIREDNUMBEREXPIREDTOTAL_WAITNUMBERREADYAVERAGE_WAITNUMBERREADY4V$ARCHIVEV$LOGOracleV$LOGV$LOGGROUP#NUMBERTHREAD#NUMBERSEQUENCE#NUMBERCURRENT#VARCHAR2(3)FIRST_CHANGE#NUMBERSCN5V$ARCHIVE_DEST,DEST_IDNUMBERID(1-5)STATUSVARCHAR2(9)VAILIDINACTIVEDEFERREDERRORDISABLEDBADPARAMBINDINGVARCHAR2(9)MANDATORY-OPTIONAL-LOG_ARCHIVE_MIS_SUCCEED_DESTNAME_SPACEVARCHAR2(7)SYSTEM-SESSION-TARGETVARCHAR2(7)PRIMARY-STANDBY-REOPEN_SECSVARCHAR2(7)DESTINATIONVARCHAR2(256)FAIL_DATEDATEFAIL_SEQUENCENUMBERFAIL_BLOCKNUMBERERRORVARCHAR2(256),LOG_ARCHIVE_DESTLOG_ARCHIVE_DUPLEX_DESTLOG_ARCHIVE_DEST_nLOG_ARCHIVE_DEST_STATE_nSTANDBY_ARCHIVE_DESTLOG_ARCHIVE_MIN_SUCCEED_DEST6V$ARCHIVE_LOGNULLTHREAD#SEQUENCE#FIRST_CHANGE#RECIDNUMBERIDSTAMPNUMBERNAMEVARCHAR2(512)NULLTHREAD#NUMBERSEQUENCE#NUMBERRESETLOGS_CHANGE#NUMBERRESETLOGS_TIMEDATEFIRST_CHANGE#NUMBERFIRST_TIMENUMBERNEXT_CHANGE#NUMBERNEXT_TIMENUMBERBLOCKSNUMBERBLOCK_SIZENUMBERARCHIVEDVARCHAR2(3)YES/NODELETEDVARCHAR2(3)YES/NOCOMPLETION_TIMEDATE7V$ARCHIVE_PROCESSESARCHPROCESSNUMBERARCH09STATUSVARCHAR2(10)ARCHSTOPPEDSCHEDULEDSTARTINGACTIVESTOPPINGTERMINATEDLOG_SEQUENCENUMBERSTATE=BUSYSTATEVARCHAR2(4)ARCHIDLEBUSY8V$BACKUPFILE#NUMBERSTATUSVARCHAR2(18)NOTACTIVEACTIVE()OFFINENORMALCHANGE#NUMBERTIMEDATE9V$BACKUP_ASYNC_IOSIDNUMBEROracleSIDSERIALNUMBERSIDUSE_COUNTNUMBERDEVICE_TYPEVARCHAR2(17)TYPEVARCHAR2(9)INPUTOUTPUTAGGREGATESTATUSVARCHAR2(11)NOTSTARTEDINPROGRESSFINISHEDFILENAMEVARCHAR2(513)SET_COUNTNUMBERSET_STAMPNUMBERBUFFER_SIZENUMBERBUFFER_COUNTNUMBERTOTAL_BYTESNUMBEROPEN_TIMEDATETYPE=AGGREGATECLOSE_TIMEDATETYPE=AGGREGATEELAPSED_TIMENUMBERMAXOPENFILESNUMBERTYPE=’AGGREGATE’BYTESNUMBERBFFECTIVE_BYTES_PER_SECONDNUMBERI/OIO_COUNTNUMBERI/OREADYNUMBERSHORT_WAITSNUMBERI/OSHORT_WAIT_TIME_TOTALNUMBERI/OSHORT_WAIT_TIME_MAXNUMBERI/OLOG_WAITSNUMBERI/OLOG_WAITSNUMBERI/OLOG_WAITS_TIME_TOTALNUMBERI/OLOG_WAITS_TIME_MAXNUMBERI/O10V$BACKUP_CORRUPTIONRECIDNUMBERIDSTAMPNUMBERSET_STAMPNUMBERSET_COUNTNUMBERPIECE#NUMBERFILE#NUMBERBLOCK#NUMBERBLOCKSNUMBERCORRUPTION_CHANGE#NUMBER0MARKED_CURRUPTVARCHAR2(3)YES/NOYES11V$BACKUP_DATAFILERECIDNUMBERIDSTAMPNUMBERSET_STAMPNUMBERSET_COUNTNUMBERFILE#NUMBERCREATION_CHANGE#NUMBERCREATE_TIMEDATERESETLOGS_CHANGE#NUMBERRESETLOGS_TIME#DATEINCREMENTAL_LEVELNUMBER(0~4)INCREMENTAL_CHANGE#NUMBER0CHECKPOINT_CHANGE#NUMBERCHECKPOINT_TIMEDATEABSOLUTE_FUZZY_CHANGE#NUMBERMARKED_CORRUPTNUMBERMEDIA_CORRUPTNUMBERLOGICALLY_CORRUPTNUMBERDATAFILE_BLOCKSNUMBERBLOCKSNUMBERBLOCKSNUMBEROLDEST_OFFLINE_RANGENUMBERRECID0COMPLETION_TIMEDATE12V$BACKUP_DEVICEDISKDEVICE_TYPEVARCHAR2(17)DEVICE_NAMEVARCHAR2(512)13V$BACKUP_PIECERECIDNUMBERIDSTAMPNUMBERSET_STAMPNUMBERSET_COUNTNUMBERPIECE#NUMBER1~nCOPY#NUMBER1DEVICE_TYPEVARCHAR2(17)DISKV$BACKUP_DEVICEHANDLEVARCHAR2(513)COMMENTSVARCHAR2(81)NULLMEDIAVARCHAR2(65)MEDIA_POOLNUMBERRecoveryManagerBACKUPPOOLCONCURVARCHAR2(3)YES/NOTAGVARCHAR2(32)DELETEDVARCHAR2(3)YESNOSTART_TIMEDATECOMPLETION_TIMEDATEELAPSED_SECONDSNUMBER14V$BACKUP_REDOLOGRECIDNUMBERIDSTAMPNUMBERRECIDSET_STAMPNUMBERSET_COUNTNUMBERV$BACKUP_SETTHREAD#NUMBERSEQUENCE#NUMBERRESETLOGS_CHANGE#NUMBERRESETLOGS_TIMEDATEFIRST_CHANGE#NUMBERSCNSCNFIRST_TIMEDATENEXT_CHANGE#NUMBERSCNSCNNEXT_TIMEDATEBLOCKSNUMBERBLOCK_SIZENUMBER15V$BACKUP_SETRECIDNUMBERIDSTAMPNUMBERET_STAMPNUMBERV$BACKUP_PIECEV$BACKUP_DATAFILEV$BACKUP_REDOLOGV$BACKUP_CORRUPTIONSET_COUNTNUMBER11V$BACKUP_PIECEV$BACKUP_PIECEV$BACKUP_DATAFILEV$BACKUP_REDOLOGV$BACKUP_CORRUPTIONBACKUP_TYPEVARCHAR2(1)LDICONTROLFILE_INCLUDEDVARCHAR2(3)YESNOINCREMENTAL_LEVELNUMBERNULLPIECESNUMBERSTART_TIMEDATECOMPLETION_TIMEDATEbackupEndNULLELAPSED_SECONDSNUMBERBLOCK_SIZENUMBER16V$BACKUP_SYNC_IOSIDNUMBEROracleSIDSERIALNUMBERSIDUSE_COUNTNUMBERDEVICE_TYPEVARCHAR2(17)TYPEVARCHAR2(9)INPUTOUTPUTAGGREGATESTATUSVARCHAR2(11)NOTSTARTEDINPROGRESSFINISHEDFILENAMEVARCHAR2(512)SET_COUNTNUMBERSET_STAMPNUMBERBUFFER_SIZENUMBERBUFFEER_COUNTNUMBERTOTAL_BYTESNUMBEROPEN_TIMEDATETYPE=’AGGREGATE’CLOSE_TIMEDATETYPE=’AGGREGATE’ELAPSED_TIMEDATEMAXOPENFILESNUMVERTYPE=’AGGREGATE’BYTESNUMBERBFFECTIVE_BYTES_PER_SECONDNUMBERI/OIO_COUNTNUMBERI/OI/O_TIME_TOTALNUMBERI/OI/O_TIME_MAXNUMBERI/ODISCRETE_BYTESPER_SECONDNUMBER17V$BGPROCESSPADDRRAW(4)NAMEVARCHAR2DESCRIPTIONVARCHAR2ERRORNUMBER18V$BHSGApingFILE#NUMBERDB_DATA_FILESV$DBFILESBOLCK#NUMBERCLASS#NUMBERSTATUSVARCHAR2(1)FREE=XCUR=SCUR=CR=READ=MREC=IREC=XNCNUMBERPCMxLOCK_ELEMENT_ADDRRAW(4)PCMPCMLOCK_ELEMENT_NAMENUMBERPCMPCMLOCK_ELEMENT_CLASSNUMBERPCMPCMFORCED_READSNUMBERPCMFORCED_WRITESNUMBERPCMDBWRDIRTYVARCHAR(1)Y=DIRTYVARCHAR(1)Y=DIRTYVARCHAR(1)Y=pingDIRTYVARCHAR