ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > 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;

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

点击(此处)折叠或打开

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

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

点击(此处)折叠或打开

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

  5. Table created.

点击(此处)折叠或打开

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

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

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

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

点击(此处)折叠或打开

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

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

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

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

0
0
上一篇： processes 不够用了 ，用户登陆不了
下一篇： 12c
请登录后发表评论 登录
全部评论
哎呀我的天呐
专家姓名：姚崇
https://cloud.tencent.com/developer/inventory/14362

注册时间：2014-10-30

  • 博文量
    403
  • 访问量
    2528743

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593