Tibero  Reference Guide

Tibero 6


Restricted Rights Legend

All TmaxData Software (Tibero®) and documents are protected by copyright laws and international convention. TmaxData software and documents are made available under the terms of the TmaxData License Agreement and this document may only be distributed or copied in accordance with the terms of this agreement. No part of this document may be transmitted, copied, deployed, or reproduced in any form or by any means, electronic, mechanical, or optical, without the prior written consent of TmaxData Co., Ltd. Nothing in this software document and agreement constitutes a transfer of intellectual property rights regardless of whether or not such rights are registered) or any rights to TmaxData trademarks, logos, or any other brand features.

This document is for information purposes only. The company assumes no direct or indirect responsibilities for the contents of this document, and does not guarantee that the information contained in this document satisfies certain legal or commercial conditions. The information contained in this document is subject to change without prior notice due to product upgrades or updates. The company assumes no liability for any errors in this document.

Trademarks

Tibero® is a registered trademark of TmaxData Co., Ltd. Other products, titles or services may be registered trademarks of their respective companies.

Open Source Software Notice

Some modules or files of this product are subject to the terms of the following licenses. : OpenSSL, RSA Data Security, Inc., Apache Foundation, Jean-loup Gailly and Mark Adler, Paul Hsieh's hash

Detailed Information related to the license can be found in the following directory : ${INSTALL_PATH}/license/oss_licenses

Document Information

Title: Tibero  Reference Guide

Publication Date: 2020-03-13

Software Version: Tibero 6 (FixSet07)

Edition: v2.1.7.4


Table of Contents

