ITPub博客

首页 > 数据库 > Oracle > 11g与12c视图对比

11g与12c视图对比

原创 Oracle 作者:哎呀我的天呐 时间:2015-07-18 22:50:55 0 删除 编辑
12.1.0.2.0与11.2.0.3.0

在12c(12.1.0.2
)上创建db_link


点击(此处)折叠或打开

  1. 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的视图数~

点击(此处)折叠或打开

  1. SQL> select count(*) from dict;

  2.   COUNT(*)
  3. ----------
  4.       3228
11.2.0.3的是

点击(此处)折叠或打开

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

  2.   COUNT(*)
  3. ----------
  4.       2629

点击(此处)折叠或打开

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

  4. Table created.

点击(此处)折叠或打开

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

  3. TABLE_NAME                 COMMENTS
  4. ---------------------------------------- ----------------------------------------------------------------------------------------------------
  5. DBA_ACL_NAME_MAP             New names of the access control lists for PL/SQL network utility packages from old XDB names
  6. DBA_ALERT_HISTORY             History of Alerts
  7. DBA_ALERT_HISTORY_DETAIL         Detailed alert history
  8. DBA_AUTOTASK_STATUS             Autotask Status Information
  9. DBA_CDB_RSRC_PLANS             All the consolidation resource plans
  10. DBA_CDB_RSRC_PLAN_DIRECTIVES         all the CDB resource plan directives
  11. DBA_CLUSTERING_DIMENSIONS         All dimension details about clustering tables in the database
  12. DBA_CLUSTERING_JOINS             All join details about clustering tables in the database
  13. DBA_CLUSTERING_KEYS             Description of the keys of the clustering clause of tables accessible to dba
  14. DBA_CLUSTERING_TABLES             Description of the clustering clause of tables accessible to dba
  15. DBA_CODE_ROLE_PRIVS             Roles attached to the program units
  16. DBA_CONTAINER_DATA             Describes default and object-specific CONTAINER_DATA attributes
  17. DBA_CREDENTIALS              All credentials in the database
  18. DBA_CUBE_ATTR_MAPPINGS             OLAP Cube Attribute Mappings in the database
  19. DBA_CUBE_ATTR_UNIQUE_KEYS         OLAP Unique Key Attributes in the database
  20. DBA_CUBE_CLASSIFICATIONS         OLAP Object Classifications in the database
  21. DBA_CUBE_DEPENDENCIES             OLAP metadata dependencies in the database
  22. DBA_CUBE_DESCRIPTIONS             OLAP Descriptions in the database
  23. DBA_CUBE_DIMNL_MAPPINGS          OLAP Cube Dimenisonality Mappings in the database
  24. DBA_CUBE_DIM_MAPPINGS             OLAP Cube Dimension Mappings in the database
  25. DBA_CUBE_DIM_VIEW_COLUMNS         OLAP Dimension View Columns in the database
  26. DBA_CUBE_MAPPINGS             OLAP Cube Mappings in the database
  27. DBA_CUBE_MEAS_MAPPINGS             OLAP Cube Measure Mappings in the database
  28. DBA_CUBE_NAMED_BUILD_SPECS         OLAP Cube Named Build Specifications in the database
  29. DBA_CUBE_SUB_PARTITION_LEVELS         OLAP Secondary Partition Levels in the database
  30. DBA_DIGEST_VERIFIERS             Information about which users have Digest verifiers and the verifier types
  31. DBA_DISCOVERY_SOURCE             All source of sensitive data discovery
  32. DBA_DV_STATUS
  33. DBA_ERROR_TRANSLATIONS             Describes all error translations in the database
  34. DBA_GOLDENGATE_INBOUND             Details about the XStream inbound server
  35. DBA_GOLDENGATE_RULES             Details about the GoldenGate server rules
  36. DBA_GOLDENGATE_SUPPORT_MODE         List of support mode for objects by GoldenGate
  37. DBA_HEATMAP_TOP_OBJECTS          Heatmap for Top N objects
  38. DBA_HEATMAP_TOP_TABLESPACES         Heatmap for Top N tablespaces
  39. DBA_HEAT_MAP_SEGMENT             Last segment access time
  40. DBA_HEAT_MAP_SEG_HISTOGRAM         Segment access information for all segments
  41. DBA_HIST_APPLY_SUMMARY             Streams/Goldengate/XStream Apply Historical Statistics Information
  42. DBA_HIST_ASM_BAD_DISK             Non-Online ASM Disks
  43. DBA_HIST_ASM_DISKGROUP             ASM Diskgroups connected to this Database
  44. DBA_HIST_ASM_DISKGROUP_STAT         Statistics for ASM Diskgroup connected to this Database
  45. DBA_HIST_CAPTURE             Streams/GoldenGate/XStream Capture Historical Statistics Information
  46. DBA_HIST_CELL_CONFIG             Exadata configuration information
  47. DBA_HIST_CELL_CONFIG_DETAIL         Exadata configuration information per snapshot
  48. DBA_HIST_CELL_DB             Cell Database IO Statistics Information
  49. DBA_HIST_CELL_DISKTYPE             Exadata Cell disk types
  50. DBA_HIST_CELL_DISK_NAME          Exadata Cell disk names
  51. DBA_HIST_CELL_DISK_SUMMARY         Cell Disk Summary Statistics
  52. DBA_HIST_CELL_GLOBAL             Cell Global Statistics Information
  53. DBA_HIST_CELL_GLOBAL_SUMMARY         Cell Global Summary Statistics
  54. DBA_HIST_CELL_IOREASON             Cell IO Reason Statistics Information
  55. DBA_HIST_CELL_IOREASON_NAME         Cell IO Reason Names
  56. DBA_HIST_CELL_METRIC_DESC         Cell Metric Names
  57. DBA_HIST_CELL_NAME             Exadata Cell names
  58. DBA_HIST_CELL_OPEN_ALERTS         Cell Open Alerts Information
  59. DBA_HIST_IM_SEG_STAT             Historical IM Segment Statistics Information
  60. DBA_HIST_IM_SEG_STAT_OBJ         IM Segment Names
  61. DBA_HIST_PDB_INSTANCE             Pluggable Database Instance Information
  62. DBA_HIST_PDB_IN_SNAP             Pluggable Databases in a snapshot
  63. DBA_HIST_REPLICATION_TBL_STATS         Replication Table Stats For GoldenGate/XStream Sessions
  64. DBA_HIST_REPLICATION_TXN_STATS         Replication Transaction Stats For GoldenGate/XStream Sessions
  65. DBA_HIST_REPORTS
  66. DBA_HIST_REPORTS_CONTROL
  67. DBA_HIST_REPORTS_DETAILS
  68. DBA_HIST_REPORTS_TIMEBANDS
  69. DBA_HIST_SESS_SGA_STATS          SGA Usage Stats For High Utilization GoldenGate/XStream Sessions
  70. DBA_HIST_SESS_TIME_STATS         CPU And I/O Time For High Utilization Streams/GoldenGate/XStream sessions
  71. DBA_HOST_ACES                 Access control entries defined in host access control lists
  72. DBA_HOST_ACLS                 Access control lists assigned to restrict access to network hosts through PL/SQL network utility package
  73. DBA_ILMDATAMOVEMENTPOLICIES         Data movement related policies in database
  74. DBA_ILMEVALUATIONDETAILS         Details on policies considered for a particular execution
  75. DBA_ILMOBJECTS                 Policies and the objects they affect in the database
  76. DBA_ILMPARAMETERS             Describes ILM PARAMETERS in the database and their values
  77. DBA_ILMPOLICIES              ILM policies in the database
  78. DBA_ILMRESULTS                 Information on ILM jobs
  79. DBA_ILMTASKS                 Information on ILM execution
  80. DBA_JAVA_ARGUMENTS             argument information for all java classes
  81. DBA_JAVA_CLASSES             class level information for all java classes
  82. DBA_JAVA_DERIVATIONS    this view maps java source objects and their derived java class objects and java resource objects for all java classes
  83. DBA_JAVA_FIELDS              field information for java classes
  84. DBA_JAVA_IMPLEMENTS             interfaces implemented by all java classes
  85. DBA_JAVA_INNERS              list of inner classes referenced by some other class
  86. DBA_JAVA_LAYOUTS             class layout information for all java classes
  87. DBA_JAVA_METHODS             method information for all java classes
  88. DBA_JAVA_THROWS              list of exceptions thrown from methods of all java classes
  89. DBA_JSON_COLUMNS             Comments on all JSON columns
  90. DBA_LOGSTDBY_PLSQL_MAP             PLSQL mapping from user invokable procedure to supp-log pragma-ed procedure
  91. DBA_LOGSTDBY_PLSQL_SUPPORT         PLSQL packages registered with logical standby
  92. DBA_MEASURE_FOLDER_SUBFOLDERS         OLAP Measure Folders contained within the database OLAP Measure Folders
  93. DBA_METADATA_PROPERTIES          OLAP Metadata Properties in the database
  94. DBA_OBJECT_USAGE             Record of index usage
  95. DBA_OPTSTAT_OPERATION_TASKS         Tasks that are performed as part of statistics operations
  96. DBA_PDBS                 Describes all pluggable databases in the consolidated database
  97. DBA_PDB_HISTORY              Describes lineage of the pluggable database to which it belongs
  98. DBA_PDB_SAVED_STATES             Shows all saved pluggable database states in the consolidated database
  99. DBA_PLSQL_COLL_TYPES             Description of all named collection types in the database
  100. DBA_PLSQL_TYPES              Description of all types in the database
  101. DBA_PLSQL_TYPE_ATTRS             Description of attributes of all plsql types in the database
  102. DBA_POLICY_ATTRIBUTES             Attribute associations of all context sensitive and shared context sensitive policies in the databas
  103.                      e

  104. DBA_PRIV_CAPTURES
  105. DBA_REDO_DB
  106. DBA_REDO_LOG
  107. DBA_REGISTRY_ERROR
  108. DBA_REGISTRY_SQLPATCH
  109. DBA_REPL_DBNAME_MAPPING          Details about the database name mapping
  110. DBA_ROLLING_DATABASES             List of all databases eligible for configuration with rolling upgrade
  111. DBA_ROLLING_EVENTS             List of all events reported from DBMS_ROLLING PL/SQL package
  112. DBA_ROLLING_PARAMETERS             List of parameters to configure rolling upgrade
  113. DBA_ROLLING_PLAN             List of instructions which constitutes the upgrade plan
  114. DBA_ROLLING_STATISTICS             List of rolling upgrade statistics
  115. DBA_ROLLING_STATUS             Overall status of the rolling upgrade
  116. DBA_ROLLING_UNSUPPORTED          List of all the columns that are not supported by DBMS_ROLLING upgrades
  117. DBA_SECUREFILE_LOGS
  118. DBA_SECUREFILE_LOG_INSTANCES
  119. DBA_SECUREFILE_LOG_PARTITIONS
  120. DBA_SECUREFILE_LOG_TABLES
  121. DBA_SENSITIVE_COLUMN_TYPES         All Sensitive Column Types in the database
  122. DBA_SENSITIVE_DATA             All sensitive data in the database identified using TSDP
  123. DBA_SQL_PLAN_DIRECTIVES          Set of sql plan directives
  124. DBA_SQL_PLAN_DIR_OBJECTS         Set of objects in sql plan directive
  125. DBA_SQL_TRANSLATIONS             Describes all SQL translations in the database
  126. DBA_SQL_TRANSLATION_PROFILES         Describes all SQL translation profiles in the database
  127. DBA_SR_GRP_STATUS
  128. DBA_SR_GRP_STATUS_ALL             All synchronous refresh groups in the database
  129. DBA_SR_OBJ
  130. DBA_SR_OBJ_ALL                 All synchronous refresh objects in the database
  131. DBA_SR_OBJ_STATUS
  132. DBA_SR_OBJ_STATUS_ALL             All synchronous refresh objects in the database
  133. DBA_SR_PARTN_OPS
  134. DBA_SR_STLOG_STATS
  135. DBA_SUPPLEMENTAL_LOGGING         Describes the current state of supplemental logging for this database
  136. DBA_TAB_COLS_V$
  137. DBA_TAB_IDENTITY_COLS             Describes all table identity columns
  138. DBA_TSDP_IMPORT_ERRORS             Lists the errors encountered during import of Discovery Result
  139. DBA_TSDP_POLICY_CONDITION         The conditions of TSDP policies
  140. DBA_TSDP_POLICY_FEATURE          All TSDP policies in the database
  141. DBA_TSDP_POLICY_PARAMETER         Parameters of the TSDP policies
  142. DBA_TSDP_POLICY_PROTECTION         Lists the proptection enabled through TSDP
  143. DBA_TSDP_POLICY_TYPE             All TSDP policy and Sensitive Type associations
  144. DBA_UNUSED_OBJPRIVS
  145. DBA_UNUSED_OBJPRIVS_PATH
  146. DBA_UNUSED_PRIVS
  147. DBA_UNUSED_SYSPRIVS
  148. DBA_UNUSED_SYSPRIVS_PATH
  149. DBA_UNUSED_USERPRIVS
  150. DBA_UNUSED_USERPRIVS_PATH
  151. DBA_USED_OBJPRIVS
  152. DBA_USED_OBJPRIVS_PATH
  153. DBA_USED_PRIVS
  154. DBA_USED_PUBPRIVS
  155. DBA_USED_SYSPRIVS
  156. DBA_USED_SYSPRIVS_PATH
  157. DBA_USED_USERPRIVS
  158. DBA_USED_USERPRIVS_PATH
  159. DBA_WALLET_ACES              Access control entries defined in wallet access control lists
  160. DBA_WI_CAPTURE_FILES
  161. DBA_WI_JOBS
  162. DBA_WI_OBJECTS
  163. DBA_WI_PATTERNS
  164. DBA_WI_PATTERN_ITEMS
  165. DBA_WI_STATEMENTS
  166. DBA_WI_TEMPLATES
  167. DBA_WI_TEMPLATE_EXECUTIONS
  168. DBA_WORKLOAD_ACTIVE_USER_MAP
  169. DBA_WORKLOAD_REPLAY_SCHEDULES
  170. DBA_WORKLOAD_SCHEDULE_CAPTURES
  171. DBA_WORKLOAD_SCHEDULE_ORDERING
  172. DBA_WORKLOAD_USER_MAP
  173. DBA_XDS_ACL_REFRESH
  174. DBA_XDS_ACL_REFSTAT
  175. DBA_XDS_LATEST_ACL_REFSTAT
  176. DBA_XMLTYPE_COLS
  177. DBA_XML_NESTED_TABLES
  178. DBA_XML_OUT_OF_LINE_TABLES
  179. DBA_XML_SCHEMA_ATTRIBUTES
  180. DBA_XML_SCHEMA_COMPLEX_TYPES
  181. DBA_XML_SCHEMA_ELEMENTS
  182. DBA_XML_SCHEMA_NAMESPACES
  183. DBA_XML_SCHEMA_SIMPLE_TYPES
  184. DBA_XML_SCHEMA_SUBSTGRP_HEAD
  185. DBA_XML_SCHEMA_SUBSTGRP_MBRS
  186. DBA_XSTREAM_SPLIT_MERGE          view of details of split/merge jobs/status about XStream
  187. DBA_XSTREAM_SPLIT_MERGE_HIST         history view of details of split/merge jobs/status about XStream
  188. DBA_XSTREAM_TRANSFORMATIONS         Transformations defined on rules
  189. DBA_XS_ACES                 All the Real Application Security ACES defined in database
  190. DBA_XS_ACLS                 All the Real Application Security ACLs defined in the database
  191. DBA_XS_ACL_PARAMETERS             All the Real Application Security ACL parameters defined in the database
  192. DBA_XS_ACTIVE_SESSIONS             All the attached application sessions in the database
  193. DBA_XS_APPLIED_POLICIES          All the database objects on which Real Application Security data security policies are enabled
  194. DBA_XS_AUDIT_POLICY_OPTIONS         Describes auditing options defined under all XS security specific
  195.                      audit policies

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

