【12c新特性】12c中新增的V$动态视图

【12c新特性】12c中新增的V$动态视图:

select A.view_name from v$fixed_view_definition A where A.view_name not in (select B.view_name from v$fixed_view_definition@11gR2 B)
and view_name like ‘GV%’ order by 1;

 

GV$AQ_BACKGROUND_COORDINATOR
GV$AQ_BMAP_NONDUR_SUBSCRIBERS
GV$AQ_CROSS_INSTANCE_JOBS
GV$AQ_JOB_COORDINATOR
GV$AQ_MESSAGE_CACHE
GV$AQ_MSGBM
GV$AQ_NONDUR_REGISTRATIONS
GV$AQ_NONDUR_SUBSCRIBER
GV$AQ_NONDUR_SUBSCRIBER_LWM
GV$AQ_NOTIFICATION_CLIENTS
GV$AQ_SERVER_POOL
GV$AQ_SUBSCRIBER_LOAD
GV$ASM_ACFSREPL
GV$ASM_ACFSREPLTAG
GV$ASM_ACFSTAG
GV$ASM_ACFS_SEC_ADMIN
GV$ASM_ACFS_SEC_CMDRULE
GV$ASM_ACFS_SEC_REALM
GV$ASM_ACFS_SEC_REALM_FILTER
GV$ASM_ACFS_SEC_REALM_GROUP
GV$ASM_ACFS_SEC_REALM_USER
GV$ASM_ACFS_SEC_RULE
GV$ASM_ACFS_SEC_RULESET
GV$ASM_ACFS_SEC_RULESET_RULE
GV$ASM_AUDIT_CLEANUP_JOBS
GV$ASM_AUDIT_CLEAN_EVENTS
GV$ASM_AUDIT_CONFIG_PARAMS
GV$ASM_AUDIT_LAST_ARCH_TS
GV$ASM_ESTIMATE
GV$BACKUP_NONLOGGED
GV$BTS_STAT
GV$BT_SCAN_CACHE
GV$BT_SCAN_OBJ_TEMPS
GV$CACHE
GV$CACHE_LOCK
GV$CACHE_TRANSFER
GV$CELL_OFL_THREAD_HISTORY
GV$CHANNEL_WAITS
GV$CLIENT_SECRETS
GV$CLONEDFILE
GV$CONTAINERS
GV$CON_SYSSTAT
GV$CON_SYSTEM_EVENT
GV$CON_SYSTEM_WAIT_CLASS
GV$CON_SYS_TIME_MODEL
GV$COPY_NONLOGGED
GV$DEAD_CLEANUP
GV$DG_BROKER_CONFIG
GV$EDITIONABLE_TYPES
GV$ENCRYPTION_KEYS
GV$FALSE_PING
GV$FLASHFILESTAT
GV$GES_DEADLOCKS
GV$GES_DEADLOCK_SESSIONS
GV$GG_APPLY_COORDINATOR
GV$GG_APPLY_READER
GV$GG_APPLY_RECEIVER
GV$GG_APPLY_SERVER
GV$GOLDENGATE_CAPABILITIES
GV$GOLDENGATE_CAPTURE
GV$GOLDENGATE_MESSAGE_TRACKING
GV$GOLDENGATE_TABLE_STATS
GV$GOLDENGATE_TRANSACTION
GV$HEAT_MAP_SEGMENT
GV$INSTANCE_PING
GV$IOS_CLIENT
GV$IO_OUTLIER
GV$KERNEL_IO_OUTLIER
GV$KSFQP
GV$LGWRIO_OUTLIER
GV$MAPPED_SQL
GV$NONLOGGED_BLOCK
GV$OFSMOUNT
GV$OFS_STATS
GV$OPTIMIZER_PROCESSING_RATE
GV$PATCHES
GV$PDBS
GV$PDB_INCARNATION
GV$PING
GV$PX_PROCESS_TRACE
GV$REPLAY_CONTEXT
GV$REPLAY_CONTEXT_LOB
GV$REPLAY_CONTEXT_SEQUENCE
GV$REPLAY_CONTEXT_SYSDATE
GV$REPLAY_CONTEXT_SYSGUID
GV$REPLAY_CONTEXT_SYSTIMESTAMP
GV$RO_USER_ACCOUNT
GV$RT_ADDM_CONTROL
GV$SCHEDULER_INMEM_MDINFO
GV$SCHEDULER_INMEM_RTINFO
GV$SESSIONS_COUNT
GV$SQL_DIAG_REPOSITORY
GV$SQL_DIAG_REPOSITORY_REASON
GV$SQL_MONITOR_SESSTAT
GV$SQL_MONITOR_STATNAME
GV$SQL_REOPTIMIZATION_HINTS
GV$SYS_REPORT_REQUESTS
GV$SYS_REPORT_STATS
GV$TEMPUNDOSTAT
GV$TSDP_SUPPORTED_FEATURE
GV$UNIFIED_AUDIT_TRAIL
GV$XSTREAM_APPLY_COORDINATOR
GV$XSTREAM_APPLY_READER
GV$XSTREAM_APPLY_RECEIVER
GV$XSTREAM_APPLY_SERVER
GV$XSTREAM_CAPTURE
GV$XSTREAM_MESSAGE_TRACKING
GV$XSTREAM_TRANSACTION
GV$XS_SESSIONS
GV$XS_SESSION_NS_ATTRIBUTE
GV$XS_SESSION_ROLE

 

 

Comment

*

沪ICP备14014813号-2

沪公网安备 31010802001379号