11g与12c视图对比

12.1.0.2.0与11.2.0.3.0

在12c(12.1.0.2 ) 上创建db_link

点击(此处)折叠或打开

create database link test123 connect to scott identified by tiger using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.6.11)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)))'

12c的视图数~

点击(此处)折叠或打开

SQL> select count(*) from dict;

  COUNT(*)
----------
      3228

11.2.0.3的是

点击(此处)折叠或打开

 SQL> select count(*) from dict11@test123;

  COUNT(*)
----------
      2629

点击(此处)折叠或打开

SQL> create table mini as (select * from dict
minus
select * from dict11@test123 ) ;

Table created.

点击(此处)折叠或打开

SQL> r
  1* select * from mini where table_name like 'DBA%'

TABLE_NAME                 COMMENTS
---------------------------------------- ----------------------------------------------------------------------------------------------------
DBA_ACL_NAME_MAP             New names of the access control lists for PL/SQL network utility packages from old XDB names
DBA_ALERT_HISTORY             History of Alerts
DBA_ALERT_HISTORY_DETAIL         Detailed alert history
DBA_AUTOTASK_STATUS             Autotask Status Information
DBA_CDB_RSRC_PLANS             All the consolidation resource plans
DBA_CDB_RSRC_PLAN_DIRECTIVES         all the CDB resource plan directives DBA_CLUSTERING_DIMENSIONS         All dimension details about clustering tables in the database
DBA_CLUSTERING_JOINS             All join details about clustering tables in the database
DBA_CLUSTERING_KEYS             Description of the keys of the clustering clause of tables accessible to dba
DBA_CLUSTERING_TABLES             Description of the clustering clause of tables accessible to dba DBA_CODE_ROLE_PRIVS             Roles attached to the program units
DBA_CONTAINER_DATA             Describes default and object-specific CONTAINER_DATA attributes
DBA_CREDENTIALS              All credentials in the database
DBA_CUBE_ATTR_MAPPINGS             OLAP Cube Attribute Mappings in the database
DBA_CUBE_ATTR_UNIQUE_KEYS         OLAP Unique Key Attributes in the database
DBA_CUBE_CLASSIFICATIONS         OLAP Object Classifications in the database
DBA_CUBE_DEPENDENCIES             OLAP metadata dependencies in the database
DBA_CUBE_DESCRIPTIONS             OLAP Descriptions in the database
DBA_CUBE_DIMNL_MAPPINGS          OLAP Cube Dimenisonality Mappings in the database
DBA_CUBE_DIM_MAPPINGS             OLAP Cube Dimension Mappings in the database
DBA_CUBE_DIM_VIEW_COLUMNS         OLAP Dimension View Columns in the database
DBA_CUBE_MAPPINGS             OLAP Cube Mappings in the database
DBA_CUBE_MEAS_MAPPINGS             OLAP Cube Measure Mappings in the database
DBA_CUBE_NAMED_BUILD_SPECS         OLAP Cube Named Build Specifications in the database
DBA_CUBE_SUB_PARTITION_LEVELS         OLAP Secondary Partition Levels in the database
DBA_DIGEST_VERIFIERS             Information about which users have Digest verifiers and the verifier types
DBA_DISCOVERY_SOURCE             All source of sensitive data discovery
DBA_DV_STATUS
DBA_ERROR_TRANSLATIONS             Describes all error translations in the database
DBA_GOLDENGATE_INBOUND             Details about the XStream inbound server
DBA_GOLDENGATE_RULES             Details about the GoldenGate server rules
DBA_GOLDENGATE_SUPPORT_MODE         List of support mode for objects by GoldenGate
DBA_HEATMAP_TOP_OBJECTS          Heatmap for Top N objects
DBA_HEATMAP_TOP_TABLESPACES         Heatmap for Top N tablespaces
DBA_HEAT_MAP_SEGMENT             Last segment access time
DBA_HEAT_MAP_SEG_HISTOGRAM         Segment access information for all segments
DBA_HIST_APPLY_SUMMARY             Streams/Goldengate/XStream Apply Historical Statistics Information
DBA_HIST_ASM_BAD_DISK             Non-Online ASM Disks
DBA_HIST_ASM_DISKGROUP             ASM Diskgroups connected to this Database
DBA_HIST_ASM_DISKGROUP_STAT         Statistics for ASM Diskgroup connected to this Database
DBA_HIST_CAPTURE             Streams/GoldenGate/XStream Capture Historical Statistics Information
DBA_HIST_CELL_CONFIG             Exadata configuration information
DBA_HIST_CELL_CONFIG_DETAIL         Exadata configuration information per snapshot
DBA_HIST_CELL_DB             Cell Database IO Statistics Information
DBA_HIST_CELL_DISKTYPE             Exadata Cell disk types
DBA_HIST_CELL_DISK_NAME          Exadata Cell disk names
DBA_HIST_CELL_DISK_SUMMARY         Cell Disk Summary Statistics
DBA_HIST_CELL_GLOBAL             Cell Global Statistics Information
DBA_HIST_CELL_GLOBAL_SUMMARY         Cell Global Summary Statistics
DBA_HIST_CELL_IOREASON             Cell IO Reason Statistics Information
DBA_HIST_CELL_IOREASON_NAME         Cell IO Reason Names
DBA_HIST_CELL_METRIC_DESC         Cell Metric Names
DBA_HIST_CELL_NAME             Exadata Cell names
DBA_HIST_CELL_OPEN_ALERTS         Cell Open Alerts Information
DBA_HIST_IM_SEG_STAT             Historical IM Segment Statistics Information
DBA_HIST_IM_SEG_STAT_OBJ         IM Segment Names
DBA_HIST_PDB_INSTANCE             Pluggable Database Instance Information
DBA_HIST_PDB_IN_SNAP             Pluggable Databases in a snapshot
DBA_HIST_REPLICATION_TBL_STATS         Replication Table Stats For GoldenGate/XStream Sessions
DBA_HIST_REPLICATION_TXN_STATS         Replication Transaction Stats For GoldenGate/XStream Sessions
DBA_HIST_REPORTS
DBA_HIST_REPORTS_CONTROL
DBA_HIST_REPORTS_DETAILS
DBA_HIST_REPORTS_TIMEBANDS
DBA_HIST_SESS_SGA_STATS          SGA Usage Stats For High Utilization GoldenGate/XStream Sessions
DBA_HIST_SESS_TIME_STATS         CPU And I/O Time For High Utilization Streams/GoldenGate/XStream sessions
DBA_HOST_ACES                 Access control entries defined in host access control lists
DBA_HOST_ACLS                 Access control lists assigned to restrict access to network hosts through PL/SQL network utility package DBA_ILMDATAMOVEMENTPOLICIES         Data movement related policies in database
DBA_ILMEVALUATIONDETAILS         Details on policies considered for a particular execution
DBA_ILMOBJECTS                 Policies and the objects they affect in the database
DBA_ILMPARAMETERS             Describes ILM PARAMETERS in the database and their values
DBA_ILMPOLICIES              ILM policies in the database
DBA_ILMRESULTS                 Information on ILM jobs
DBA_ILMTASKS                 Information on ILM execution
DBA_JAVA_ARGUMENTS             argument information for all java classes
DBA_JAVA_CLASSES             class level information for all java classes
DBA_JAVA_DERIVATIONS    this view maps java source objects and their derived java class objects and java resource objects for all java classes DBA_JAVA_FIELDS              field information for java classes
DBA_JAVA_IMPLEMENTS             interfaces implemented by all java classes
DBA_JAVA_INNERS              list of inner classes referenced by some other class
DBA_JAVA_LAYOUTS             class layout information for all java classes
DBA_JAVA_METHODS             method information for all java classes
DBA_JAVA_THROWS              list of exceptions thrown from methods of all java classes
DBA_JSON_COLUMNS             Comments on all JSON columns
DBA_LOGSTDBY_PLSQL_MAP             PLSQL mapping from user invokable procedure to supp-log pragma-ed procedure
DBA_LOGSTDBY_PLSQL_SUPPORT         PLSQL packages registered with logical standby
DBA_MEASURE_FOLDER_SUBFOLDERS         OLAP Measure Folders contained within the database OLAP Measure Folders
DBA_METADATA_PROPERTIES          OLAP Metadata Properties in the database
DBA_OBJECT_USAGE             Record of index usage
DBA_OPTSTAT_OPERATION_TASKS         Tasks that are performed as part of statistics operations
DBA_PDBS                 Describes all pluggable databases in the consolidated database
DBA_PDB_HISTORY              Describes lineage of the pluggable database to which it belongs
DBA_PDB_SAVED_STATES             Shows all saved pluggable database states in the consolidated database DBA_PLSQL_COLL_TYPES             Description of all named collection types in the database
DBA_PLSQL_TYPES              Description of all types in the database
DBA_PLSQL_TYPE_ATTRS             Description of attributes of all plsql types in the database
DBA_POLICY_ATTRIBUTES             Attribute associations of all context sensitive and shared context sensitive policies in the databas
                     e