点击(此处)折叠或打开

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

  2. TABLE_NAME                 COMMENTS
  3. ---------------------------------------- ----------------------------------------------------------------------------------------------------
  4. V$AQ_BACKGROUND_COORDINATOR         Synonym for V_$AQ_BACKGROUND_COORDINATOR
  5. V$AQ_BMAP_NONDUR_SUBSCRIBERS         Synonym for V_$AQ_BMAP_NONDUR_SUBSCRIBERS
  6. V$AQ_CROSS_INSTANCE_JOBS         Synonym for V_$AQ_CROSS_INSTANCE_JOBS
  7. V$AQ_JOB_COORDINATOR             Synonym for V_$AQ_JOB_COORDINATOR
  8. V$AQ_MESSAGE_CACHE             Synonym for V_$AQ_MESSAGE_CACHE
  9. V$AQ_MSGBM                 Synonym for V_$AQ_MSGBM
  10. V$AQ_NONDUR_REGISTRATIONS         Synonym for V_$AQ_NONDUR_REGISTRATIONS
  11. V$AQ_NONDUR_SUBSCRIBER             Synonym for V_$AQ_NONDUR_SUBSCRIBER
  12. V$AQ_NONDUR_SUBSCRIBER_LWM         Synonym for V_$AQ_NONDUR_SUBSCRIBER_LWM
  13. V$AQ_NOTIFICATION_CLIENTS         Synonym for V_$AQ_NOTIFICATION_CLIENTS
  14. V$AQ_SERVER_POOL             Synonym for V_$AQ_SERVER_POOL
  15. V$AQ_SUBSCRIBER_LOAD             Synonym for V_$AQ_SUBSCRIBER_LOAD
  16. V$ASM_ACFSREPL                 Synonym for V_$ASM_ACFSREPL
  17. V$ASM_ACFSREPLTAG             Synonym for V_$ASM_ACFSREPLTAG
  18. V$ASM_ACFSTAG                 Synonym for V_$ASM_ACFSTAG
  19. V$ASM_ACFS_SEC_ADMIN             Synonym for V_$ASM_ACFS_SEC_ADMIN
  20. V$ASM_ACFS_SEC_CMDRULE             Synonym for V_$ASM_ACFS_SEC_CMDRULE
  21. V$ASM_ACFS_SEC_REALM             Synonym for V_$ASM_ACFS_SEC_REALM
  22. V$ASM_ACFS_SEC_REALM_FILTER         Synonym for V_$ASM_ACFS_SEC_REALM_FILTER
  23. V$ASM_ACFS_SEC_REALM_GROUP         Synonym for V_$ASM_ACFS_SEC_REALM_GROUP
  24. V$ASM_ACFS_SEC_REALM_USER         Synonym for V_$ASM_ACFS_SEC_REALM_USER
  25. V$ASM_ACFS_SEC_RULE             Synonym for V_$ASM_ACFS_SEC_RULE
  26. V$ASM_ACFS_SEC_RULESET             Synonym for V_$ASM_ACFS_SEC_RULESET
  27. V$ASM_ACFS_SEC_RULESET_RULE         Synonym for V_$ASM_ACFS_SEC_RULESET_RULE
  28. V$ASM_AUDIT_CLEANUP_JOBS         Synonym for V_$ASM_AUDIT_CLEANUP_JOBS
  29. V$ASM_AUDIT_CLEAN_EVENTS         Synonym for V_$ASM_AUDIT_CLEAN_EVENTS
  30. V$ASM_AUDIT_CONFIG_PARAMS         Synonym for V_$ASM_AUDIT_CONFIG_PARAMS
  31. V$ASM_AUDIT_LAST_ARCH_TS         Synonym for V_$ASM_AUDIT_LAST_ARCH_TS
  32. V$ASM_DISKGROUP_SPARSE             Synonym for V_$ASM_DISKGROUP_SPARSE
  33. V$ASM_DISK_IOSTAT_SPARSE         Synonym for V_$ASM_DISK_IOSTAT_SPARSE
  34. V$ASM_DISK_SPARSE             Synonym for V_$ASM_DISK_SPARSE
  35. V$ASM_DISK_SPARSE_STAT             Synonym for V_$ASM_DISK_SPARSE_STAT
  36. V$ASM_ESTIMATE                 Synonym for V_$ASM_ESTIMATE
  37. V$BACKUP_NONLOGGED             Synonym for V_$BACKUP_NONLOGGED
  38. V$BTS_STAT                 Synonym for V_$BTS_STAT
  39. V$BT_SCAN_CACHE              Synonym for V_$BT_SCAN_CACHE
  40. V$BT_SCAN_OBJ_TEMPS             Synonym for V_$BT_SCAN_OBJ_TEMPS
  41. V$CACHE                  Synonym for V_$CACHE
  42. V$CACHE_LOCK                 Synonym for V_$CACHE_LOCK
  43. V$CACHE_TRANSFER             Synonym for V_$CACHE_TRANSFER
  44. V$CELL_CONFIG_INFO             Synonym for V_$CELL_CONFIG_INFO
  45. V$CELL_DB                 Synonym for V_$CELL_DB
  46. V$CELL_DB_HISTORY             Synonym for V_$CELL_DB_HISTORY
  47. V$CELL_DISK                 Synonym for V_$CELL_DISK
  48. V$CELL_DISK_HISTORY             Synonym for V_$CELL_DISK_HISTORY
  49. V$CELL_GLOBAL                 Synonym for V_$CELL_GLOBAL
  50. V$CELL_GLOBAL_HISTORY             Synonym for V_$CELL_GLOBAL_HISTORY
  51. V$CELL_IOREASON              Synonym for V_$CELL_IOREASON
  52. V$CELL_IOREASON_NAME             Synonym for V_$CELL_IOREASON_NAME
  53. V$CELL_METRIC_DESC             Synonym for V_$CELL_METRIC_DESC
  54. V$CELL_OFL_THREAD_HISTORY         Synonym for V_$CELL_OFL_THREAD_HISTORY
  55. V$CELL_OPEN_ALERTS             Synonym for V_$CELL_OPEN_ALERTS
  56. V$CHANNEL_WAITS              Synonym for V_$CHANNEL_WAITS
  57. V$CLIENT_SECRETS             Synonym for V_$CLIENT_SECRETS
  58. V$CLONEDFILE                 Synonym for V_$CLONEDFILE
  59. V$CONTAINERS                 Synonym for V_$CONTAINERS
  60. V$CON_SYSSTAT                 Synonym for V_$CON_SYSSTAT
  61. V$CON_SYSTEM_EVENT             Synonym for V_$CON_SYSTEM_EVENT
  62. V$CON_SYSTEM_WAIT_CLASS          Synonym for V_$CON_SYSTEM_WAIT_CLASS
  63. V$CON_SYS_TIME_MODEL             Synonym for V_$CON_SYS_TIME_MODEL
  64. V$COPY_NONLOGGED             Synonym for V_$COPY_NONLOGGED
  65. V$DEAD_CLEANUP                 Synonym for V_$DEAD_CLEANUP
  66. V$DG_BROKER_CONFIG             Synonym for V_$DG_BROKER_CONFIG
  67. V$DIAG_DFW_PATCH_CAPTURE         Synonym for V_$DIAG_DFW_PATCH_CAPTURE
  68. V$DIAG_DFW_PATCH_ITEM             Synonym for V_$DIAG_DFW_PATCH_ITEM
  69. V$DIAG_LOG_EXT                 Synonym for V_$DIAG_LOG_EXT
  70. V$DISK_RESTORE_RANGE             Synonym for V_$DISK_RESTORE_RANGE
  71. V$EDITIONABLE_TYPES             Synonym for V_$EDITIONABLE_TYPES
  72. V$EMX_USAGE_STATS             Synonym for V_$EMX_USAGE_STATS
  73. V$ENCRYPTION_KEYS             Synonym for V_$ENCRYPTION_KEYS
  74. V$EVENT_HISTOGRAM_MICRO          Synonym for V_$EVENT_HISTOGRAM_MICRO
  75. V$FALSE_PING                 Synonym for V_$FALSE_PING
  76. V$FLASHFILESTAT              Synonym for V_$FLASHFILESTAT
  77. V$FS_OBSERVER_HISTOGRAM          Synonym for V_$FS_OBSERVER_HISTOGRAM
  78. V$GES_CONVERT_LOCAL             Synonym for V_$DLM_CONVERT_LOCAL
  79. V$GES_CONVERT_REMOTE             Synonym for V_$DLM_CONVERT_REMOTE
  80. V$GES_DEADLOCKS              Synonym for V_$GES_DEADLOCKS
  81. V$GES_DEADLOCK_SESSIONS          Synonym for V_$GES_DEADLOCK_SESSIONS
  82. V$GES_LATCH                 Synonym for V_$DLM_LATCH
  83. V$GES_RESOURCE                 Synonym for V_$DLM_RESS
  84. V$GES_STATISTICS             Synonym for V_$DLM_MISC
  85. V$GES_TRAFFIC_CONTROLLER         Synonym for V_$DLM_TRAFFIC_CONTROLLER
  86. V$GG_APPLY_COORDINATOR             Synonym for V_$GG_APPLY_COORDINATOR
  87. V$GG_APPLY_READER             Synonym for V_$GG_APPLY_READER
  88. V$GG_APPLY_RECEIVER             Synonym for V_$GG_APPLY_RECEIVER
  89. V$GG_APPLY_SERVER             Synonym for V_$GG_APPLY_SERVER
  90. V$GOLDENGATE_CAPABILITIES         Synonym for V_$GOLDENGATE_CAPABILITIES
  91. V$HEAT_MAP_SEGMENT             Synonym for V_$HEAT_MAP_SEGMENT
  92. V$IM_COLUMN_LEVEL             Synonym for V_$IM_COLUMN_LEVEL
  93. V$IM_COL_CU                 Synonym for V_$IM_COL_CU
  94. V$IM_HEADER                 Synonym for V_$IM_HEADER
  95. V$IM_SEGMENTS                 Synonym for V_$IM_SEGMENTS
  96. V$IM_SEGMENTS_DETAIL             Synonym for V_$IM_SEGMENTS_DETAIL
  97. V$IM_SEG_EXT_MAP             Synonym for V_$IM_SEG_EXT_MAP
  98. V$IM_SMU_CHUNK                 Synonym for V_$IM_SMU_CHUNK
  99. V$IM_SMU_HEAD                 Synonym for V_$IM_SMU_HEAD
  100. V$IM_TBS_EXT_MAP             Synonym for V_$IM_TBS_EXT_MAP
  101. V$IM_USER_SEGMENTS             Synonym for V_$IM_USER_SEGMENTS
  102. V$INMEMORY_AREA              Synonym for V_$INMEMORY_AREA
  103. V$INSTANCE_PING              Synonym for V_$INSTANCE_PING
  104. V$IOS_CLIENT                 Synonym for V_$IOS_CLIENT
  105. V$IO_OUTLIER                 Synonym for V_$IO_OUTLIER
  106. V$KERNEL_IO_OUTLIER             Synonym for V_$KERNEL_IO_OUTLIER
  107. V$KEY_VECTOR                 Synonym for V_$KEY_VECTOR
  108. V$LGWRIO_OUTLIER             Synonym for V_$LGWRIO_OUTLIER
  109. V$MAPPED_SQL                 Synonym for V_$MAPPED_SQL
  110. V$NONLOGGED_BLOCK             Synonym for V_$NONLOGGED_BLOCK
  111. V$OBJECT_USAGE                 Synonym for USER_OBJECT_USAGE
  112. V$OFSMOUNT                 Synonym for V_$OFSMOUNT
  113. V$OFS_STATS                 Synonym for V_$OFS_STATS
  114. V$OPTIMIZER_PROCESSING_RATE         Synonym for V_$OPTIMIZER_PROCESSING_RATE
  115. V$PATCHES                 Synonym for V_$PATCHES
  116. V$PDBS                     Synonym for V_$PDBS
  117. V$PDB_INCARNATION             Synonym for V_$PDB_INCARNATION
  118. V$PING                     Synonym for V_$PING
  119. V$PX_PROCESS_TRACE             Synonym for V_$PX_PROCESS_TRACE
  120. V$REPLAY_CONTEXT             Synonym for V_$REPLAY_CONTEXT
  121. V$REPLAY_CONTEXT_LOB             Synonym for V_$REPLAY_CONTEXT_LOB
  122. V$REPLAY_CONTEXT_SEQUENCE         Synonym for V_$REPLAY_CONTEXT_SEQUENCE
  123. V$REPLAY_CONTEXT_SYSDATE         Synonym for V_$REPLAY_CONTEXT_SYSDATE
  124. V$REPLAY_CONTEXT_SYSGUID         Synonym for V_$REPLAY_CONTEXT_SYSGUID
  125. V$REPLAY_CONTEXT_SYSTIMESTAMP         Synonym for V_$REPLAY_CONTEXT_SYSTIMESTAMP
  126. V$RESTORE_RANGE              Synonym for V_$RESTORE_RANGE
  127. V$RO_USER_ACCOUNT             Synonym for V_$RO_USER_ACCOUNT
  128. V$RT_ADDM_CONTROL             Synonym for V_$RT_ADDM_CONTROL
  129. V$SBT_RESTORE_RANGE             Synonym for V_$SBT_RESTORE_RANGE
  130. V$SCHEDULER_INMEM_MDINFO         Synonym for V_$SCHEDULER_INMEM_MDINFO
  131. V$SCHEDULER_INMEM_RTINFO         Synonym for V_$SCHEDULER_INMEM_RTINFO
  132. V$SESSIONS_COUNT             Synonym for V_$SESSIONS_COUNT
  133. V$SQL_DIAG_REPOSITORY             Synonym for V_$SQL_DIAG_REPOSITORY
  134. V$SQL_DIAG_REPOSITORY_REASON         Synonym for V_$SQL_DIAG_REPOSITORY_REASON
  135. V$SQL_MONITOR_SESSTAT             Synonym for V_$SQL_MONITOR_SESSTAT
  136. V$SQL_MONITOR_STATNAME             Synonym for V_$SQL_MONITOR_STATNAME
  137. V$SQL_REOPTIMIZATION_HINTS         Synonym for V_$SQL_REOPTIMIZATION_HINTS
  138. V$SYS_REPORT_REQUESTS             Synonym for V_$SYS_REPORT_REQUESTS
  139. V$SYS_REPORT_STATS             Synonym for V_$SYS_REPORT_STATS
  140. V$TEMPUNDOSTAT                 Synonym for V_$TEMPUNDOSTAT
  141. V$TSDP_SUPPORTED_FEATURE         Synonym for V_$TSDP_SUPPORTED_FEATURE
  142. V$UNIFIED_AUDIT_RECORD_FORMAT         Synonym for V_$UNIFIED_AUDIT_RECORD_FORMAT
  143. V$UNIFIED_AUDIT_TRAIL             Synonym for V_$UNIFIED_AUDIT_TRAIL
  144. V$XSTREAM_APPLY_COORDINATOR         Synonym for V_$XSTREAM_APPLY_COORDINATOR
  145. V$XSTREAM_APPLY_READER             Synonym for V_$XSTREAM_APPLY_READER
  146. V$XSTREAM_APPLY_RECEIVER         Synonym for V_$XSTREAM_APPLY_RECEIVER
  147. V$XSTREAM_APPLY_SERVER             Synonym for V_$XSTREAM_APPLY_SERVER
  148. V$XS_SESSIONS                 Synonym for V_$XS_SESSIONS
  149. V$XS_SESSION_NS_ATTRIBUTE         Synonym for V_$XS_SESSION_NS_ATTRIBUTES
  150. V$XS_SESSION_NS_ATTRIBUTES         Synonym for V_$XS_SESSION_NS_ATTRIBUTES
  151. V$XS_SESSION_ROLES             Synonym for V_$XS_SESSION_ROLES
ASM又有好多新视图啊

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

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

下一篇: 12c
请登录后发表评论 登录
全部评论
从事Oracle/MySQL工作多年,11g OCM,擅长Oracle/MySQL SQL Tuning & DB Performance,高可用方案架构

注册时间:2014-10-30

  • 博文量
    253
  • 访问量
    1830970