Ноябрь 2004


Советы, рекомендации, опыт


Oracle Server
Dynamic Performance Views

Источник: сайт компании «DBGroup Consulting»,
http://www.dbgroup.ru/stuff/oramanual/dynamic/

Имя Параметра  7.3.4  8.0.5(6)8.1.6(7)  9.2.0  
FILEXT$activeactive
V$ACCESSactiveactiveactiveactive
V$ACTIVE_INSTANCESactiveactiveactiveactive
V$ACTIVE_SESS_POOL_MTHactive
V$AQactiveactiveactive
V$ARCHIVEactiveactiveactiveactive
V$ARCHIVE_DEST activeactiveactive
V$ARCHIVE_DEST_STATUSactive
V$ARCHIVE_GAPactive
V$ARCHIVE_PROCESSESactiveactive
V$ARCHIVED_LOGactiveactiveactive
V$BACKUPactiveactiveactiveactive
V$BACKUP_ASYNC_IOactiveactive
V$BACKUP_CORRUPTIONactiveactiveactive
V$BACKUP_DATAFILEactiveactiveactive
V$BACKUP_DEVICEactiveactiveactive
V$BACKUP_PIECEactiveactiveactive
V$BACKUP_REDOLOGactiveactiveactive
V$BACKUP_SETactiveactiveactive
V$BACKUP_SPFILEactive
V$BACKUP_SYNC_IOactiveactive
V$BGPROCESSactiveactiveactiveactive
V$BHactiveactiveactiveactive
V$BSPactive
V$BUFFER_POOLactiveactiveactive
V$BUFFER_POOL_STATISTICSactiveactive
V$CACHEactiveactiveactiveactive
V$CACHE_LOCKactiveactiveactiveactive
V$CACHE_TRANSFERactive
V$CIRCUITactiveactiveactiveactive
V$CLASS_CACHE_TRANSFERactive
V$CLASS_PINGactiveactive
V$COMPATIBILITYactiveactiveactiveactive
V$COMPATSEGactiveactiveactiveactive
V$CONTEXTactiveactive
V$CONTROLFILEactiveactiveactiveactive
V$CONTROLFILE_RECORD_SECTIONactiveactiveactive
V$COPY_CORRUPTIONactiveactiveactive
V$CR_BLOCK_SERVERactive
V$CURRENT_BUCKETactive
V$DATABASEactiveactiveactiveactive
V$DATABASE_BLOCK_CORRUPTIONactive
V$DATABASE_INCARNATIONactive
V$DATAFILEactiveactiveactiveactive
V$DATAFILE_COPYactiveactiveactive
V$DATAFILE_HEADERactiveactiveactive
V$DATAGUARD_STATUSactive
V$DB_CACHE_ADVICEactive
V$DB_OBJECT_CACHEactive
V$DB_PIPESactive
V$DBFILEactiveactiveactiveactive
V$DBLINKactiveactiveactiveactive
V$DB_OBJECT_CACHEactiveactiveactive
V$DB_PIPESactiveactiveactive
V$DELETED_OBJECTactiveactiveactive
V$DISPATCHERactiveactiveactiveactive
V$DISPATCHER_RATEactiveactiveactive
V$DLM_ALL_LOCKSactive
V$DLM_CONVERT_LOCALactiveactive
V$DLM_CONVERT_REMOTEactiveactive
V$DLM_LATCHactiveactive
V$DLM_LOCKSactiveactive
V$DLM_MISCactiveactive
V$DLM_RESSactive
V$ENABLEDPRIVSactiveactiveactiveactive
V$ENQUEUE_LOCKactiveactiveactive
V$ENQUEUE_STATactive
V$EVENT_NAMEactiveactiveactiveactive
V$EXECUTIONactiveactiveactive
V$EXECUTION_LOCATIONactive
V$FALSE_PINGactiveactiveactiveactive
V$FAST_START_SERVERSactiveactive
V$FAST_START_TRANSACTIONSactiveactive
V$FILE_CACHE_TRANSFERactive
V$FILE_PINGactiveactive
V$FILESTATactiveactiveactiveactive
V$FIXED_TABLEactiveactiveactiveactive
V$FIXED_VIEW_DEFINITIONactiveactiveactiveactive
V$GC_ELEMENTactive
V$GC_ELEMENTS_WITH_COLLISIONSactive
V$GCSHVMASTER_INFOactive
V$GCSPFMASTER_INFOactive
V$GES_BLOCKING_ENQUEUEactive
V$GES_CONVERT_LOCALactive
V$GES_CONVERT_REMOTEactive
V$GES_ENQUEUEactive
V$GES_LATCHactive
V$GES_RESOURCEactive
V$GES_STATISTICSactive
V$GLOBAL_BLOCKED_LOCKSactiveactive
V$GLOBAL_TRANSACTIONactiveactiveactive
V$HS_AGENTactiveactive
V$HS_PARAMETERactiveactive
V$HS_SESSIONactiveactive
V$HVMASTER_INFOactive
V$INDEXED_FIXED_COLUMNactiveactiveactiveactive
V$INSTANCEactiveactiveactiveactive
V$INSTANCE_RECOVERYactiveactive
V$LATCHactiveactiveactiveactive
V$LATCH_CHILDRENactiveactiveactiveactive
V$LATCH_MISSESactiveactiveactiveactive
V$LATCH_PARENTactiveactiveactiveactive
V$LATCHHOLDERactiveactiveactiveactive
V$LATCHNAMEactiveactiveactiveactive
V$LIBRARY_CACHE_MEMORYactive
V$LIBRARYCACHEactiveactiveactiveactive
V$LICENSEactiveactiveactiveactive
V$LOADCSTATactiveactiveactive
V$LOADISTATactive
V$LOADPSTATactive
V$LOADTSTATactiveactiveactive
V$LOCKactiveactiveactiveactive
V$LOCK_ACTIVITYactiveactiveactiveactive
V$LOCK_ELEMENTactiveactiveactive
V$LOCKED_OBJECTactiveactiveactiveactive
V$LOCKS_WITH_COLLISIONSactiveactiveactive
V$LOGactiveactiveactiveactive
V$LOG_HISTORYactiveactiveactiveactive
V$LOGFILEactiveactiveactiveactive
V$LOGHISTactiveactiveactiveactive
V$LOGMNR_CONTENTSactiveactive
V$LOGMNR_DICTIONARYactiveactive
V$LOGMNR_LOGSactiveactive
V$LOGMNR_PARAMETERSactiveactive
V$LOGSTDBYactive
V$LOGSTDBY_STATSactive
V$MANAGED_STANDBYactive
V$MAP_COMP_LISTactive
V$MAP_ELEMENTactive
V$MAP_EXT_ELEMENTactive
V$MAP_FILEactive
V$MAP_FILE_EXTENTactive
V$MAP_FILE_IO_STACKactive
V$MAP_LIBRARYactive
V$MAP_SUBELEMENTactive
V$MLS_PARAMETERSactiveactive
V$MTSactiveactiveactive
V$MTTR_TARGET_ADVICEactive
V$MYSTATactiveactiveactiveactive
V$NLS_PARAMETERSactiveactiveactiveactive
V$NLS_VALID_VALUESactiveactiveactiveactive
V$OBJECT_DEPENDENCYactiveactiveactiveactive
V$OBJECT_USAGEactive
V$OBSOLETE_PARAMETERactiveactive
V$OFFLINE_RANGEactiveactiveactive
V$OPEN_CURSORactiveactiveactiveactive
V$OPTIONactiveactiveactiveactive
V$PARALLEL_DEGREE_LIMIT_MTHactiveactive
V$PARAMETERactiveactiveactiveactive
V$PARAMETER2active
V$PINGactiveactiveactive
V$PGA_TARGET_ADVICEactive
V$PGA_TARGET_ADVICE_HISTOGRAMactive
V$PGASTATactive
V$PQ_SESSTATactiveactiveactiveactive
V$PQ_SLAVEactiveactiveactiveactive
V$PQ_SYSSTATactiveactiveactiveactive
V$PQ_TQSTATactiveactiveactiveactive
V$PROCESSactiveactiveactiveactive
V$PROXY_ARCHIVEDLOGactiveactive
V$PROXY_DATAFILEactiveactive
V$PWFILE_USERSactiveactiveactiveactive
V$PX_PROCESSactiveactive
V$PX_PROCESS_SYSSTATactiveactive
V$PX_SESSIONactiveactive
V$PX_SESSTATactiveactive
V$QUEUEactiveactiveactiveactive
V$QUEUEING_MTHactive
V$RECENT_BUCKETactive
V$RECOVER_FILEactiveactiveactiveactive
V$RECOVERY_FILE_STATUSactiveactiveactiveactive
V$RECOVERY_LOGactiveactiveactiveactive
V$RECOVERY_PROGRESSactiveactiveactive
V$RECOVERY_STATUSactiveactiveactiveactive
V$REQDISTactiveactiveactiveactive
V$RESERVED_WORDSactiveactive
V$RESOURCEactiveactiveactiveactive
V$RESOURCE_LIMITactiveactiveactive
V$RMAN_CONFIGURATIONactive
V$ROLLNAMEactiveactiveactiveactive
V$ROLLSTATactiveactiveactiveactive
V$ROWCACHEactiveactiveactiveactive
V$ROWCACHE_PARENTactiveactive
V$ROWCACHE_SUBORDINATEactiveactive
V$RSRC_CONSUMER_GROUPactiveactive
V$RSRC_CONSUMER_GROUP_CPU_MTHactiveactive
V$RSRC_PLANactiveactive
V$RSRC_PLAN_CPU_MTHactiveactive
V$SECONDARYactive
V$SEGMENT_STATISTICSactive
V$SEGSTATactive
V$SEGSTAT_NAMEactive
V$SESS_IOactiveactiveactiveactive
V$SESSIONactiveactiveactiveactive
V$SESSION_CONNECT_INFOactiveactiveactiveactive
V$SESSION_CURSOR_CACHEactiveactiveactiveactive
V$SESSION_EVENTactiveactiveactiveactive
V$SESSION_LONGOPSactiveactiveactive
V$SESSION_OBJECT_CACHEactiveactiveactive
V$SESSION_WAITactiveactiveactiveactive
V$SESSTATactiveactiveactiveactive
V$SGAactiveactiveactiveactive
V$SGA_CURRENT_RESIZE_OPSactive
V$SGA_RESIZE_OPSactive
V$SGA_DYNAMIC_COMPONENTSactive
V$SGA_DYNAMIC_FREE_MEMORYactive
V$SGASTATactiveactiveactiveactive
V$SHARED_POOL_ADVICEactive
V$SHARED_POOL_RESERVEDactiveactiveactiveactive
V$SHARED_SERVERactiveactiveactiveactive
V$SHARED_SERVER_MONITORactive
V$SORT_SEGMENTactiveactiveactiveactive
V$SORT_USAGEactiveactive
V$SPPARAMETERactive
V$SQLactiveactiveactiveactive
V$SQL_BIND_DATAactiveactiveactive
V$SQL_BIND_METADATAactiveactiveactive
V$SQL_CURSORactiveactiveactive
V$SQL_PLANactive
V$SQL_PLAN_STATISTICSactive
V$SQL_PLAN_STATISTICS_ALLactive
V$SQL_REDIRECTIONactive
V$SQL_SHARED_CURSORactive
V$SQL_SHARED_MEMORYactiveactiveactive
V$SQL_WORKAREAactive
V$SQL_WORKAREA_ACTIVEactive
V$SQL_WORKAREA_HISTOGRAMactive
V$SQLAREAactiveactiveactiveactive
V$SQLTEXTactiveactiveactiveactive
V$SQLTEXT_WITH_NEWLINESactiveactiveactiveactive
V$STANDBY_LOGactive
V$STATISTICS_LEVELactive
V$STATNAMEactiveactiveactiveactive
V$STREAMS_APPLY_COORDINATORactive
V$STREAMS_APPLY_READERactive
V$STREAMS_APPLY_SERVERactive
V$STREAMS_CAPTUREactive
V$SUBCACHEactiveactiveactive
V$SYSLABELactive
V$SYSSTATactiveactiveactiveactive
V$SYSTEM_CURSOR_CACHEactiveactiveactiveactive
V$SYSTEM_EVENTactiveactiveactiveactive
V$SYSTEM_PARAMETERactiveactiveactiveactive
V$SYSTEM_PARAMETER2active
V$TABLESPACEactiveactiveactive
V$TEMP_CACHE_TRANSFERactive
V$TEMP_EXTENT_MAPactiveactive
V$TEMP_EXTENT_POOLactiveactive
V$TEMP_PINGactive
V$TEMP_SPACE_HEADERactiveactive
V$TEMPFILEactiveactive
V$TEMPORARY_LOBSactiveactive
V$TEMPSEG_USAGEactive
V$TEMPSTATactiveactive
V$THREADactiveactiveactiveactive
V$TIMERactiveactiveactiveactive
V$TIMEZONE_NAMESactive
V$TRANSACTIONactiveactiveactiveactive
V$TRANSACTION_ENQUEUEactiveactiveactive
V$TYPE_SIZEactiveactiveactiveactive
V$UNDOSTATactive
V$VERSIONactiveactiveactiveactive
V$VPD_POLICYactive
V$WAITSTATactiveactiveactiveactive
Всего:102142178237

© 2003-2004 «DBGroup Consulting» 

E-mail this page