DBA_PRIV_CAPTURES
DBA_REDO_DB
DBA_REDO_LOG
DBA_REGISTRY_ERROR
DBA_REGISTRY_SQLPATCH
DBA_REPL_DBNAME_MAPPING          Details about the database name mapping
DBA_ROLLING_DATABASES             List of all databases eligible for configuration with rolling upgrade
DBA_ROLLING_EVENTS             List of all events reported from DBMS_ROLLING PL/SQL package
DBA_ROLLING_PARAMETERS             List of parameters to configure rolling upgrade
DBA_ROLLING_PLAN             List of instructions which constitutes the upgrade plan
DBA_ROLLING_STATISTICS             List of rolling upgrade statistics
DBA_ROLLING_STATUS             Overall status of the rolling upgrade
DBA_ROLLING_UNSUPPORTED          List of all the columns that are not supported by DBMS_ROLLING upgrades
DBA_SECUREFILE_LOGS
DBA_SECUREFILE_LOG_INSTANCES
DBA_SECUREFILE_LOG_PARTITIONS
DBA_SECUREFILE_LOG_TABLES
DBA_SENSITIVE_COLUMN_TYPES         All Sensitive Column Types in the database
DBA_SENSITIVE_DATA             All sensitive data in the database identified using TSDP
DBA_SQL_PLAN_DIRECTIVES          Set of sql plan directives
DBA_SQL_PLAN_DIR_OBJECTS         Set of objects in sql plan directive
DBA_SQL_TRANSLATIONS             Describes all SQL translations in the database
DBA_SQL_TRANSLATION_PROFILES         Describes all SQL translation profiles in the database
DBA_SR_GRP_STATUS
DBA_SR_GRP_STATUS_ALL             All synchronous refresh groups in the database
DBA_SR_OBJ
DBA_SR_OBJ_ALL                 All synchronous refresh objects in the database
DBA_SR_OBJ_STATUS
DBA_SR_OBJ_STATUS_ALL             All synchronous refresh objects in the database
DBA_SR_PARTN_OPS
DBA_SR_STLOG_STATS
DBA_SUPPLEMENTAL_LOGGING         Describes the current state of supplemental logging for this database
DBA_TAB_COLS_V$
DBA_TAB_IDENTITY_COLS             Describes all table identity columns
DBA_TSDP_IMPORT_ERRORS             Lists the errors encountered during import of Discovery Result
DBA_TSDP_POLICY_CONDITION         The conditions of TSDP policies
DBA_TSDP_POLICY_FEATURE          All TSDP policies in the database
DBA_TSDP_POLICY_PARAMETER         Parameters of the TSDP policies
DBA_TSDP_POLICY_PROTECTION         Lists the proptection enabled through TSDP
DBA_TSDP_POLICY_TYPE             All TSDP policy and Sensitive Type associations
DBA_UNUSED_OBJPRIVS
DBA_UNUSED_OBJPRIVS_PATH
DBA_UNUSED_PRIVS
DBA_UNUSED_SYSPRIVS
DBA_UNUSED_SYSPRIVS_PATH
DBA_UNUSED_USERPRIVS
DBA_UNUSED_USERPRIVS_PATH
DBA_USED_OBJPRIVS
DBA_USED_OBJPRIVS_PATH
DBA_USED_PRIVS
DBA_USED_PUBPRIVS
DBA_USED_SYSPRIVS
DBA_USED_SYSPRIVS_PATH
DBA_USED_USERPRIVS
DBA_USED_USERPRIVS_PATH
DBA_WALLET_ACES              Access control entries defined in wallet access control lists
DBA_WI_CAPTURE_FILES
DBA_WI_JOBS
DBA_WI_OBJECTS
DBA_WI_PATTERNS
DBA_WI_PATTERN_ITEMS
DBA_WI_STATEMENTS
DBA_WI_TEMPLATES
DBA_WI_TEMPLATE_EXECUTIONS
DBA_WORKLOAD_ACTIVE_USER_MAP
DBA_WORKLOAD_REPLAY_SCHEDULES
DBA_WORKLOAD_SCHEDULE_CAPTURES
DBA_WORKLOAD_SCHEDULE_ORDERING
DBA_WORKLOAD_USER_MAP
DBA_XDS_ACL_REFRESH
DBA_XDS_ACL_REFSTAT
DBA_XDS_LATEST_ACL_REFSTAT
DBA_XMLTYPE_COLS
DBA_XML_NESTED_TABLES
DBA_XML_OUT_OF_LINE_TABLES
DBA_XML_SCHEMA_ATTRIBUTES
DBA_XML_SCHEMA_COMPLEX_TYPES
DBA_XML_SCHEMA_ELEMENTS
DBA_XML_SCHEMA_NAMESPACES
DBA_XML_SCHEMA_SIMPLE_TYPES
DBA_XML_SCHEMA_SUBSTGRP_HEAD
DBA_XML_SCHEMA_SUBSTGRP_MBRS
DBA_XSTREAM_SPLIT_MERGE          view of details of split/merge jobs/status about XStream
DBA_XSTREAM_SPLIT_MERGE_HIST         history view of details of split/merge jobs/status about XStream
DBA_XSTREAM_TRANSFORMATIONS         Transformations defined on rules
DBA_XS_ACES                 All the Real Application Security ACES defined in database
DBA_XS_ACLS                 All the Real Application Security ACLs defined in the database
DBA_XS_ACL_PARAMETERS             All the Real Application Security ACL parameters defined in the database
DBA_XS_ACTIVE_SESSIONS             All the attached application sessions in the database
DBA_XS_APPLIED_POLICIES          All the database objects on which Real Application Security data security policies are enabled
DBA_XS_AUDIT_POLICY_OPTIONS         Describes auditing options defined under all XS security specific
                     audit policies

