Tuesday, September 23, 2008

New Dynamic Performance Views in Oracle 11g

GV$ Views

V$ Views

GV$ASM_ATTRIBUTE

V$ASM_ATTRIBUTE

GV$ASM_DISK_IOSTAT

V$ASM_DISK_IOSTAT

GV$CALLTAG

V$CALLTAG

GV$CLIENT_RESULT_CACHE_STATS

V$CLIENT_RESULT_CACHE_STATS

GV$CORRUPT_XID_LIST

V$CORRUPT_XID_LIST

GV$CPOOL_CC_INFO

V$CPOOL_CC_INFO

GV$CPOOL_CC_STATS

V$CPOOL_CC_STATS

GV$CPOOL_STATS

V$CPOOL_STATS

GV$DETACHED_SESSION

V$DETACHED_SESSION

GV$DIAG_INFO

V$DIAG_INFO

GV$DNFS_CHANNELS

V$DNFS_CHANNELS

GV$DNFS_FILES

V$DNFS_FILES

GV$DNFS_SERVERS

V$DNFS_SERVERS

GV$DNFS_STATS

V$DNFS_STATS

GV$DYNAMIC_REMASTER_STATS

V$DYNAMIC_REMASTER_STATS

GV$ENCRYPTED_TABLESPACES

V$ENCRYPTED_TABLESPACES

GV$ENCRYPTION_WALLET

V$ENCRYPTION_WALLET

V$FLASHBACK_TXN_GRAPH

V$FLASHBACK_TXN_MODS

GV$FOREIGN_ARCHIVED_LOG

V$FOREIGN_ARCHIVED_LOG

GV$FS_FAILOVER_HISTOGRAM

V$FS_FAILOVER_HISTOGRAM

GV$FS_FAILOVER_STATS

V$FS_FAILOVER_STATS

GV$HM_CHECK

V$HM_CHECK

GV$HM_CHECK_PARAM

V$HM_CHECK_PARAM

GV$HM_FINDING

V$HM_FINDING

GV$HM_INFO

V$HM_INFO

GV$HM_RECOMMENDATION

V$HM_RECOMMENDATION

GV$HM_RUN

V$HM_RUN

GV$INCMETER_CONFIG

V$INCMETER_CONFIG

GV$INCMETER_INFO

V$INCMETER_INFO

GV$INCMETER_SUMMARY

V$INCMETER_SUMMARY

GV$IOFUNCMETRIC

V$IOFUNCMETRIC

GV$IOFUNCMETRIC_HISTORY

V$IOFUNCMETRIC_HISTORY

GV$IOSTAT_CONSUMER_GROUP

V$IOSTAT_CONSUMER_GROUP

GV$IOSTAT_FILE

V$IOSTAT_FILE

GV$IOSTAT_FUNCTION

V$IOSTAT_FUNCTION

GV$IOSTAT_NETWORK

V$IOSTAT_NETWORK

GV$IO_CALIBRATION_STATUS

V$IO_CALIBRATION_STATUS

GV$IR_FAILURE

V$IR_FAILURE

GV$IR_FAILURE_SET

V$IR_FAILURE_SET

GV$IR_MANUAL_CHECKLIST

V$IR_MANUAL_CHECKLIST

GV$IR_REPAIR

V$IR_REPAIR

GV$LOBSTAT

V$LOBSTAT

GV$MEMORY_CURRENT_RESIZE_OPS

V$MEMORY_CURRENT_RESIZE_OPS

GV$MEMORY_DYNAMIC_COMPONENTS

V$MEMORY_DYNAMIC_COMPONENTS

GV$MEMORY_RESIZE_OPS

V$MEMORY_RESIZE_OPS

GV$MEMORY_TARGET_ADVICE

V$MEMORY_TARGET_ADVICE

GV$NFS_CLIENTS

V$NFS_CLIENTS

GV$NFS_LOCKS

V$NFS_LOCKS

GV$NFS_OPEN_FILES

V$NFS_OPEN_FILES

V$OBJECT_PRIVILEGE

GV$PERSISTENT_PUBLISHERS

V$PERSISTENT_PUBLISHERS

GV$PERSISTENT_QUEUES

V$PERSISTENT_QUEUES

GV$PERSISTENT_SUBSCRIBERS

V$PERSISTENT_SUBSCRIBERS

GV$PROCESS_GROUP

V$PROCESS_GROUP

GV$PX_INSTANCE_GROUP

V$PX_INSTANCE_GROUP

GV$REDO_DEST_RESP_HISTOGRAM

V$REDO_DEST_RESP_HISTOGRAM

GV$RESULT_CACHE_DEPENDENCY

V$RESULT_CACHE_DEPENDENCY

GV$RESULT_CACHE_MEMORY

V$RESULT_CACHE_MEMORY

GV$RESULT_CACHE_OBJECTS

V$RESULT_CACHE_OBJECTS

GV$RESULT_CACHE_STATISTICS

V$RESULT_CACHE_STATISTICS

GV$RMAN_COMPRESSION_ALGORITHM

V$RMAN_COMPRESSION_ALGORITHM

V$RMAN_ENCRYPTION_ALGORITHMS

GV$RSRCMGRMETRIC

V$RSRCMGRMETRIC

GV$RSRCMGRMETRIC_HISTORY

V$RSRCMGRMETRIC_HISTORY

GV$SECUREFILE_TIMER

V$SECUREFILE_TIMER

V$SESSION_FIX_CONTROL

GV$SQL_CS_HISTOGRAM

V$SQL_CS_HISTOGRAM

GV$SQL_CS_SELECTIVITY

V$SQL_CS_SELECTIVITY

GV$SQL_CS_STATISTICS

V$SQL_CS_STATISTICS

GV$SQL_FEATURE

V$SQL_FEATURE

GV$SQL_FEATURE_DEPENDENCY

V$SQL_FEATURE_DEPENDENCY

GV$SQL_FEATURE_HIERARCHY

V$SQL_FEATURE_HIERARCHY

GV$SQL_HINT

V$SQL_HINT

GV$SQL_MONITOR

V$SQL_MONITOR

GV$SQL_PLAN_MONITOR

V$SQL_PLAN_MONITOR

GV$SQLFN_ARG_METADATA

V$SQLFN_ARG_METADATA

GV$SQLFN_METADATA

V$SQLFN_METADATA

GV$SSCR_SESSIONS

V$SSCR_SESSIONS

GV$STREAMS_MESSAGE_TRACKING

V$STREAMS_MESSAGE_TRACKING

GV$SUBSCR_REGISTRATION_STATS

V$SUBSCR_REGISTRATION_STATS

V$SYSTEM_FIX_CONTROL

V$WAIT_CHAINS

GV$WORKLOAD_REPLAY_THREAD

V$WORKLOAD_REPLAY_THREAD

V$XS_SESSION

V$XS_SESSION_ATTRIBUTE

V$XS_SESSION_ROLE

Oracle data dictionary views

Oracle dynamic performance views

No comments:

Post a Comment