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

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$	active	active
V$ACCESS	active	active	active	active
V$ACTIVE_INSTANCES	active	active	active	active
V$ACTIVE_SESS_POOL_MTH				active
V$AQ		active	active	active
V$ARCHIVE	active	active	active	active
V$ARCHIVE_DEST		active	active	active
V$ARCHIVE_DEST_STATUS				active
V$ARCHIVE_GAP				active
V$ARCHIVE_PROCESSES			active	active
V$ARCHIVED_LOG		active	active	active
V$BACKUP	active	active	active	active
V$BACKUP_ASYNC_IO			active	active
V$BACKUP_CORRUPTION		active	active	active
V$BACKUP_DATAFILE		active	active	active
V$BACKUP_DEVICE		active	active	active
V$BACKUP_PIECE		active	active	active
V$BACKUP_REDOLOG		active	active	active
V$BACKUP_SET		active	active	active
V$BACKUP_SPFILE				active
V$BACKUP_SYNC_IO			active	active
V$BGPROCESS	active	active	active	active
V$BH	active	active	active	active
V$BSP			active
V$BUFFER_POOL		active	active	active
V$BUFFER_POOL_STATISTICS			active	active
V$CACHE	active	active	active	active
V$CACHE_LOCK	active	active	active	active
V$CACHE_TRANSFER				active
V$CIRCUIT	active	active	active	active
V$CLASS_CACHE_TRANSFER				active
V$CLASS_PING		active	active
V$COMPATIBILITY	active	active	active	active
V$COMPATSEG	active	active	active	active
V$CONTEXT			active	active
V$CONTROLFILE	active	active	active	active
V$CONTROLFILE_RECORD_SECTION		active	active	active
V$COPY_CORRUPTION		active	active	active
V$CR_BLOCK_SERVER				active
V$CURRENT_BUCKET		active
V$DATABASE	active	active	active	active
V$DATABASE_BLOCK_CORRUPTION				active
V$DATABASE_INCARNATION				active
V$DATAFILE	active	active	active	active
V$DATAFILE_COPY		active	active	active
V$DATAFILE_HEADER		active	active	active
V$DATAGUARD_STATUS				active
V$DB_CACHE_ADVICE				active
V$DB_OBJECT_CACHE				active
V$DB_PIPES				active
V$DBFILE	active	active	active	active
V$DBLINK	active	active	active	active
V$DB_OBJECT_CACHE	active	active	active
V$DB_PIPES	active	active	active
V$DELETED_OBJECT		active	active	active
V$DISPATCHER	active	active	active	active
V$DISPATCHER_RATE		active	active	active
V$DLM_ALL_LOCKS			active
V$DLM_CONVERT_LOCAL		active	active
V$DLM_CONVERT_REMOTE		active	active
V$DLM_LATCH		active	active
V$DLM_LOCKS		active	active
V$DLM_MISC		active	active
V$DLM_RESS			active
V$ENABLEDPRIVS	active	active	active	active
V$ENQUEUE_LOCK		active	active	active
V$ENQUEUE_STAT				active
V$EVENT_NAME	active	active	active	active
V$EXECUTION		active	active	active
V$EXECUTION_LOCATION		active
V$FALSE_PING	active	active	active	active
V$FAST_START_SERVERS			active	active
V$FAST_START_TRANSACTIONS			active	active
V$FILE_CACHE_TRANSFER				active
V$FILE_PING		active	active
V$FILESTAT	active	active	active	active
V$FIXED_TABLE	active	active	active	active
V$FIXED_VIEW_DEFINITION	active	active	active	active
V$GC_ELEMENT				active
V$GC_ELEMENTS_WITH_COLLISIONS				active
V$GCSHVMASTER_INFO				active
V$GCSPFMASTER_INFO				active
V$GES_BLOCKING_ENQUEUE				active
V$GES_CONVERT_LOCAL				active
V$GES_CONVERT_REMOTE				active
V$GES_ENQUEUE				active
V$GES_LATCH				active
V$GES_RESOURCE				active
V$GES_STATISTICS				active
V$GLOBAL_BLOCKED_LOCKS			active	active
V$GLOBAL_TRANSACTION		active	active	active
V$HS_AGENT			active	active
V$HS_PARAMETER			active	active
V$HS_SESSION			active	active
V$HVMASTER_INFO				active
V$INDEXED_FIXED_COLUMN	active	active	active	active
V$INSTANCE	active	active	active	active
V$INSTANCE_RECOVERY			active	active
V$LATCH	active	active	active	active
V$LATCH_CHILDREN	active	active	active	active
V$LATCH_MISSES	active	active	active	active
V$LATCH_PARENT	active	active	active	active
V$LATCHHOLDER	active	active	active	active
V$LATCHNAME	active	active	active	active
V$LIBRARY_CACHE_MEMORY				active
V$LIBRARYCACHE	active	active	active	active
V$LICENSE	active	active	active	active
V$LOADCSTAT	active	active	active
V$LOADISTAT				active
V$LOADPSTAT				active
V$LOADTSTAT	active	active	active
V$LOCK	active	active	active	active
V$LOCK_ACTIVITY	active	active	active	active
V$LOCK_ELEMENT	active	active	active
V$LOCKED_OBJECT	active	active	active	active
V$LOCKS_WITH_COLLISIONS	active	active	active
V$LOG	active	active	active	active
V$LOG_HISTORY	active	active	active	active
V$LOGFILE	active	active	active	active
V$LOGHIST	active	active	active	active
V$LOGMNR_CONTENTS			active	active
V$LOGMNR_DICTIONARY			active	active
V$LOGMNR_LOGS			active	active
V$LOGMNR_PARAMETERS			active	active
V$LOGSTDBY				active
V$LOGSTDBY_STATS				active
V$MANAGED_STANDBY				active
V$MAP_COMP_LIST				active
V$MAP_ELEMENT				active
V$MAP_EXT_ELEMENT				active
V$MAP_FILE				active
V$MAP_FILE_EXTENT				active
V$MAP_FILE_IO_STACK				active
V$MAP_LIBRARY				active
V$MAP_SUBELEMENT				active
V$MLS_PARAMETERS	active	active
V$MTS	active	active	active
V$MTTR_TARGET_ADVICE				active
V$MYSTAT	active	active	active	active
V$NLS_PARAMETERS	active	active	active	active
V$NLS_VALID_VALUES	active	active	active	active
V$OBJECT_DEPENDENCY	active	active	active	active
V$OBJECT_USAGE				active
V$OBSOLETE_PARAMETER			active	active
V$OFFLINE_RANGE		active	active	active
V$OPEN_CURSOR	active	active	active	active
V$OPTION	active	active	active	active
V$PARALLEL_DEGREE_LIMIT_MTH			active	active
V$PARAMETER	active	active	active	active
V$PARAMETER2				active
V$PING	active	active	active
V$PGA_TARGET_ADVICE				active
V$PGA_TARGET_ADVICE_HISTOGRAM				active
V$PGASTAT				active
V$PQ_SESSTAT	active	active	active	active
V$PQ_SLAVE	active	active	active	active
V$PQ_SYSSTAT	active	active	active	active
V$PQ_TQSTAT	active	active	active	active
V$PROCESS	active	active	active	active
V$PROXY_ARCHIVEDLOG			active	active
V$PROXY_DATAFILE			active	active
V$PWFILE_USERS	active	active	active	active
V$PX_PROCESS			active	active
V$PX_PROCESS_SYSSTAT			active	active
V$PX_SESSION			active	active
V$PX_SESSTAT			active	active
V$QUEUE	active	active	active	active
V$QUEUEING_MTH				active
V$RECENT_BUCKET		active
V$RECOVER_FILE	active	active	active	active
V$RECOVERY_FILE_STATUS	active	active	active	active
V$RECOVERY_LOG	active	active	active	active
V$RECOVERY_PROGRESS		active	active	active
V$RECOVERY_STATUS	active	active	active	active
V$REQDIST	active	active	active	active
V$RESERVED_WORDS			active	active
V$RESOURCE	active	active	active	active
V$RESOURCE_LIMIT		active	active	active
V$RMAN_CONFIGURATION				active
V$ROLLNAME	active	active	active	active
V$ROLLSTAT	active	active	active	active
V$ROWCACHE	active	active	active	active
V$ROWCACHE_PARENT			active	active
V$ROWCACHE_SUBORDINATE			active	active
V$RSRC_CONSUMER_GROUP			active	active
V$RSRC_CONSUMER_GROUP_CPU_MTH			active	active
V$RSRC_PLAN			active	active
V$RSRC_PLAN_CPU_MTH			active	active
V$SECONDARY	active
V$SEGMENT_STATISTICS				active
V$SEGSTAT				active
V$SEGSTAT_NAME				active
V$SESS_IO	active	active	active	active
V$SESSION	active	active	active	active
V$SESSION_CONNECT_INFO	active	active	active	active
V$SESSION_CURSOR_CACHE	active	active	active	active
V$SESSION_EVENT	active	active	active	active
V$SESSION_LONGOPS		active	active	active
V$SESSION_OBJECT_CACHE		active	active	active
V$SESSION_WAIT	active	active	active	active
V$SESSTAT	active	active	active	active
V$SGA	active	active	active	active
V$SGA_CURRENT_RESIZE_OPS				active
V$SGA_RESIZE_OPS				active
V$SGA_DYNAMIC_COMPONENTS				active
V$SGA_DYNAMIC_FREE_MEMORY				active
V$SGASTAT	active	active	active	active
V$SHARED_POOL_ADVICE				active
V$SHARED_POOL_RESERVED	active	active	active	active
V$SHARED_SERVER	active	active	active	active
V$SHARED_SERVER_MONITOR				active
V$SORT_SEGMENT	active	active	active	active
V$SORT_USAGE		active	active
V$SPPARAMETER				active
V$SQL	active	active	active	active
V$SQL_BIND_DATA		active	active	active
V$SQL_BIND_METADATA		active	active	active
V$SQL_CURSOR		active	active	active
V$SQL_PLAN				active
V$SQL_PLAN_STATISTICS				active
V$SQL_PLAN_STATISTICS_ALL				active
V$SQL_REDIRECTION				active
V$SQL_SHARED_CURSOR				active
V$SQL_SHARED_MEMORY		active	active	active
V$SQL_WORKAREA				active
V$SQL_WORKAREA_ACTIVE				active
V$SQL_WORKAREA_HISTOGRAM				active
V$SQLAREA	active	active	active	active
V$SQLTEXT	active	active	active	active
V$SQLTEXT_WITH_NEWLINES	active	active	active	active
V$STANDBY_LOG				active
V$STATISTICS_LEVEL				active
V$STATNAME	active	active	active	active
V$STREAMS_APPLY_COORDINATOR				active
V$STREAMS_APPLY_READER				active
V$STREAMS_APPLY_SERVER				active
V$STREAMS_CAPTURE				active
V$SUBCACHE		active	active	active
V$SYSLABEL	active
V$SYSSTAT	active	active	active	active
V$SYSTEM_CURSOR_CACHE	active	active	active	active
V$SYSTEM_EVENT	active	active	active	active
V$SYSTEM_PARAMETER	active	active	active	active
V$SYSTEM_PARAMETER2				active
V$TABLESPACE		active	active	active
V$TEMP_CACHE_TRANSFER				active
V$TEMP_EXTENT_MAP			active	active
V$TEMP_EXTENT_POOL			active	active
V$TEMP_PING			active
V$TEMP_SPACE_HEADER			active	active
V$TEMPFILE			active	active
V$TEMPORARY_LOBS			active	active
V$TEMPSEG_USAGE				active
V$TEMPSTAT			active	active
V$THREAD	active	active	active	active
V$TIMER	active	active	active	active
V$TIMEZONE_NAMES				active
V$TRANSACTION	active	active	active	active
V$TRANSACTION_ENQUEUE		active	active	active
V$TYPE_SIZE	active	active	active	active
V$UNDOSTAT				active
V$VERSION	active	active	active	active
V$VPD_POLICY				active
V$WAITSTAT	active	active	active	active
Всего:	102	142	178	237

© 2003-2004 «DBGroup Consulting»