【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
本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/p2