DBA_XS_AUDIT_TRAIL             Describes all XS related audit records
DBA_XS_COLUMN_CONSTRAINTS         All the Real Application Security column constraints defined in the database
DBA_XS_DYNAMIC_ROLES             All the Real Application Security dynamic roles defined in the database
DBA_XS_ENB_AUDIT_POLICIES         Describes all XS related audit policy

点击(此处)折叠或打开

SQL> select * from mini where table_name like 'V$%';

TABLE_NAME                 COMMENTS
---------------------------------------- ----------------------------------------------------------------------------------------------------
V$AQ_BACKGROUND_COORDINATOR         Synonym for V_$AQ_BACKGROUND_COORDINATOR
V$AQ_BMAP_NONDUR_SUBSCRIBERS         Synonym for V_$AQ_BMAP_NONDUR_SUBSCRIBERS
V$AQ_CROSS_INSTANCE_JOBS         Synonym for V_$AQ_CROSS_INSTANCE_JOBS
V$AQ_JOB_COORDINATOR             Synonym for V_$AQ_JOB_COORDINATOR
V$AQ_MESSAGE_CACHE             Synonym for V_$AQ_MESSAGE_CACHE
V$AQ_MSGBM                 Synonym for V_$AQ_MSGBM
V$AQ_NONDUR_REGISTRATIONS         Synonym for V_$AQ_NONDUR_REGISTRATIONS
V$AQ_NONDUR_SUBSCRIBER             Synonym for V_$AQ_NONDUR_SUBSCRIBER
V$AQ_NONDUR_SUBSCRIBER_LWM         Synonym for V_$AQ_NONDUR_SUBSCRIBER_LWM
V$AQ_NOTIFICATION_CLIENTS         Synonym for V_$AQ_NOTIFICATION_CLIENTS
V$AQ_SERVER_POOL             Synonym for V_$AQ_SERVER_POOL
V$AQ_SUBSCRIBER_LOAD             Synonym for V_$AQ_SUBSCRIBER_LOAD
V$ASM_ACFSREPL                 Synonym for V_$ASM_ACFSREPL
V$ASM_ACFSREPLTAG             Synonym for V_$ASM_ACFSREPLTAG
V$ASM_ACFSTAG                 Synonym for V_$ASM_ACFSTAG
V$ASM_ACFS_SEC_ADMIN             Synonym for V_$ASM_ACFS_SEC_ADMIN
V$ASM_ACFS_SEC_CMDRULE             Synonym for V_$ASM_ACFS_SEC_CMDRULE
V$ASM_ACFS_SEC_REALM             Synonym for V_$ASM_ACFS_SEC_REALM
V$ASM_ACFS_SEC_REALM_FILTER         Synonym for V_$ASM_ACFS_SEC_REALM_FILTER
V$ASM_ACFS_SEC_REALM_GROUP         Synonym for V_$ASM_ACFS_SEC_REALM_GROUP
V$ASM_ACFS_SEC_REALM_USER         Synonym for V_$ASM_ACFS_SEC_REALM_USER
V$ASM_ACFS_SEC_RULE             Synonym for V_$ASM_ACFS_SEC_RULE
V$ASM_ACFS_SEC_RULESET             Synonym for V_$ASM_ACFS_SEC_RULESET
V$ASM_ACFS_SEC_RULESET_RULE         Synonym for V_$ASM_ACFS_SEC_RULESET_RULE
V$ASM_AUDIT_CLEANUP_JOBS         Synonym for V_$ASM_AUDIT_CLEANUP_JOBS
V$ASM_AUDIT_CLEAN_EVENTS         Synonym for V_$ASM_AUDIT_CLEAN_EVENTS
V$ASM_AUDIT_CONFIG_PARAMS         Synonym for V_$ASM_AUDIT_CONFIG_PARAMS
V$ASM_AUDIT_LAST_ARCH_TS         Synonym for V_$ASM_AUDIT_LAST_ARCH_TS
V$ASM_DISKGROUP_SPARSE             Synonym for V_$ASM_DISKGROUP_SPARSE
V$ASM_DISK_IOSTAT_SPARSE         Synonym for V_$ASM_DISK_IOSTAT_SPARSE
V$ASM_DISK_SPARSE             Synonym for V_$ASM_DISK_SPARSE
V$ASM_DISK_SPARSE_STAT             Synonym for V_$ASM_DISK_SPARSE_STAT
V$ASM_ESTIMATE                 Synonym for V_$ASM_ESTIMATE V$BACKUP_NONLOGGED             Synonym for V_$BACKUP_NONLOGGED
V$BTS_STAT                 Synonym for V_$BTS_STAT
V$BT_SCAN_CACHE              Synonym for V_$BT_SCAN_CACHE
V$BT_SCAN_OBJ_TEMPS             Synonym for V_$BT_SCAN_OBJ_TEMPS
V$CACHE                  Synonym for V_$CACHE
V$CACHE_LOCK                 Synonym for V_$CACHE_LOCK
V$CACHE_TRANSFER             Synonym for V_$CACHE_TRANSFER
V$CELL_CONFIG_INFO             Synonym for V_$CELL_CONFIG_INFO
V$CELL_DB                 Synonym for V_$CELL_DB
V$CELL_DB_HISTORY             Synonym for V_$CELL_DB_HISTORY
V$CELL_DISK                 Synonym for V_$CELL_DISK
V$CELL_DISK_HISTORY             Synonym for V_$CELL_DISK_HISTORY
V$CELL_GLOBAL                 Synonym for V_$CELL_GLOBAL
V$CELL_GLOBAL_HISTORY             Synonym for V_$CELL_GLOBAL_HISTORY
V$CELL_IOREASON              Synonym for V_$CELL_IOREASON
V$CELL_IOREASON_NAME             Synonym for V_$CELL_IOREASON_NAME
V$CELL_METRIC_DESC             Synonym for V_$CELL_METRIC_DESC
V$CELL_OFL_THREAD_HISTORY         Synonym for V_$CELL_OFL_THREAD_HISTORY
V$CELL_OPEN_ALERTS             Synonym for V_$CELL_OPEN_ALERTS
V$CHANNEL_WAITS              Synonym for V_$CHANNEL_WAITS
V$CLIENT_SECRETS             Synonym for V_$CLIENT_SECRETS
V$CLONEDFILE                 Synonym for V_$CLONEDFILE
V$CONTAINERS                 Synonym for V_$CONTAINERS
V$CON_SYSSTAT                 Synonym for V_$CON_SYSSTAT
V$CON_SYSTEM_EVENT             Synonym for V_$CON_SYSTEM_EVENT
V$CON_SYSTEM_WAIT_CLASS          Synonym for V_$CON_SYSTEM_WAIT_CLASS
V$CON_SYS_TIME_MODEL             Synonym for V_$CON_SYS_TIME_MODEL
V$COPY_NONLOGGED             Synonym for V_$COPY_NONLOGGED
V$DEAD_CLEANUP                 Synonym for V_$DEAD_CLEANUP
V$DG_BROKER_CONFIG             Synonym for V_$DG_BROKER_CONFIG
V$DIAG_DFW_PATCH_CAPTURE         Synonym for V_$DIAG_DFW_PATCH_CAPTURE
V$DIAG_DFW_PATCH_ITEM             Synonym for V_$DIAG_DFW_PATCH_ITEM
V$DIAG_LOG_EXT                 Synonym for V_$DIAG_LOG_EXT
V$DISK_RESTORE_RANGE             Synonym for V_$DISK_RESTORE_RANGE
V$EDITIONABLE_TYPES             Synonym for V_$EDITIONABLE_TYPES
V$EMX_USAGE_STATS             Synonym for V_$EMX_USAGE_STATS
V$ENCRYPTION_KEYS             Synonym for V_$ENCRYPTION_KEYS
V$EVENT_HISTOGRAM_MICRO          Synonym for V_$EVENT_HISTOGRAM_MICRO
V$FALSE_PING                 Synonym for V_$FALSE_PING
V$FLASHFILESTAT              Synonym for V_$FLASHFILESTAT
V$FS_OBSERVER_HISTOGRAM          Synonym for V_$FS_OBSERVER_HISTOGRAM
V$GES_CONVERT_LOCAL             Synonym for V_$DLM_CONVERT_LOCAL
V$GES_CONVERT_REMOTE             Synonym for V_$DLM_CONVERT_REMOTE
V$GES_DEADLOCKS              Synonym for V_$GES_DEADLOCKS
V$GES_DEADLOCK_SESSIONS          Synonym for V_$GES_DEADLOCK_SESSIONS
V$GES_LATCH                 Synonym for V_$DLM_LATCH
V$GES_RESOURCE                 Synonym for V_$DLM_RESS
V$GES_STATISTICS             Synonym for V_$DLM_MISC
V$GES_TRAFFIC_CONTROLLER         Synonym for V_$DLM_TRAFFIC_CONTROLLER
V$GG_APPLY_COORDINATOR             Synonym for V_$GG_APPLY_COORDINATOR
V$GG_APPLY_READER             Synonym for V_$GG_APPLY_READER
V$GG_APPLY_RECEIVER             Synonym for V_$GG_APPLY_RECEIVER
V$GG_APPLY_SERVER             Synonym for V_$GG_APPLY_SERVER
V$GOLDENGATE_CAPABILITIES         Synonym for V_$GOLDENGATE_CAPABILITIES
V$HEAT_MAP_SEGMENT             Synonym for V_$HEAT_MAP_SEGMENT
V$IM_COLUMN_LEVEL             Synonym for V_$IM_COLUMN_LEVEL
V$IM_COL_CU                 Synonym for V_$IM_COL_CU
V$IM_HEADER                 Synonym for V_$IM_HEADER
V$IM_SEGMENTS                 Synonym for V_$IM_SEGMENTS
V$IM_SEGMENTS_DETAIL             Synonym for V_$IM_SEGMENTS_DETAIL
V$IM_SEG_EXT_MAP             Synonym for V_$IM_SEG_EXT_MAP
V$IM_SMU_CHUNK                 Synonym for V_$IM_SMU_CHUNK
V$IM_SMU_HEAD                 Synonym for V_$IM_SMU_HEAD
V$IM_TBS_EXT_MAP             Synonym for V_$IM_TBS_EXT_MAP
V$IM_USER_SEGMENTS             Synonym for V_$IM_USER_SEGMENTS
V$INMEMORY_AREA              Synonym for V_$INMEMORY_AREA
V$INSTANCE_PING              Synonym for V_$INSTANCE_PING
V$IOS_CLIENT                 Synonym for V_$IOS_CLIENT
V$IO_OUTLIER                 Synonym for V_$IO_OUTLIER
V$KERNEL_IO_OUTLIER             Synonym for V_$KERNEL_IO_OUTLIER
V$KEY_VECTOR                 Synonym for V_$KEY_VECTOR
V$LGWRIO_OUTLIER             Synonym for V_$LGWRIO_OUTLIER
V$MAPPED_SQL                 Synonym for V_$MAPPED_SQL
V$NONLOGGED_BLOCK             Synonym for V_$NONLOGGED_BLOCK
V$OBJECT_USAGE                 Synonym for USER_OBJECT_USAGE
V$OFSMOUNT                 Synonym for V_$OFSMOUNT
V$OFS_STATS                 Synonym for V_$OFS_STATS
V$OPTIMIZER_PROCESSING_RATE         Synonym for V_$OPTIMIZER_PROCESSING_RATE
V$PATCHES                 Synonym for V_$PATCHES
V$PDBS                     Synonym for V_$PDBS
V$PDB_INCARNATION             Synonym for V_$PDB_INCARNATION
V$PING                     Synonym for V_$PING
V$PX_PROCESS_TRACE             Synonym for V_$PX_PROCESS_TRACE
V$REPLAY_CONTEXT             Synonym for V_$REPLAY_CONTEXT
V$REPLAY_CONTEXT_LOB             Synonym for V_$REPLAY_CONTEXT_LOB
V$REPLAY_CONTEXT_SEQUENCE         Synonym for V_$REPLAY_CONTEXT_SEQUENCE
V$REPLAY_CONTEXT_SYSDATE         Synonym for V_$REPLAY_CONTEXT_SYSDATE
V$REPLAY_CONTEXT_SYSGUID         Synonym for V_$REPLAY_CONTEXT_SYSGUID
V$REPLAY_CONTEXT_SYSTIMESTAMP         Synonym for V_$REPLAY_CONTEXT_SYSTIMESTAMP
V$RESTORE_RANGE              Synonym for V_$RESTORE_RANGE
V$RO_USER_ACCOUNT             Synonym for V_$RO_USER_ACCOUNT
V$RT_ADDM_CONTROL             Synonym for V_$RT_ADDM_CONTROL
V$SBT_RESTORE_RANGE             Synonym for V_$SBT_RESTORE_RANGE
V$SCHEDULER_INMEM_MDINFO         Synonym for V_$SCHEDULER_INMEM_MDINFO
V$SCHEDULER_INMEM_RTINFO         Synonym for V_$SCHEDULER_INMEM_RTINFO
V$SESSIONS_COUNT             Synonym for V_$SESSIONS_COUNT
V$SQL_DIAG_REPOSITORY             Synonym for V_$SQL_DIAG_REPOSITORY
V$SQL_DIAG_REPOSITORY_REASON         Synonym for V_$SQL_DIAG_REPOSITORY_REASON
V$SQL_MONITOR_SESSTAT             Synonym for V_$SQL_MONITOR_SESSTAT
V$SQL_MONITOR_STATNAME             Synonym for V_$SQL_MONITOR_STATNAME
V$SQL_REOPTIMIZATION_HINTS         Synonym for V_$SQL_REOPTIMIZATION_HINTS
V$SYS_REPORT_REQUESTS             Synonym for V_$SYS_REPORT_REQUESTS
V$SYS_REPORT_STATS             Synonym for V_$SYS_REPORT_STATS
V$TEMPUNDOSTAT                 Synonym for V_$TEMPUNDOSTAT
V$TSDP_SUPPORTED_FEATURE         Synonym for V_$TSDP_SUPPORTED_FEATURE
V$UNIFIED_AUDIT_RECORD_FORMAT         Synonym for V_$UNIFIED_AUDIT_RECORD_FORMAT
V$UNIFIED_AUDIT_TRAIL             Synonym for V_$UNIFIED_AUDIT_TRAIL
V$XSTREAM_APPLY_COORDINATOR         Synonym for V_$XSTREAM_APPLY_COORDINATOR
V$XSTREAM_APPLY_READER             Synonym for V_$XSTREAM_APPLY_READER
V$XSTREAM_APPLY_RECEIVER         Synonym for V_$XSTREAM_APPLY_RECEIVER
V$XSTREAM_APPLY_SERVER             Synonym for V_$XSTREAM_APPLY_SERVER
V$XS_SESSIONS                 Synonym for V_$XS_SESSIONS
V$XS_SESSION_NS_ATTRIBUTE         Synonym for V_$XS_SESSION_NS_ATTRIBUTES
V$XS_SESSION_NS_ATTRIBUTES         Synonym for V_$XS_SESSION_NS_ATTRIBUTES
V$XS_SESSION_ROLES             Synonym for V_$XS_SESSION_ROLES

ASM又有好多新视图啊

后续挨个视图 查查文档了~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29990276/viewspace-1738537/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29990276/viewspace-1738537/