About This Document
1. Introduction to Initialization Parameters
1.1. Overview
1.2. Class Attributes
1.3. Initialization Parameter
1.3.1. ACF_CMPT_CNT
1.3.2. ACTIVE_SESSION_HISTORY
1.3.3. ACTIVE_SESSION_TIMEOUT
1.3.4. ACT_LOG_DEST
1.3.5. ACT_LOG_FILE_SIZE
1.3.6. AS_ADDR
1.3.7. AS_ALLOW_ONLY_RAW_DISKS
1.3.8. AS_DISKSTRING
1.3.9. AS_PORT
1.3.10. AS_WTHR_CNT
1.3.11. AUDIT_FILE_DEST
1.3.12. AUDIT_FILE_SIZE
1.3.13. AUDIT_LOG_TOTAL_SIZE_LIMIT
1.3.14. AUDIT_SYS_OPERATIONS
1.3.15. AUDIT_TRAIL
1.3.16. AUTHENTICATION_TIMEOUT
1.3.17. AUTO_COALESCE
1.3.18. AUTO_COALESCE_INTERVAL
1.3.19. BATCHUPDATE_MODE
1.3.20. BATCH_INSERT_ROWCNT_THRESHOLD
1.3.21. BIND_VARIABLE_CAPTURE
1.3.22. BIND_VARIABLE_CAPTURE_ALLOC_COUNT
1.3.23. BIND_VARIABLE_CAPTURE_INTERVAL
1.3.24. BIND_VARIABLE_CAPTURE_KEEP_FIRST
1.3.25. BIND_VARIABLE_CAPTURE_MAX_COUNT
1.3.26. BIND_VARIABLE_CAPTURE_MAX_VAR_COUNT
1.3.27. BIND_VARIABLE_CAPTURE_POOL_PCTDEL
1.3.28. BIND_VARIABLE_CAPTURE_POOL_SIZE
1.3.29. BLOCK_CHANGE_TRACKING
1.3.30. BOOT_WITH_AUTO_DOWN_CLEAN
1.3.31. CALLSTACK_DUMP_DEST
1.3.32. CCC_CATH_CNT
1.3.33. CCC_MASTERING_UNIT
1.3.34. CCC_RECL_MAX_RESOURCES
1.3.35. CCC_RSBTBL_SIZE
1.3.36. CC_CU_BLKCNT
1.3.37. CC_CU_PCTUSE
1.3.38. CC_EXPECTED_RATE
1.3.39. CC_TYPICAL_ROW_SIZE
1.3.40. CERTIFICATE_FILE
1.3.41. CLOSE_REMOTE_SESSION_ON_SESSION_RESET
1.3.42. CLUSTER_DATABASE
1.3.43. CM_ENABLE_FAST_NET_ERROR_DETECTION
1.3.44. CM_FENCE
1.3.45. CM_GUARD_LOG_DEST
1.3.46. CM_HEARTBEAT_EXPIRE
1.3.47. CM_LOG_DEST
1.3.48. CM_LOG_FILE_SIZE
1.3.49. CM_LOG_TOTAL_SIZE_LIMIT
1.3.50. CM_MODE_OBSERVER
1.3.51. CM_NAME
1.3.52. CM_NET_EXPIRE_MARGIN
1.3.53. CM_OBSERVER_PORT
1.3.54. CM_PORT
1.3.55. CM_RESOURCE_FILE
1.3.56. CM_RESOURCE_FILE_BACKUP
1.3.57. CM_RESOURCE_FILE_BACKUP_INTERVAL
1.3.58. CM_TIME_UNIT
1.3.59. CM_UI_PORT
1.3.60. CM_VIP_FAILOVER_BASED_ON_SVC_STATUS
1.3.61. CM_WATCHDOG_EXPIRE
1.3.62. COMMIT_FLUSH_REQUEST
1.3.63. COMMIT_FLUSH_WAIT
1.3.64. COMMIT_POINT_STRENGTH
1.3.65. CONTROL_FILES
1.3.66. CPU_COUNT
1.3.67. CREATE_STORED_OUTLINES
1.3.68. CTHR_CHECK_CONNECTION_INTERVAL
1.3.69. CURRENT_SESSION_TEMP_TS
1.3.70. CURSOR_SHARING
1.3.71. CWS_RECL_MAX_RESOURCES
1.3.72. CWS_RSBTBL_SIZE
1.3.73. DBLINK_CONN_TIMEOUT
1.3.74. DBLINK_CONN_VALIDATION_SKIP_INTERVAL
1.3.75. DBLINK_QUERY_TIMEOUT
1.3.76. DBMS_LOG_DEST
1.3.77. DBMS_LOG_FILE_SIZE
1.3.78. DBMS_LOG_TOTAL_SIZE_LIMIT
1.3.79. DBWR_CNT
1.3.80. DB_BLOCK_SIZE
1.3.81. DB_CACHE_SIZE
1.3.82. DB_CREATE_FILE_DEST
1.3.83. DB_FILE_MULTIBLOCK_READ_COUNT
1.3.84. DB_KEEP_CACHE_SIZE
1.3.85. DB_MULTIBLOCK_PREFETCH_COUNT
1.3.86. DB_NAME
1.3.87. DB_RECYCLE_CACHE_SIZE
1.3.88. DD_CACHE_MAX
1.3.89. DEFAULT_SEQ_CACHE_SIZE
1.3.90. DF_HDRBLK_START_OFFSET
1.3.91. DISK_PATH
1.3.92. DONT_USE_FILE_BUFFERING
1.3.93. DPL_INDEX_METHOD
1.3.94. ENCRYPTION_WALLET_FILE
1.3.95. EVENT_TRACE
1.3.96. EVENT_TRACE_DEST
1.3.97. EVENT_TRACE_FILE_BACKUP_ON_BOOT
1.3.98. EVENT_TRACE_FILE_SIZE
1.3.99. EVENT_TRACE_MAP
1.3.100. EVENT_TRACE_TOTAL_SIZE_LIMIT
1.3.101. EXTRA_LISTENER_PORTS
1.3.102. EX_MEMORY_AUTO_MANAGEMENT
1.3.103. EX_MEMORY_COMPENSATE_INTERVAL
1.3.104. EX_MEMORY_DRIFT_CHECK_INTERVAL
1.3.105. EX_MEMORY_DRIFT_RATIO
1.3.106. FDPOOL_HASH_SIZE
1.3.107. FLASHBACK_BUFFER_RATIO
1.3.108. FLASHBACK_LOG_ARCHIVE_FORMAT
1.3.109. GATHER_SQL_EXEC_TIME
1.3.110. GATHER_SQL_PLAN_STAT
1.3.111. HASH_AREA_SIZE
1.3.112. HBASE_CONNECTOR_SCAN_CACHE
1.3.113. ILOG_DEST
1.3.114. ILOG_FILE_BACKUP_ON_BOOT
1.3.115. ILOG_FILE_SIZE
1.3.116. ILOG_MAP
1.3.117. ILOG_TOTAL_SIZE_LIMIT
1.3.118. INSTANCE_NUMBER
1.3.119. INSTANCE_TYPE
1.3.120. IP_VERSION
1.3.121. JAVA_CLASS_PATH
1.3.122. JOB_HISTORY_LOG
1.3.123. JOB_TRACE_LOG
1.3.124. KEEP_STAT_PER_SQL
1.3.125. LIBRARY_CACHE_MAX
1.3.126. LIBRARY_DD_CACHE_MAX
1.3.127. LISTENER_IP
1.3.128. LISTENER_PORT
1.3.129. LOAD_METRIC_AUTO_INTERVAL
1.3.130. LOAD_METRIC_COLLECT_INTERVAL_MAX
1.3.131. LOAD_METRIC_COLLECT_INTERVAL_MIN
1.3.132. LOAD_METRIC_HISTORY_COUNT
1.3.133. LOCAL_CLUSTER_ADDR
1.3.134. LOCAL_CLUSTER_IP_VERSION
1.3.135. LOCAL_CLUSTER_PORT
1.3.136. LOG_ARCHIVE_DEST
1.3.137. LOG_ARCHIVE_DEST_1
1.3.138. LOG_ARCHIVE_DEST_2
1.3.139. LOG_ARCHIVE_DEST_3
1.3.140. LOG_ARCHIVE_DEST_4
1.3.141. LOG_ARCHIVE_DEST_5
1.3.142. LOG_ARCHIVE_DEST_6
1.3.143. LOG_ARCHIVE_DEST_7
1.3.144. LOG_ARCHIVE_DEST_8
1.3.145. LOG_ARCHIVE_DEST_9
1.3.146. LOG_ARCHIVE_FORMAT
1.3.147. LOG_ARCHIVE_OVERWRITE
1.3.148. LOG_ARCHIVE_RETRY_TIME
1.3.149. LOG_BUFFER
1.3.150. LOG_CHECKPOINT_INTERVAL
1.3.151. LOG_CHECKPOINT_TIMEOUT
1.3.152. LOG_DEFAULT_DEST
1.3.153. LOG_LVL_AS
1.3.154. LOG_LVL_CM
1.3.155. LOG_LVL_LIS
1.3.156. LOG_ON_MEMORY
1.3.157. LOG_ON_MEMORY_SIZE
1.3.158. LOG_REPLICATION_1_ENABLE
1.3.159. LOG_REPLICATION_2_ENABLE
1.3.160. LOG_REPLICATION_3_ENABLE
1.3.161. LOG_REPLICATION_4_ENABLE
1.3.162. LOG_REPLICATION_5_ENABLE
1.3.163. LOG_REPLICATION_6_ENABLE
1.3.164. LOG_REPLICATION_7_ENABLE
1.3.165. LOG_REPLICATION_8_ENABLE
1.3.166. LOG_REPLICATION_9_ENABLE
1.3.167. LOG_REPLICATION_DEST_1
1.3.168. LOG_REPLICATION_DEST_2
1.3.169. LOG_REPLICATION_DEST_3
1.3.170. LOG_REPLICATION_DEST_4
1.3.171. LOG_REPLICATION_DEST_5
1.3.172. LOG_REPLICATION_DEST_6
1.3.173. LOG_REPLICATION_DEST_7
1.3.174. LOG_REPLICATION_DEST_8
1.3.175. LOG_REPLICATION_DEST_9
1.3.176. LOG_REPLICATION_MODE
1.3.177. LONGOPS_KEEP_INTERVAL
1.3.178. LONGOPS_THRESHOLD_SEC
1.3.179. LONG_OPERATION_KEEP_COUNT
1.3.180. LSNR_DENIED_IP
1.3.181. LSNR_DENIED_IP_FILE
1.3.182. LSNR_INVITED_IP
1.3.183. LSNR_INVITED_IP_FILE
1.3.184. LSNR_LISTEN_BACKLOG
1.3.185. LSNR_LOG_DEST
1.3.186. LSNR_LOG_FILE_SIZE
1.3.187. LSNR_LOG_TOTAL_SIZE_LIMIT
1.3.188. MAX_BG_SESSION_COUNT
1.3.189. MAX_SESSION_COUNT
1.3.190. MEMORY_MAX_TARGET
1.3.191. MEMORY_MODEL
1.3.192. MEMORY_TARGET
1.3.193. MEM_LOG_DEST
1.3.194. NAMED_PIPE_DIR
1.3.195. NLS_CALENDAR
1.3.196. NLS_COMP
1.3.197. NLS_CURRENCY
1.3.198. NLS_DATE_FORMAT
1.3.199. NLS_DATE_LANGUAGE
1.3.200. NLS_ISO_CURRENCY
1.3.201. NLS_LANGUAGE
1.3.202. NLS_LANG_AT_BOOT
1.3.203. NLS_LENGTH_SEMANTICS
1.3.204. NLS_NUMERIC_CHARACTERS
1.3.205. NLS_SORT
1.3.206. NLS_TERRITORY
1.3.207. NLS_TIMESTAMP_FORMAT
1.3.208. NLS_TIMESTAMP_TZ_FORMAT
1.3.209. NLS_TIME_FORMAT
1.3.210. OMIT_PSM_SQL_LOG_ON_MEMORY
1.3.211. OPEN_CURSORS
1.3.212. OPTIMIZER_MODE
1.3.213. OPTIMIZER_TRACE
1.3.214. OPTIMIZER_USE_INVISIBLE_INDEXES
1.3.215. OS_AUTH_PREFIX
1.3.216. PARALLEL_DEFAULT_DOP
1.3.217. PARALLEL_GRANULE_SIZE
1.3.218. PARALLEL_THREADS_PER_CPU
1.3.219. PEP_PROC_CNT
1.3.220. PRIVKEY_FILE
1.3.221. PSM_CODE_TYPE
1.3.222. PSM_DEBUG
1.3.223. PSM_ERROR_CONV
1.3.224. PSM_SHLIB_DIR
1.3.225. PSM_SQL_RESULT_CACHE
1.3.226. QUERY_REWRITE_ENABLED
1.3.227. QUERY_REWRITE_INTEGRITY
1.3.228. RECO_PROC_WTHR_CNT
1.3.229. RESULT_CACHE_MAX_RATIO
1.3.230. RESULT_CACHE_MAX_SIZE
1.3.231. RESULT_CACHE_MODE
1.3.232. RESUMABLE_SPACE_ALLOC
1.3.233. RESUMABLE_SPACE_ALLOC_TIMEOUT
1.3.234. RMGR_BACKUP_DEST
1.3.235. RMGR_TAR_PATH
1.3.236. RSRC_CHECK_INTERVAL
1.3.237. RSRC_CONTROL_THRESHOLD
1.3.238. RT_AWAKE_WAITER_INTERVAL
1.3.239. RT_UPDATE_ALLOWABLE_INFLOW_CNT_INTERVAL
1.3.240. SANITY_CHECK_DURING_LOG_SWITCH
1.3.241. SEGMENT_EXTEND_LAST
1.3.242. SEM_KEY
1.3.243. SEM_SET_COUNT
1.3.244. SEPARATION_OF_DUTIES
1.3.245. SERVER_LOAD_TOLERANCE
1.3.246. SERVER_SIDE_LOAD_BALANCE
1.3.247. SERVICE_CONTROL_STOP_DOWNMODE
1.3.248. SHARED_PARAMETER_FILE
1.3.249. SHM_KEY
1.3.250. SHP_ALLOC_DUMP_IDX
1.3.251. SHP_ALLOC_FULL_DUMP
1.3.252. SLAB_BLOCK_RESERVED_COUNT
1.3.253. SLOG_DEST
1.3.254. SLOG_FILE_SIZE
1.3.255. SLOG_HISTORY
1.3.256. SLOG_HISTORY_BUFSIZE
1.3.257. SLOG_HISTORY_QSIZE
1.3.258. SLOG_TOTAL_SIZE_LIMIT
1.3.259. SORT_AREA_SIZE
1.3.260. SPIN_PARAMETER_AUTO_ADJUST
1.3.261. SPIN_PARAMETER_PER_TYPE
1.3.262. SQL_LOG_ON_MEMORY
1.3.263. SQL_LOG_ON_MEMORY_SIZE
1.3.264. SQL_STAT_HISTORY
1.3.265. SQL_STAT_HISTORY_QSIZE
1.3.266. SQL_STAT_HISTORY_THRESHOLD
1.3.267. SQL_TRACE
1.3.268. SQL_TRACE_DEST
1.3.269. SQL_TRANSLATION_PROFILE
1.3.270. STANDBY_FILE_NAME_CONVERT
1.3.271. STANDBY_FLUSH_WAIT
1.3.272. STANDBY_USE_OBSERVER
1.3.273. STAR_TRANSFORMATION_ENABLED
1.3.274. SUMMARY_FIRST_IN_GROUPBY_CUBE
1.3.275. TABLE_GLOBAL_COMPRESSION
1.3.276. TCP_RCVBUF_SIZE
1.3.277. TCP_SNDBUF_SIZE
1.3.278. TDE_HASH_VERIFICATION
1.3.279. TDE_SELF_UPDATE_MODIFICATION_DEFENCE
1.3.280. TEMP_GRANULE_SIZE
1.3.281. TEMP_TABLESPACE
1.3.282. THREAD
1.3.283. TIBERO_PERFORMANCE_REPOSITORY
1.3.284. TOTAL_SHM_MAX_SIZE
1.3.285. TOTAL_SHM_SIZE
1.3.286. TPR_AGGREGATION
1.3.287. TPR_METRIC
1.3.288. TPR_SEGMENT_STATISTICS
1.3.289. TPR_SNAPSHOT_RETENTION
1.3.290. TPR_SNAPSHOT_SAMPLING_INTERVAL
1.3.291. TPR_SNAPSHOT_TOP_SEGMENT_CNT
1.3.292. TPR_SNAPSHOT_TOP_SQL_CNT
1.3.293. TRACE_DUMP_DEST
1.3.294. TRACE_LOG_DEST
1.3.295. TRACE_LOG_DISPLAY_YEAR
1.3.296. TRACE_LOG_FILE_SIZE
1.3.297. TRACE_LOG_FILE_TRUNC
1.3.298. TRACE_LOG_TOTAL_SIZE_LIMIT
1.3.299. TSAM_PREFETCH_SIZE
1.3.300. TSN_SYNC_UDP_PORT
1.3.301. TX_FORCE_COMMIT_DUMP
1.3.302. TX_RECOVERY_SESSION_COUNT
1.3.303. UNDO_RETENTION
1.3.304. UNDO_TABLESPACE
1.3.305. USE_ACTIVE_STORAGE
1.3.306. USE_ILOG
1.3.307. USE_NET_KEEPALIVE
1.3.308. USE_PROFILE
1.3.309. USE_PROFILE_LOGIN_LOGOUT_TIME
1.3.310. USE_RECYCLEBIN
1.3.311. USE_RESOURCE_MANAGER
1.3.312. USE_SSVR
1.3.313. USE_STORED_OUTLINES
1.3.314. USE_TRUNCATE_PRIVILEGE
1.3.315. USE_TS_QUOTA
1.3.316. USGMT_AUTO_SHRINK_INTERVAL
1.3.317. UTL_FILE_DIR
1.3.318. WALLET_FILE
1.3.319. WTHR_PROC_CNT
1.3.320. WTHR_PROC_CNT_MAX
1.3.321. XA_MAX_BRANCH_CNT
1.3.322. XA_TIMER_INTERVAL
2. Data Dictionary
2.1. Overview
2.2. Data Dictionary Structure
2.2.1. Base Tables
2.2.2. Static/Dynamic Views
2.3. Referencing Data Dictionary
2.3.1. Referenced by User
2.3.2. Referenced by SQL Parser/Query Optimizer
2.3.3. Referenced by Tibero
2.4. Updating Data Dictionary
2.4.1. DDL Statements
3. Static View
3.1. Overview
3.2. List of Static Views
3.2.1. ALL_ARGUMENTS
3.2.2. ALL_CATALOG
3.2.3. ALL_COLL_TYPES
3.2.4. ALL_COL_COMMENTS
3.2.5. ALL_COL_PRIVS
3.2.6. ALL_COL_PRIVS_MADE
3.2.7. ALL_COL_PRIVS_RECD
3.2.8. ALL_CONSTRAINTS
3.2.9. ALL_CONS_COLUMNS
3.2.10. ALL_CONS_COLUMNS_INFO
3.2.11. ALL_DB_LINKS
3.2.12. ALL_DEPENDENCIES
3.2.13. ALL_DIRECTORIES
3.2.14. ALL_ENCRYPTED_COLUMNS
3.2.15. ALL_ERRORS
3.2.16. ALL_EXTERNAL_LOCATIONS
3.2.17. ALL_EXTERNAL_TABLES
3.2.18. ALL_IDX_AND_LOB_COLUMNS_INFO
3.2.19. ALL_IDX_COLUMNS
3.2.20. ALL_IDX_COLUMNS_INFO
3.2.21. ALL_IDX_EXPRESSIONS
3.2.22. ALL_IDX_PARTITIONS
3.2.23. ALL_IDX_SUBPARTITIONS
3.2.24. ALL_INDEXES
3.2.25. ALL_IND_COLUMNS
3.2.26. ALL_IND_EXPRESSIONS
3.2.27. ALL_IND_PARTITIONS
3.2.28. ALL_IND_SUBPARTITIONS
3.2.29. ALL_JAVA_ARGUMENTS
3.2.30. ALL_JAVA_CLASSES
3.2.31. ALL_JAVA_FIELDS
3.2.32. ALL_JAVA_METHODS
3.2.33. ALL_JOBS
3.2.34. ALL_LIBRARIES
3.2.35. ALL_LOBS
3.2.36. ALL_LOB_PARTITIONS
3.2.37. ALL_LOB_SUBPARTITIONS
3.2.38. ALL_LOG_GROUPS
3.2.39. ALL_LOG_GROUP_COLUMNS
3.2.40. ALL_METHOD_PARAMS
3.2.41. ALL_METHOD_RESULTS
3.2.42. ALL_MVIEWS
3.2.43. ALL_MVIEW_COMMENTS
3.2.44. ALL_MVIEW_LOGS
3.2.45. ALL_OBJECTS
3.2.46. ALL_PACKAGE_MEMBER_TYPES
3.2.47. ALL_PART_INDEXES
3.2.48. ALL_PART_KEY_COLUMNS
3.2.49. ALL_PART_LOBS
3.2.50. ALL_PART_TABLES
3.2.51. ALL_PROCEDURES
3.2.52. ALL_QUEUES
3.2.53. ALL_QUEUE_SUBSCRIBERS
3.2.54. ALL_QUEUE_TABLES
3.2.55. ALL_RECYCLEBIN
3.2.56. ALL_SCHEDULER_CHAINS
3.2.57. ALL_SCHEDULER_JOBS
3.2.58. ALL_SCHEDULER_PROGRAMS
3.2.59. ALL_SCHEDULER_RULES
3.2.60. ALL_SCHEDULER_RULE_CTX
3.2.61. ALL_SCHEDULER_RUNNING_JOBS
3.2.62. ALL_SCHEDULER_STEPS
3.2.63. ALL_SCHEDULER_STEP_CTX
3.2.64. ALL_SEGMENTS
3.2.65. ALL_SEQUENCES
3.2.66. ALL_SOURCE
3.2.67. ALL_SUBPART_KEY_COLUMNS
3.2.68. ALL_SYNONYMS
3.2.69. ALL_TABLES
3.2.70. ALL_TAB_COLS
3.2.71. ALL_TAB_COLUMNS
3.2.72. ALL_TAB_COL_STATISTICS
3.2.73. ALL_TAB_COMMENTS
3.2.74. ALL_TAB_HISTOGRAMS
3.2.75. ALL_TAB_PARTITIONS
3.2.76. ALL_TAB_PRIVS
3.2.77. ALL_TAB_PRIVS_MADE
3.2.78. ALL_TAB_PRIVS_RECD
3.2.79. ALL_TAB_SUBPARTITIONS
3.2.80. ALL_TBL_COLS
3.2.81. ALL_TBL_COLUMNS
3.2.82. ALL_TBL_COLUMNS_WITH_DNO
3.2.83. ALL_TBL_COL_STATISTICS
3.2.84. ALL_TBL_COMMENTS
3.2.85. ALL_TBL_HISTOGRAMS
3.2.86. ALL_TBL_PARTITIONS
3.2.87. ALL_TBL_PRIVS
3.2.88. ALL_TBL_PRIVS_MADE
3.2.89. ALL_TBL_PRIVS_RECD
3.2.90. ALL_TBL_SUBPARTITIONS
3.2.91. ALL_TRIGGERS
3.2.92. ALL_TRIGGER_COLS
3.2.93. ALL_TYPES
3.2.94. ALL_TYPE_ATTRS
3.2.95. ALL_TYPE_METHODS
3.2.96. ALL_UPDATABLE_COLUMNS
3.2.97. ALL_USERS
3.2.98. ALL_VIEWS
3.2.99. ALL_VIEWS_INTERNAL
3.2.100. DATABASE_PROPERTIES
3.2.101. DBA_2PC_NEIGHBORS
3.2.102. DBA_2PC_PENDING
3.2.103. DBA_AUDIT_TRAIL
3.2.104. DBA_CATALOG
3.2.105. DBA_COLL_TYPES
3.2.106. DBA_COL_COMMENTS
3.2.107. DBA_COL_PRIVS
3.2.108. DBA_CONSTRAINTS
3.2.109. DBA_CONS_COLUMNS
3.2.110. DBA_DATAFILES
3.2.111. DBA_DATA_FILES
3.2.112. DBA_DB_LINKS
3.2.113. DBA_DEPENDENCIES
3.2.114. DBA_DIRECTORIES
3.2.115. DBA_ENCRYPTED_COLUMNS
3.2.116. DBA_ERRORS
3.2.117. DBA_EXTENTS
3.2.118. DBA_EXTERNAL_LOCATIONS
3.2.119. DBA_EXTERNAL_TABLES
3.2.120. DBA_FREE_SPACE
3.2.121. DBA_HIST_ACTIVE_SESS_HISTORY
3.2.122. DBA_HIST_FILESTAT
3.2.123. DBA_HIST_LATCH
3.2.124. DBA_HIST_LIBRARYCACHE
3.2.125. DBA_HIST_OSSTAT
3.2.126. DBA_HIST_PGASTAT
3.2.127. DBA_HIST_PROCESS_MEM_SUMMARY
3.2.128. DBA_HIST_SEG_STAT
3.2.129. DBA_HIST_SGASTAT
3.2.130. DBA_HIST_SNAPSHOT
3.2.131. DBA_HIST_SQLSTAT
3.2.132. DBA_HIST_SQLTEXT
3.2.133. DBA_HIST_SQL_PLAN
3.2.134. DBA_HIST_SQL_WORKAREA_HSTGRM
3.2.135. DBA_HIST_SYSMETRIC_SUMMARY
3.2.136. DBA_HIST_SYSTEM_EVENT
3.2.137. DBA_HIST_UNDOSTAT
3.2.138. DBA_HIST_WAITSTAT
3.2.139. DBA_IDX_COLUMNS
3.2.140. DBA_IDX_EXPRESSIONS
3.2.141. DBA_IDX_PARTITIONS
3.2.142. DBA_IDX_SUBPARTITIONS
3.2.143. DBA_INDEXES
3.2.144. DBA_IND_COLUMNS
3.2.145. DBA_IND_EXPRESSIONS
3.2.146. DBA_IND_PARTITIONS
3.2.147. DBA_IND_SUBPARTITIONS
3.2.148. DBA_JAVA_ARGUMENTS
3.2.149. DBA_JAVA_CLASSES
3.2.150. DBA_JAVA_FIELDS
3.2.151. DBA_JAVA_METHODS
3.2.152. DBA_JOBS
3.2.153. DBA_LIBRARIES
3.2.154. DBA_LOBS
3.2.155. DBA_LOB_PARTITIONS
3.2.156. DBA_LOB_SUBPARTITIONS
3.2.157. DBA_LOG_GROUPS
3.2.158. DBA_LOG_GROUP_COLUMNS
3.2.159. DBA_METHOD_PARAMS
3.2.160. DBA_METHOD_RESULTS
3.2.161. DBA_MVIEWS
3.2.162. DBA_MVIEW_COMMENTS
3.2.163. DBA_MVIEW_LOGS
3.2.164. DBA_OBJECTS
3.2.165. DBA_OBJ_AUDIT_OPTS
3.2.166. DBA_PACKAGE_MEMBER_TYPES
3.2.167. DBA_PART_INDEXES
3.2.168. DBA_PART_KEY_COLUMNS
3.2.169. DBA_PART_LOBS
3.2.170. DBA_PART_TABLES
3.2.171. DBA_PRIV_AUDIT_OPTS
3.2.172. DBA_PROCEDURES
3.2.173. DBA_PROFILES
3.2.174. DBA_QUEUES
3.2.175. DBA_QUEUE_SUBSCRIBERS
3.2.176. DBA_QUEUE_TABLES
3.2.177. DBA_RECYCLEBIN
3.2.178. DBA_REDEFINITION_OBJECTS
3.2.179. DBA_ROLES
3.2.180. DBA_ROLE_PRIVS
3.2.181. DBA_ROLLBACK_SEGS
3.2.182. DBA_RSRC_AUDIT
3.2.183. DBA_RSRC_CONSUMER_GROUPS
3.2.184. DBA_RSRC_PLANS
3.2.185. DBA_RSRC_PLAN_DIRECTIVES
3.2.186. DBA_SCHEDULER_CHAINS
3.2.187. DBA_SCHEDULER_JOBS
3.2.188. DBA_SCHEDULER_PROGRAMS
3.2.189. DBA_SCHEDULER_RULES
3.2.190. DBA_SCHEDULER_RULE_CTX
3.2.191. DBA_SCHEDULER_RUNNING_JOBS
3.2.192. DBA_SCHEDULER_STEPS
3.2.193. DBA_SCHEDULER_STEP_CTX
3.2.194. DBA_SEGMENTS
3.2.195. DBA_SEQUENCES
3.2.196. DBA_SOURCE
3.2.197. DBA_SUBPART_KEY_COLUMNS
3.2.198. DBA_SYNONYMS
3.2.199. DBA_SYS_PRIVS
3.2.200. DBA_TABLES
3.2.201. DBA_TABLESPACES
3.2.202. DBA_TAB_COLS
3.2.203. DBA_TAB_COLUMNS
3.2.204. DBA_TAB_COL_STATISTICS
3.2.205. DBA_TAB_COMMENTS
3.2.206. DBA_TAB_HISTOGRAMS
3.2.207. DBA_TAB_PARTITIONS
3.2.208. DBA_TAB_PRIVS
3.2.209. DBA_TAB_SUBPARTITIONS
3.2.210. DBA_TBL_COLS
3.2.211. DBA_TBL_COLUMNS
3.2.212. DBA_TBL_COL_STATISTICS
3.2.213. DBA_TBL_COMMENTS
3.2.214. DBA_TBL_HISTOGRAMS
3.2.215. DBA_TBL_PARTITIONS
3.2.216. DBA_TBL_PRIVS
3.2.217. DBA_TBL_SUBPARTITIONS
3.2.218. DBA_TEMPFILES
3.2.219. DBA_TEMP_FILES
3.2.220. DBA_TRIGGERS
3.2.221. DBA_TRIGGER_COLS
3.2.222. DBA_TS_QUOTAS
3.2.223. DBA_TYPES
3.2.224. DBA_TYPE_ATTRS
3.2.225. DBA_TYPE_METHODS
3.2.226. DBA_UNDO_EXTENTS
3.2.227. DBA_UNDO_SGMTS
3.2.228. DBA_UPDATABLE_COLUMNS
3.2.229. DBA_USERS
3.2.230. DBA_VIEWS
3.2.231. DICTIONARY
3.2.232. NLS_SESSION_PARAMETERS
3.2.233. PUBLICSYN
3.2.234. ROLE_ROLE_PRIVS
3.2.235. ROLE_SYS_PRIVS
3.2.236. ROLE_TAB_PRIVS
3.2.237. SESSION_CONTEXT
3.2.238. SESSION_PRIVS
3.2.239. SESSION_ROLES
3.2.240. SYS_OBJECTS
3.2.241. USER_ARGUMENTS
3.2.242. USER_AUDIT_TRAIL
3.2.243. USER_CATALOG
3.2.244. USER_COLL_TYPES
3.2.245. USER_COL_COMMENTS
3.2.246. USER_COL_PRIVS
3.2.247. USER_COL_PRIVS_MADE
3.2.248. USER_COL_PRIVS_RECD
3.2.249. USER_CONSTRAINTS
3.2.250. USER_CONS_COLUMNS
3.2.251. USER_DB_LINKS
3.2.252. USER_DEPENDENCIES
3.2.253. USER_ENCRYPTED_COLUMNS
3.2.254. USER_ERRORS
3.2.255. USER_EXTENTS
3.2.256. USER_EXTERNAL_LOCATIONS
3.2.257. USER_EXTERNAL_TABLES
3.2.258. USER_FREE_SPACE
3.2.259. USER_IDX_COLUMNS
3.2.260. USER_IDX_EXPRESSIONS
3.2.261. USER_IDX_PARTITIONS
3.2.262. USER_INDEXES
3.2.263. USER_IND_COLUMNS
3.2.264. USER_IND_EXPRESSIONS
3.2.265. USER_IND_PARTITIONS
3.2.266. USER_JAVA_ARGUMENTS
3.2.267. USER_JAVA_CLASSES
3.2.268. USER_JAVA_FIELDS
3.2.269. USER_JAVA_METHODS
3.2.270. USER_JOBS
3.2.271. USER_LIBRARIES
3.2.272. USER_LOBS
3.2.273. USER_LOB_PARTITIONS
3.2.274. USER_LOB_SUBPARTITIONS
3.2.275. USER_LOG_GROUPS
3.2.276. USER_LOG_GROUP_COLUMNS
3.2.277. USER_METHOD_PARAMS
3.2.278. USER_METHOD_RESULTS
3.2.279. USER_MVIEWS
3.2.280. USER_MVIEW_COMMENTS
3.2.281. USER_MVIEW_LOGS
3.2.282. USER_OBJECTS
3.2.283. USER_OBJ_AUDIT_OPTS
3.2.284. USER_PACKAGE_MEMBER_TYPES
3.2.285. USER_PART_INDEXES
3.2.286. USER_PART_KEY_COLUMNS
3.2.287. USER_PART_LOBS
3.2.288. USER_PART_TABLES
3.2.289. USER_PROCEDURES
3.2.290. USER_QUEUES
3.2.291. USER_QUEUE_SUBSCRIBERS
3.2.292. USER_QUEUE_TABLES
3.2.293. USER_RECYCLEBIN
3.2.294. USER_ROLE_PRIVS
3.2.295. USER_SCHEDULER_CHAINS
3.2.296. USER_SCHEDULER_JOBS
3.2.297. USER_SCHEDULER_PROGRAMS
3.2.298. USER_SCHEDULER_RULES
3.2.299. USER_SCHEDULER_RULE_CTX
3.2.300. USER_SCHEDULER_RUNNING_JOBS
3.2.301. USER_SCHEDULER_STEPS
3.2.302. USER_SCHEDULER_STEP_CTX
3.2.303. USER_SEGMENTS
3.2.304. USER_SEQUENCES
3.2.305. USER_SOURCE
3.2.306. USER_SUBPART_KEY_COLUMNS
3.2.307. USER_SYNONYMS
3.2.308. USER_SYS_PRIVS
3.2.309. USER_TABLES
3.2.310. USER_TABLESPACES
3.2.311. USER_TAB_COLS
3.2.312. USER_TAB_COLUMNS
3.2.313. USER_TAB_COL_STATISTICS
3.2.314. USER_TAB_COMMENTS
3.2.315. USER_TAB_HISTOGRAMS
3.2.316. USER_TAB_PARTITIONS
3.2.317. USER_TAB_PRIVS
3.2.318. USER_TAB_PRIVS_MADE
3.2.319. USER_TAB_PRIVS_RECD
3.2.320. USER_TBL_COLS
3.2.321. USER_TBL_COLUMNS
3.2.322. USER_TBL_COL_STATISTICS
3.2.323. USER_TBL_COMMENTS
3.2.324. USER_TBL_HISTOGRAMS
3.2.325. USER_TBL_PARTITIONS
3.2.326. USER_TBL_PRIVS
3.2.327. USER_TBL_PRIVS_MADE
3.2.328. USER_TBL_PRIVS_RECD
3.2.329. USER_TRIGGERS
3.2.330. USER_TRIGGER_COLS
3.2.331. USER_TYPES
3.2.332. USER_TYPE_ATTRS
3.2.333. USER_TYPE_METHODS
3.2.334. USER_UPDATABLE_COLUMNS
3.2.335. USER_USERS
3.2.336. USER_VIEWS
4. Dynamic View
4.1. Overview
4.2. List of Dynamic Views
4.2.1. V$ACCESS
4.2.2. V$ACTIVE_SESSION_HISTORY
4.2.3. V$ALL_FILESTAT
4.2.4. V$ARCHIVED_LOG
4.2.5. V$ARCHIVE_DEST_FILES
4.2.6. V$AS_ALIAS
4.2.7. V$AS_DISK
4.2.8. V$AS_DISKSPACE
4.2.9. V$AS_EXTENT_MAP
4.2.10. V$AS_FILE
4.2.11. V$AS_OPERATION
4.2.12. V$AS_USER
4.2.13. V$AS_USERGROUP
4.2.14. V$AS_USERGROUP_MEMBER
4.2.15. V$AUTO_COALESCE
4.2.16. V$BACKUP
4.2.17. V$BACKUP_ARCHIVED_LOG
4.2.18. V$BACKUP_SET
4.2.19. V$BACKUP_SET_TABLESPACE
4.2.20. V$BG_SESSION
4.2.21. V$BG_SESSTAT
4.2.22. V$BH
4.2.23. V$BLOCKER_SESSION
4.2.24. V$BPARAMETERS
4.2.25. V$BUFFER_CACHE_ADVICE
4.2.26. V$BUFFER_POOL
4.2.27. V$BUFFER_POOL_STATISTICS
4.2.28. V$CHECKPOINT
4.2.29. V$CLUSTER_INTERCONNECTS
4.2.30. V$CONTEXT
4.2.31. V$CONTROLFILE
4.2.32. V$CORRUPT_XID
4.2.33. V$DATABASE
4.2.34. V$DATAFILE
4.2.35. V$DATAFILE_HEADER
4.2.36. V$DBFILE
4.2.37. V$DBLINK
4.2.38. V$DBLINK_STATUS
4.2.39. V$DB_PIPES
4.2.40. V$ENCRYPTED_TABLESPACES
4.2.41. V$ENCRYPTION_WALLET
4.2.42. V$ENQUEUE_STAT
4.2.43. V$EST_CHECKPOINT_TIME
4.2.44. V$EVENT_NAME
4.2.45. V$FILESTAT
4.2.46. V$GLOBAL_TRANSACTION
4.2.47. V$INSTANCE
4.2.48. V$INSTANCEMETRIC
4.2.49. V$INSTANCEMETRIC_HISTORY
4.2.50. V$INTERCONNECT_LATENCY
4.2.51. V$INTERCONNECTION
4.2.52. V$IPARAM_DESC
4.2.53. V$LATCH
4.2.54. V$LIBRARYCACHE
4.2.55. V$LICENSE
4.2.56. V$LOCK
4.2.57. V$LOG
4.2.58. V$LOGFILE
4.2.59. V$LOG_HISTORY
4.2.60. V$MEDIA_RECOVERY_PROGRESS
4.2.61. V$METRIC
4.2.62. V$METRICNAME
4.2.63. V$MYSTAT
4.2.64. V$OBJECT_USAGE
4.2.65. V$OPEN_CURSOR
4.2.66. V$OSSTAT
4.2.67. V$OSSTAT2
4.2.68. V$PARAMETERS
4.2.69. V$PATCH
4.2.70. V$PE_PESPLAN
4.2.71. V$PE_PESSTAT
4.2.72. V$PE_PROCESS
4.2.73. V$PE_SESSION
4.2.74. V$PE_SYSSTAT
4.2.75. V$PE_TQSTAT
4.2.76. V$PGASTAT
4.2.77. V$PROCESS
4.2.78. V$PROXY_SQLTEXT
4.2.79. V$PROXY_SQL_PARAM
4.2.80. V$RECOVERY_FILE_STATUS
4.2.81. V$RECOVERY_PROGRESS
4.2.82. V$RECOVERY_STATUS
4.2.83. V$RECOVER_FILE
4.2.84. V$RESERVED_WORDS
4.2.85. V$RESULT_CACHE_DEPENDENCY
4.2.86. V$RESULT_CACHE_OBJECTS
4.2.87. V$RESULT_CACHE_OBJECT_STATISTICS
4.2.88. V$RESULT_CACHE_STATISTICS
4.2.89. V$ROLLSTAT
4.2.90. V$ROWCACHE
4.2.91. V$RSBSTAT
4.2.92. V$RSRC_CONSUMER_GROUP
4.2.93. V$RSRC_PLAN
4.2.94. V$RSRC_SESSION_INFO
4.2.95. V$RUNNING_JOBS
4.2.96. V$RUNNING_JOBS_WITH_NAME
4.2.97. V$SEGMENT_STATISTICS
4.2.98. V$SESSION
4.2.99. V$SESSION_EVENT
4.2.100. V$SESSION_IO
4.2.101. V$SESSION_LONGOPS
4.2.102. V$SESSION_WAIT
4.2.103. V$SESSTAT
4.2.104. V$SESS_TIME_MODEL
4.2.105. V$SGA
4.2.106. V$SGASTAT
4.2.107. V$SHP_ADVICE
4.2.108. V$SPINUSE_STAT
4.2.109. V$SQL
4.2.110. V$SQLAREA
4.2.111. V$SQLSTATS
4.2.112. V$SQLTEXT
4.2.113. V$SQLTEXT2
4.2.114. V$SQLTEXT_WITH_NEWLINES
4.2.115. V$SQLTEXT_WITH_NEWLINES2
4.2.116. V$SQL_BIND_CAPTURE
4.2.117. V$SQL_BIND_CAPTURE_ALL
4.2.118. V$SQL_EXPC_INFO
4.2.119. V$SQL_MONITOR
4.2.120. V$SQL_PLAN
4.2.121. V$SQL_PLAN_MONITOR
4.2.122. V$SQL_PLAN_STATISTICS
4.2.123. V$SQL_WORKAREA
4.2.124. V$SQL_WORKAREA_HISTOGRAM
4.2.125. V$SSVR_CLIENT
4.2.126. V$SSVR_FLASHCACHE
4.2.127. V$SSVR_GRID_DISK
4.2.128. V$SSVR_IOLOAD
4.2.129. V$SSVR_IORM_CATEGORY_PLAN
4.2.130. V$SSVR_IORM_DB_PLAN
4.2.131. V$SSVR_IOSTAT
4.2.132. V$SSVR_MEMSTAT
4.2.133. V$SSVR_SLAB_STAT
4.2.134. V$SSVR_STORAGE_DISK
4.2.135. V$STANDBY
4.2.136. V$STANDBY_DEST
4.2.137. V$STANDBY_STATUS
4.2.138. V$STATNAME
4.2.139. V$SYSSTAT
4.2.140. V$SYSSTAT_VALUE
4.2.141. V$SYSTEM_EVENT
4.2.142. V$SYSTEM_PARAMETERS
4.2.143. V$SYS_TIME_MODEL
4.2.144. V$TABLESPACE
4.2.145. V$TACSTAT
4.2.146. V$TEMPFILE
4.2.147. V$TEMPSEG_OP_USAGE
4.2.148. V$TEMPSEG_USAGE
4.2.149. V$TEMPSTAT
4.2.150. V$THR_ACT_INFO
4.2.151. V$THR_EVENT
4.2.152. V$TIMER
4.2.153. V$TIMEZONE_NAMES
4.2.154. V$TRANSACTION
4.2.155. V$TSN_TIME
4.2.156. V$UNDOSTAT
4.2.157. V$UNDO_FREE_SPACE
4.2.158. V$USGMT_TXENTRY
4.2.159. V$VERSION
4.2.160. V$WAITER_SESSION
4.2.161. V$WAITSTAT
4.2.162. V$WAITUSE_STAT
4.2.163. V$WAITUSE_THR_STAT
A. Example of Initialization Parameters
Index