제3장 Static View
이전   다음

제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_SUBPARTITIONS
3.2.23. ALL_INDEXES
3.2.24. ALL_IND_COLUMNS
3.2.25. ALL_IND_EXPRESSIONS
3.2.26. ALL_IND_SUBPARTITIONS
3.2.27. ALL_JAVA_ARGUMENTS
3.2.28. ALL_JAVA_CLASSES
3.2.29. ALL_JAVA_FIELDS
3.2.30. ALL_JAVA_METHODS
3.2.31. ALL_JOBS
3.2.32. ALL_JOBS_WITH_NAME
3.2.33. ALL_LIBRARIES
3.2.34. ALL_LOBS
3.2.35. ALL_LOB_PARTITIONS
3.2.36. ALL_LOB_SUBPARTITIONS
3.2.37. ALL_LOG_GROUPS
3.2.38. ALL_LOG_GROUP_COLUMNS
3.2.39. ALL_METHOD_PARAMS
3.2.40. ALL_METHOD_RESULTS
3.2.41. ALL_MVIEWS
3.2.42. ALL_MVIEW_COMMENTS
3.2.43. ALL_MVIEW_DETAIL_RELATIONS
3.2.44. ALL_MVIEW_LOGS
3.2.45. ALL_MVIEW_REFRESH_TIMES
3.2.46. ALL_OBJECTS
3.2.47. ALL_PACKAGE_COLL_TYPES
3.2.48. ALL_PACKAGE_MEMBER_TYPES
3.2.49. ALL_PACKAGE_TYPES
3.2.50. ALL_PART_INDEXES
3.2.51. ALL_PART_KEY_COLUMNS
3.2.52. ALL_PART_LOBS
3.2.53. ALL_PART_TABLES
3.2.54. ALL_PROCEDURES
3.2.55. ALL_QUEUES
3.2.56. ALL_QUEUE_SUBSCRIBERS
3.2.57. ALL_QUEUE_TABLES
3.2.58. ALL_RECYCLEBIN
3.2.59. ALL_SCHEDULER_CHAINS
3.2.60. ALL_SCHEDULER_JOBS
3.2.61. ALL_SCHEDULER_JOB_LOG
3.2.62. ALL_SCHEDULER_JOB_RUN_DETAILS
3.2.63. ALL_SCHEDULER_PROGRAMS
3.2.64. ALL_SCHEDULER_RULES
3.2.65. ALL_SCHEDULER_RULE_CTX
3.2.66. ALL_SCHEDULER_RUNNING_JOBS
3.2.67. ALL_SCHEDULER_SCHEDULES
3.2.68. ALL_SCHEDULER_STEPS
3.2.69. ALL_SCHEDULER_STEP_CTX
3.2.70. ALL_SEGMENTS
3.2.71. ALL_SEQUENCES
3.2.72. ALL_SOURCE
3.2.73. ALL_SUBPART_KEY_COLUMNS
3.2.74. ALL_SYNONYMS
3.2.75. ALL_TABLES
3.2.76. ALL_TAB_COLS
3.2.77. ALL_TAB_COLUMNS
3.2.78. ALL_TAB_COL_STATISTICS
3.2.79. ALL_TAB_COMMENTS
3.2.80. ALL_TAB_HISTOGRAMS
3.2.81. ALL_TAB_IDENTITY_COLS
3.2.82. ALL_TAB_PARTITIONS
3.2.83. ALL_TAB_PRIVS
3.2.84. ALL_TAB_PRIVS_MADE
3.2.85. ALL_TAB_PRIVS_RECD
3.2.86. ALL_TAB_SUBPARTITIONS
3.2.87. ALL_TBL_COLS
3.2.88. ALL_TBL_COLUMNS
3.2.89. ALL_TBL_COLUMNS_WITH_DNO
3.2.90. ALL_TBL_COL_STATISTICS
3.2.91. ALL_TBL_COMMENTS
3.2.92. ALL_TBL_HISTOGRAMS
3.2.93. ALL_TBL_PARTITIONS
3.2.94. ALL_TBL_PRIVS
3.2.95. ALL_TBL_PRIVS_MADE
3.2.96. ALL_TBL_PRIVS_RECD
3.2.97. ALL_TBL_SUBPARTITIONS
3.2.98. ALL_TRIGGERS
3.2.99. ALL_TRIGGER_COLS
3.2.100. ALL_TYPES
3.2.101. ALL_TYPE_ATTRS
3.2.102. ALL_TYPE_METHODS
3.2.103. ALL_UPDATABLE_COLUMNS
3.2.104. ALL_USERS
3.2.105. ALL_VIEWS
3.2.106. ALL_VIEWS_INTERNAL
3.2.107. CTX_PREFERENCES
3.2.108. CTX_PREFERENCE_VALUES
3.2.109. DATABASE_PROPERTIES
3.2.110. DBA_2PC_NEIGHBORS
3.2.111. DBA_2PC_PENDING
3.2.112. DBA_AUDIT_POLICIES
3.2.113. DBA_AUDIT_TRAIL
3.2.114. DBA_CATALOG
3.2.115. DBA_COLL_TYPES
3.2.116. DBA_COL_COMMENTS
3.2.117. DBA_COL_PRIVS
3.2.118. DBA_CONSTRAINTS
3.2.119. DBA_CONS_COLUMNS
3.2.120. DBA_DATAFILES
3.2.121. DBA_DATA_FILES
3.2.122. DBA_DB_LINKS
3.2.123. DBA_DDL_LOCKS
3.2.124. DBA_DEPENDENCIES
3.2.125. DBA_DIRECTORIES
3.2.126. DBA_DML_LOCKS
3.2.127. DBA_ENCRYPTED_COLUMNS
3.2.128. DBA_ERRORS
3.2.129. DBA_EXTENTS
3.2.130. DBA_EXTERNAL_LOCATIONS
3.2.131. DBA_EXTERNAL_TABLES
3.2.132. DBA_FGA_AUDIT_TRAIL
3.2.133. DBA_FREE_SPACE
3.2.134. DBA_HIST_ACTIVE_SESS_HISTORY
3.2.135. DBA_HIST_FILESTAT
3.2.136. DBA_HIST_LATCH
3.2.137. DBA_HIST_LIBRARYCACHE
3.2.138. DBA_HIST_OSSTAT
3.2.139. DBA_HIST_PGASTAT
3.2.140. DBA_HIST_PROCESS_MEM_SUMMARY
3.2.141. DBA_HIST_SEG_STAT
3.2.142. DBA_HIST_SGASTAT
3.2.143. DBA_HIST_SNAPSHOT
3.2.144. DBA_HIST_SQLBIND
3.2.145. DBA_HIST_SQLSTAT
3.2.146. DBA_HIST_SQLTEXT
3.2.147. DBA_HIST_SQL_PLAN
3.2.148. DBA_HIST_SQL_WORKAREA_HSTGRM
3.2.149. DBA_HIST_SYSMETRIC_SUMMARY
3.2.150. DBA_HIST_SYSTEM_EVENT
3.2.151. DBA_HIST_UNDOSTAT
3.2.152. DBA_HIST_WAITSTAT
3.2.153. DBA_IDX_COLUMNS
3.2.154. DBA_IDX_EXPRESSIONS
3.2.155. DBA_IDX_SUBPARTITIONS
3.2.156. DBA_INDEXES
3.2.157. DBA_IND_COLUMNS
3.2.158. DBA_IND_EXPRESSIONS
3.2.159. DBA_IND_SUBPARTITIONS
3.2.160. DBA_JAVA_ARGUMENTS
3.2.161. DBA_JAVA_CLASSES
3.2.162. DBA_JAVA_FIELDS
3.2.163. DBA_JAVA_METHODS
3.2.164. DBA_JOBS
3.2.165. DBA_JOBS_WITH_NAME
3.2.166. DBA_LIBRARIES
3.2.167. DBA_LOBS
3.2.168. DBA_LOB_PARTITIONS
3.2.169. DBA_LOB_SUBPARTITIONS
3.2.170. DBA_LOG_GROUPS
3.2.171. DBA_LOG_GROUP_COLUMNS
3.2.172. DBA_METHOD_PARAMS
3.2.173. DBA_METHOD_RESULTS
3.2.174. DBA_MVIEWS
3.2.175. DBA_MVIEW_COMMENTS
3.2.176. DBA_MVIEW_DETAIL_RELATIONS
3.2.177. DBA_MVIEW_LOGS
3.2.178. DBA_MVIEW_REFRESH_TIMES
3.2.179. DBA_OBJECTS
3.2.180. DBA_OBJ_AUDIT_OPTS
3.2.181. DBA_PACKAGE_COLL_TYPES
3.2.182. DBA_PACKAGE_MEMBER_TYPES
3.2.183. DBA_PACKAGE_TYPES
3.2.184. DBA_PART_INDEXES
3.2.185. DBA_PART_KEY_COLUMNS
3.2.186. DBA_PART_LOBS
3.2.187. DBA_PART_TABLES
3.2.188. DBA_PRIV_AUDIT_OPTS
3.2.189. DBA_PROCEDURES
3.2.190. DBA_PROFILES
3.2.191. DBA_QUEUES
3.2.192. DBA_QUEUE_SUBSCRIBERS
3.2.193. DBA_QUEUE_TABLES
3.2.194. DBA_RECYCLEBIN
3.2.195. DBA_REDEFINITION_OBJECTS
3.2.196. DBA_ROLES
3.2.197. DBA_ROLE_PRIVS
3.2.198. DBA_ROLLBACK_SEGS
3.2.199. DBA_SCHEDULER_CHAINS
3.2.200. DBA_SCHEDULER_JOBS
3.2.201. DBA_SCHEDULER_JOB_LOG
3.2.202. DBA_SCHEDULER_JOB_RUN_DETAILS
3.2.203. DBA_SCHEDULER_PROGRAMS
3.2.204. DBA_SCHEDULER_RULES
3.2.205. DBA_SCHEDULER_RULE_CTX
3.2.206. DBA_SCHEDULER_RUNNING_JOBS
3.2.207. DBA_SCHEDULER_SCHEDULES
3.2.208. DBA_SCHEDULER_STEPS
3.2.209. DBA_SCHEDULER_STEP_CTX
3.2.210. DBA_SEGMENTS
3.2.211. DBA_SEQUENCES
3.2.212. DBA_SOURCE
3.2.213. DBA_SQL_PLAN_BASELINES
3.2.214. DBA_SQL_PROFILES
3.2.215. DBA_SUBPART_KEY_COLUMNS
3.2.216. DBA_SYNONYMS
3.2.217. DBA_SYS_PRIVS
3.2.218. DBA_TABLES
3.2.219. DBA_TABLESPACES
3.2.220. DBA_TAB_COLS
3.2.221. DBA_TAB_COLUMNS
3.2.222. DBA_TAB_COL_STATISTICS
3.2.223. DBA_TAB_COMMENTS
3.2.224. DBA_TAB_HISTOGRAMS
3.2.225. DBA_TAB_IDENTITY_COLS
3.2.226. DBA_TAB_PARTITIONS
3.2.227. DBA_TAB_PRIVS
3.2.228. DBA_TAB_SUBPARTITIONS
3.2.229. DBA_TBL_COLS
3.2.230. DBA_TBL_COLUMNS
3.2.231. DBA_TBL_COL_STATISTICS
3.2.232. DBA_TBL_COMMENTS
3.2.233. DBA_TBL_HISTOGRAMS
3.2.234. DBA_TBL_PARTITIONS
3.2.235. DBA_TBL_PRIVS
3.2.236. DBA_TBL_SUBPARTITIONS
3.2.237. DBA_TEMPFILES
3.2.238. DBA_TEMP_FILES
3.2.239. DBA_TRIGGERS
3.2.240. DBA_TRIGGER_COLS
3.2.241. DBA_TS_QUOTAS
3.2.242. DBA_TYPES
3.2.243. DBA_TYPE_ATTRS
3.2.244. DBA_TYPE_METHODS
3.2.245. DBA_UNDO_EXTENTS
3.2.246. DBA_UNDO_SGMTS
3.2.247. DBA_UPDATABLE_COLUMNS
3.2.248. DBA_USERS
3.2.249. DBA_VIEWS
3.2.250. DBMSHSXP_SQL_PROFILE_ATTR
3.2.251. DICTIONARY
3.2.252. NLS_DATABASE_PARAMETERS
3.2.253. NLS_SESSION_PARAMETERS
3.2.254. PUBLICSYN
3.2.255. ROLE_ROLE_PRIVS
3.2.256. ROLE_SYS_PRIVS
3.2.257. ROLE_TAB_PRIVS
3.2.258. SESSION_CONTEXT
3.2.259. SESSION_PRIVS
3.2.260. SESSION_ROLES
3.2.261. SYS_OBJECTS
3.2.262. USER_ARGUMENTS
3.2.263. USER_AUDIT_TRAIL
3.2.264. USER_CATALOG
3.2.265. USER_COLL_TYPES
3.2.266. USER_COL_COMMENTS
3.2.267. USER_COL_PRIVS
3.2.268. USER_COL_PRIVS_MADE
3.2.269. USER_COL_PRIVS_RECD
3.2.270. USER_CONSTRAINTS
3.2.271. USER_CONS_COLUMNS
3.2.272. USER_DB_LINKS
3.2.273. USER_DEPENDENCIES
3.2.274. USER_ENCRYPTED_COLUMNS
3.2.275. USER_ERRORS
3.2.276. USER_EXTENTS
3.2.277. USER_EXTERNAL_LOCATIONS
3.2.278. USER_EXTERNAL_TABLES
3.2.279. USER_FREE_SPACE
3.2.280. USER_IDX_COLUMNS
3.2.281. USER_IDX_EXPRESSIONS
3.2.282. USER_INDEXES
3.2.283. USER_IND_COLUMNS
3.2.284. USER_IND_EXPRESSIONS
3.2.285. USER_JAVA_ARGUMENTS
3.2.286. USER_JAVA_CLASSES
3.2.287. USER_JAVA_FIELDS
3.2.288. USER_JAVA_METHODS
3.2.289. USER_JOBS
3.2.290. USER_JOBS_WITH_NAME
3.2.291. USER_LIBRARIES
3.2.292. USER_LOBS
3.2.293. USER_LOB_PARTITIONS
3.2.294. USER_LOB_SUBPARTITIONS
3.2.295. USER_LOG_GROUPS
3.2.296. USER_LOG_GROUP_COLUMNS
3.2.297. USER_METHOD_PARAMS
3.2.298. USER_METHOD_RESULTS
3.2.299. USER_MVIEWS
3.2.300. USER_MVIEW_COMMENTS
3.2.301. USER_MVIEW_LOGS
3.2.302. USER_MVIEW_REFRESH_TIMES
3.2.303. USER_OBJECTS
3.2.304. USER_OBJ_AUDIT_OPTS
3.2.305. USER_PACKAGE_COLL_TYPES
3.2.306. USER_PACKAGE_MEMBER_TYPES
3.2.307. USER_PACKAGE_TYPES
3.2.308. USER_PART_INDEXES
3.2.309. USER_PART_KEY_COLUMNS
3.2.310. USER_PART_LOBS
3.2.311. USER_PART_TABLES
3.2.312. USER_PROCEDURES
3.2.313. USER_QUEUES
3.2.314. USER_QUEUE_SUBSCRIBERS
3.2.315. USER_QUEUE_TABLES
3.2.316. USER_RECYCLEBIN
3.2.317. USER_ROLE_PRIVS
3.2.318. USER_SCHEDULER_CHAINS
3.2.319. USER_SCHEDULER_JOBS
3.2.320. USER_SCHEDULER_JOB_LOG
3.2.321. USER_SCHEDULER_JOB_RUN_DETAILS
3.2.322. USER_SCHEDULER_PROGRAMS
3.2.323. USER_SCHEDULER_RULES
3.2.324. USER_SCHEDULER_RULE_CTX
3.2.325. USER_SCHEDULER_RUNNING_JOBS
3.2.326. USER_SCHEDULER_SCHEDULES
3.2.327. USER_SCHEDULER_STEPS
3.2.328. USER_SCHEDULER_STEP_CTX
3.2.329. USER_SEGMENTS
3.2.330. USER_SEQUENCES
3.2.331. USER_SOURCE
3.2.332. USER_SUBPART_KEY_COLUMNS
3.2.333. USER_SYNONYMS
3.2.334. USER_SYS_PRIVS
3.2.335. USER_TABLES
3.2.336. USER_TABLESPACES
3.2.337. USER_TAB_COLS
3.2.338. USER_TAB_COLUMNS
3.2.339. USER_TAB_COL_STATISTICS
3.2.340. USER_TAB_COMMENTS
3.2.341. USER_TAB_HISTOGRAMS
3.2.342. USER_TAB_IDENTITY_COLS
3.2.343. USER_TAB_PARTITIONS
3.2.344. USER_TAB_PRIVS
3.2.345. USER_TAB_PRIVS_MADE
3.2.346. USER_TAB_PRIVS_RECD
3.2.347. USER_TBL_COLS
3.2.348. USER_TBL_COLUMNS
3.2.349. USER_TBL_COL_STATISTICS
3.2.350. USER_TBL_COMMENTS
3.2.351. USER_TBL_HISTOGRAMS
3.2.352. USER_TBL_PARTITIONS
3.2.353. USER_TBL_PRIVS
3.2.354. USER_TBL_PRIVS_MADE
3.2.355. USER_TBL_PRIVS_RECD
3.2.356. USER_TRIGGERS
3.2.357. USER_TRIGGER_COLS
3.2.358. USER_TYPES
3.2.359. USER_TYPE_ATTRS
3.2.360. USER_TYPE_METHODS
3.2.361. USER_UPDATABLE_COLUMNS
3.2.362. USER_USERS
3.2.363. USER_VIEWS
3.2.364. all_dba_subpartition_templates
3.2.365. all_idx_partitions
3.2.366. all_ind_partitions
3.2.367. dba_idx_partitions
3.2.368. dba_ind_partitions
3.2.369. dba_subpartition_templates
3.2.370. user_idx_partitions
3.2.371. user_ind_partitions

3.1. Overview

The static view comprises of one or more base tables and static and dynamic views. Thus, the static view is generated from a join of static and dynamic views.

Tibero uses DICTIONARY to display the list of available static views. DBA or general users can retrieve data from the static view by executing a SELECT statement using the tbSQL tool.

3.2. List of Static Views

This section provides the list of static views of Tibero in alphabetical order and describes the columns which corresponds to each static view in the table.

참고

The static view of Tibero is comprised of a set of views named with a different prefix but having the same column. In this guide, the same column used for several views will be discussed only once in the list, in the first explained view.

The following is the list of summarized static views.

Static ViewDescription
ALL_ARGUMENTSDisplays all parameters of the procedure or function that the current user can call.
ALL_CATALOGDisplays all tables, views, synonyms, and sequences that the current user can access.
ALL_COLL_TYPESDisplays all the collection types that the current user can access.
ALL_COL_COMMENTSDisplays comments on columns of the tables or views that the current user can access.
ALL_COL_PRIVSDisplays columns for which the current user or public user is the object owner or grantor (user who granted the privilege).
ALL_COL_PRIVS_MADEDisplays columns for which the current user is the object owner or grantor.
ALL_COL_PRIVS_RECDDisplays columns for which the current user or public user is the grantee.
ALL_CONSTRAINTSDisplays constraints defined in the table that the current user can access.
ALL_CONS_COLUMNSDisplays columns that the current user can access and that are specified in integrity constraint definitions.
ALL_CONS_COLUMNS_INFODisplays columns with constraint information that the current user can access and that are specified in integrity constraint definitions.
ALL_DB_LINKSDisplays information for the database links that the current user can use.
ALL_DEPENDENCIESDisplays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user can access.
ALL_DIRECTORIESDisplays all directories that the current user can access.
ALL_ENCRYPTED_COLUMNSDisplays information of all encrypted columns that the current user can access.
ALL_ERRORSDisplays the recent errors on every accessible view, procedure, function, package, package body, trigger, library, and java object.
ALL_EXTERNAL_LOCATIONSDisplays all external table locations that the current user can access.
ALL_EXTERNAL_TABLESDisplays all external tables that the current user can access.
ALL_IDX_AND_LOB_COLUMNS_INFODisplays index columns (including LOB) with index information of all tables that the current user can access
ALL_IDX_COLUMNSDisplays index columns of all tables that the current user can access.
ALL_IDX_COLUMNS_INFODisplays index columns with index information of all tables that the current user can access.
ALL_IDX_EXPRESSIONSDisplays expressions on function-based index columns of all tables that the current user can access.
ALL_IDX_SUBPARTITIONSDisplays subpartitions of the index that the current user can access.
ALL_INDEXESDisplays indexes of all tables that the current user can access.
ALL_IND_COLUMNSSynonym for ALL_IDX_COLUMNS.
ALL_IND_EXPRESSIONSSynonym for ALL_IDX_EXPRESSIONS.
ALL_IND_SUBPARTITIONSSynonym for ALL_IDX_SUBPARTITIONS.
ALL_JAVA_ARGUMENTSDisplays all parameters that the current user can access.
ALL_JAVA_CLASSESDisplays all classes that the current user can access.
ALL_JAVA_FIELDSDisplays all fields that the current user can access.
ALL_JAVA_METHODSDisplays all methods that the current user can access.
ALL_JOBSDisplays all jobs that the current user can access.
ALL_JOBS_WITH_NAMEDisplays all jobs with job name that the current user can access.
ALL_LIBRARIESDisplays all libraries that the current user can access.
ALL_LOBSDisplays large objects (LOB) which belong to all tables that the current user can access.
ALL_LOB_PARTITIONSDisplays all LOB partitions that the current user can access.
ALL_LOB_SUBPARTITIONSDisplays LOB subpartitions that the current user can access.
ALL_LOG_GROUPSDisplays the log group definitions on the tables accessible to the current user.
ALL_LOG_GROUP_COLUMNSDisplays columns that are accessible to the current user and that are specified in log groups.
ALL_METHOD_PARAMSDisplays all the method parameters of the type that the current user can access.
ALL_METHOD_RESULTSDisplays the result of the method of this type that the current user can access.
ALL_MVIEWSDisplays all materialized views that the current user can access.
ALL_MVIEW_COMMENTSDisplays comments on the materialized views that the current user can access.
ALL_MVIEW_DETAIL_RELATIONSdescribes all such detail relations defined for all materialized views in the database.
ALL_MVIEW_LOGSDisplays all materialized view logs that the current user can access.
ALL_MVIEW_REFRESH_TIMESDescribes refresh times of all materialized views accessible to the current user.
ALL_OBJECTSDisplays all objects that the current user can access.
ALL_PACKAGE_COLL_TYPESDisplays collection types of the package that the current user can access,
ALL_PACKAGE_MEMBER_TYPESDisplays attributes of the package type that the current user can access.
ALL_PACKAGE_TYPESDisplays member types of the package that the current user can access
ALL_PART_INDEXESDisplays partition information for the partitioned indexes that the current user can access.
ALL_PART_KEY_COLUMNSDisplays partitioning key columns of the partitioned tables or indexes that the current user can access.
ALL_PART_LOBSDisplays LOBs which belong to all partitioned tables that the current user can access.
ALL_PART_TABLESDisplays partitioning information of all partitioned tables that the current user can access.
ALL_PROCEDURESDisplays all procedures defined in all procedures and tables that the current user owns.
ALL_QUEUESDescribes all queues on which the current user has enqueue or dequeue privileges.
ALL_QUEUE_SUBSCRIBERSShows the list of subscribers that the current user has privilege to dequeue from.
ALL_QUEUE_TABLESDescribes the queues in the queue tables accessible to the current user.
ALL_RECYCLEBINDisplays information of all temporarily deleted objects that the current user can access.
ALL_SCHEDULER_CHAINSDisplays all scheduler chains that the current user can access.
ALL_SCHEDULER_JOBSDisplays all scheduler jobs that the current user can access.
ALL_SCHEDULER_JOB_LOGDisplays all scheduler job log that the current user can access.
ALL_SCHEDULER_JOB_RUN_DETAILSDisplays all scheduler job run details that the current user can access.
ALL_SCHEDULER_PROGRAMSDisplays all scheduler programs that the current user can access.
ALL_SCHEDULER_RULESDisplays all scheduler rules that the current user can access.
ALL_SCHEDULER_RULE_CTXDisplays all scheduler rule ctx that the current user can access.
ALL_SCHEDULER_RUNNING_JOBSDisplays all scheduler running jobs that the current user can access.
ALL_SCHEDULER_SCHEDULESDisplays all scheduler schedules that the current user can access.
ALL_SCHEDULER_STEPSDisplays all scheduler steps that the current user can access.
ALL_SCHEDULER_STEP_CTXDisplays all scheduler step context the current user can access.
ALL_SEGMENTSDisplays all segments that the current user can access.
ALL_SEQUENCESDisplays all sequences that the current user can access.
ALL_SOURCEDisplays source texts of the stored objects that the current user can access such as procedures, functions, package bodies, or triggers.
ALL_SUBPART_KEY_COLUMNSDisplays subpartitioning key columns of the partitioned tables or indexes that the current user can access.
ALL_SYNONYMSDisplays all synonyms that the current user can access.
ALL_TABLESDisplays all tables that the current user can access.
ALL_TAB_COLSSynonym for ALL_TBL_COLS.
ALL_TAB_COLUMNSSynonym for ALL_TBL_COLUMNS.
ALL_TAB_COL_STATISTICSSynonym for ALL_TBL_COL_STATISTICS.
ALL_TAB_COMMENTSDisplays comments on the tables that the current user can access.
ALL_TAB_HISTOGRAMSSynonym for ALL_TBL_HISTOGRAMS.
ALL_TAB_IDENTITY_COLSDisplays identity columns of all tables that the current user can access.
ALL_TAB_PARTITIONSSynonym for ALL_TBL_PARTITIONS.
ALL_TAB_PRIVSSynonym for ALL_TBL_PRIVS.
ALL_TAB_PRIVS_MADESynonym for ALL_TBL_PRIVS_MADE.
ALL_TAB_PRIVS_RECDSynonym for ALL_TBL_PRIVS_RECD.
ALL_TAB_SUBPARTITIONSSynonym for ALL_TBL_SUBPARTITIONS.
ALL_TBL_COLSDisplays column information of all tables and views that the current user can access.
ALL_TBL_COLUMNSDisplays column information of all tables and views that the current user can access.
ALL_TBL_COLUMNS_WITH_DNODisplays column information of all tables and views, which the current user can access, with data type number of the column.
ALL_TBL_COL_STATISTICSDisplays statistics and a histogram of columns by extracting them from ALL_TBL_COLUMNS.
ALL_TBL_COMMENTSSynonym for ALL_TAB_COMMENTS.
ALL_TBL_HISTOGRAMSDisplays histogram information of tables that the current user can access.
ALL_TBL_PARTITIONSDisplays partition information of all tables that the current user can access.
ALL_TBL_PRIVSDisplays tables for which the current user or public user is granted object privileges.
ALL_TBL_PRIVS_MADEDisplays object privileges granted on tables for which the current user or public user is the object owner or grantor.
ALL_TBL_PRIVS_RECDDisplays object privileges granted on tables for which the current user or public user is the object grantee.
ALL_TBL_SUBPARTITIONSDisplays subpartitions of all tables that the current user can access.
ALL_TRIGGERSDisplays all triggers that the current user can access.
ALL_TRIGGER_COLSDisplays column information of all triggers that the current user can access and all triggers on tables that the current user can access.
ALL_TYPESDisplays all types that the current user can access.
ALL_TYPE_ATTRSDisplays all the attributes that the current user can access.
ALL_TYPE_METHODSDisplays all the methods of this type that the current user can access.
ALL_UPDATABLE_COLUMNSDisplays all join view columns that the current user can update.
ALL_USERSDisplays all users that the current user can view.
ALL_VIEWSDisplays all views that the current user can access.
ALL_VIEWS_INTERNALDisplays all views that the current user can access. (including views that can be accessed by the roles)
CTX_PREFERENCESDisplays preferences created by Tibero users, as well as all the system-defined preferences.
CTX_PREFERENCE_VALUESDisplays the values assigned to all the preferences in the Text data dictionary.
DATABASE_PROPERTIESDisplays database properties.
DBA_2PC_NEIGHBORSDisplays connection information for pending transactions.
DBA_2PC_PENDINGDisplays pending transaction information.
DBA_AUDIT_POLICIESDisplays all fine-grained auditing policies in the database.
DBA_AUDIT_TRAILDisplays audit trails within the database.
DBA_CATALOGDisplays all tables, views, synonyms, and sequences in the database.
DBA_COLL_TYPESDisplays all the collection types.
DBA_COL_COMMENTSDisplays comments on all columns in the database.
DBA_COL_PRIVSDisplays object privileges of all columns of the database.
DBA_CONSTRAINTSDisplays integrity constraints defined in the database table.
DBA_CONS_COLUMNSDisplays the columns for which the database integrity constraint is specified.
DBA_DATAFILESSynonym for DBA_DATA_FILES.
DBA_DATA_FILESDisplays data file information.
DBA_DB_LINKSDisplays information for all database links.
DBA_DDL_LOCKSdisplays information about DDL locks.
DBA_DEPENDENCIESDisplays dependencies of all objects.
DBA_DIRECTORIESDisplays all directories in the database.
DBA_DML_LOCKSdisplays information about DML locks.
DBA_ENCRYPTED_COLUMNSDisplays information of all encrypted columns in the database. The columns are the same as those in ALL_ENCRYPTED_COLUMNS.
DBA_ERRORSDisplays the recent errors on every view, procedure, function, package, package body, trigger, library, and java object in the database. The columns are the same as those in ALL_ERRORS.
DBA_EXTENTSDisplays information of the extents contained in the segments of all the tablespaces in the database.
DBA_EXTERNAL_LOCATIONSDisplays all external table locations in the database.
DBA_EXTERNAL_TABLESDisplays all external tables in the database.
DBA_FGA_AUDIT_TRAILDiplays TODO. TODO
DBA_FREE_SPACEDisplays information of the extents that all tablespaces can use.
DBA_HIST_ACTIVE_SESS_HISTORYDisplays history information on active sessions.
DBA_HIST_FILESTATDisplays historical statistics of data file and temp file I/O. This view includes snapshots of V$ALL_FILESTAT.
DBA_HIST_LATCHDisplays the historical information on spinlocks. This view includes snapshots of V$LATCH.
DBA_HIST_LIBRARYCACHEDisplays information of PP cache and DD cache. This view includes snapshots of V$LIBRARYCACHE.
DBA_HIST_OSSTATDisplays historical information on various OS statistics. This view includes snapshots of V$OSSTAT2.
DBA_HIST_PGASTATDisplays the historical statistics of PGA. This view includes the snapshot of V$PGASTAT.
DBA_HIST_PROCESS_MEM_SUMMARYDisplays historical information on PGA memory usage. This view gets information from V$PROCESS.
DBA_HIST_SEG_STATDisplays historical information of segment-level statistics. This view includes snapshots of V$SEGMENT_STATISTICS.
DBA_HIST_SGASTATDisplays the historical information on the shared pool for a database. This view includes snapshots of V$SGASTAT.
DBA_HIST_SNAPSHOTDisplays information about TPR snapshots.
DBA_HIST_SQLBINDDisplays DBA_HIST_SQLBIND displays historical information on bind variables used by SQL cursors. This view contains snapshots of V$SQL_BIND_CAPTURE.
DBA_HIST_SQLSTATDisplays historical information for SQL statistics. This view displays the priority of items of specific criteria.
DBA_HIST_SQLTEXTDisplays historical information about texts of SQL statements.
DBA_HIST_SQL_PLANDisplays historical information about SQL execution plans. This view includes snapshots of V$SQL_PLAN.
DBA_HIST_SQL_WORKAREA_HSTGRMDisplays historical information about work areas used by SQl cursors. This view includes snapshots of V$SQL_WORKAREA_HISTOGRAM.
DBA_HIST_SYSMETRIC_SUMMARYDisplays a history of statistical summary of all metric values in the System Metrics Long Duration group.
DBA_HIST_SYSTEM_EVENTDisplays historical information of events performing in the system. This view includes snapshots of V$SYSTEM_EVENT.
DBA_HIST_UNDOSTATDisplays historical statistics of undo storage space. This view includes snapshots of V$UNDOSTAT.
DBA_HIST_WAITSTATDisplays the statistical history of block wait events for each block type and class. This view includes snapshots of V$WAITSTAT.
DBA_IDX_COLUMNSDisplays index columns of all tables in the database.
DBA_IDX_EXPRESSIONSDisplays expressions on the index columns of all tables in the database.
DBA_IDX_SUBPARTITIONSDisplays subpartitions of all indexes in the database.
DBA_INDEXESDisplays indexes of all tables in the database.
DBA_IND_COLUMNSSynonym for DBA_IDX_COLUMNS.
DBA_IND_EXPRESSIONSSynonym for DBA_IDX_EXPRESSIONS.
DBA_IND_SUBPARTITIONSSynonym for DBA_IDX_SUBPARTITIONS.
DBA_JAVA_ARGUMENTSDisplays all parameters in the database.
DBA_JAVA_CLASSESDisplays all classes in the database.
DBA_JAVA_FIELDSDisplays all fields in the database.
DBA_JAVA_METHODSDisplays all methods in the database.
DBA_JOBSDisplays all jobs in the database.
DBA_JOBS_WITH_NAMEDisplays all jobs with job name in the database.
DBA_LIBRARIESDisplays all libraries in the database.
DBA_LOBSDisplays LOBs which belong to all tables in the database.
DBA_LOB_PARTITIONSDisplays all LOB partitions in the database.
DBA_LOB_SUBPARTITIONSDisplays all LOB subpartitions in the database.
DBA_LOG_GROUPSDisplays the log group definitions on all tables in the database.
DBA_LOG_GROUP_COLUMNSDisplays all columns in the database that are specified in log groups.
DBA_METHOD_PARAMSDisplays the method parameters of this type.
DBA_METHOD_RESULTSDisplays the result of the method of this type.
DBA_MVIEWSDisplays all materialized views in the database. The columns are the same as those in ALL_MVIEWS.
DBA_MVIEW_COMMENTSDisplays comments on all materialized views in the database. The columns are the same as those in ALL_MVIEW_COMMENTS.
DBA_MVIEW_DETAIL_RELATIONSDescribes the named detail relations that are either specified in the FROM list of the subquery that defines all materialized views in the database, or that are indirectly referenced through views in that FROM list. Inline views in the materialized view definition are not represented in this view or the related views.
DBA_MVIEW_LOGSDisplays all materialized view logs in the database. The columns are the same as those in ALL_MVIEW_LOGS.
DBA_MVIEW_REFRESH_TIMESDescribes refresh times of all materialized views in the database.
DBA_OBJECTSDisplays all objects in the database.
DBA_OBJ_AUDIT_OPTSDisplays objects being audited in the database.
DBA_PACKAGE_COLL_TYPESDisplays types of the package.
DBA_PACKAGE_MEMBER_TYPESDisplays types of the package.
DBA_PACKAGE_TYPESDisplays types of the package.
DBA_PART_INDEXESDisplays partitioning information for the partitioned indexes in the database.
DBA_PART_KEY_COLUMNSDisplays partitioning key columns for all partitioned tables or indexes in the database.
DBA_PART_LOBSDisplays LOBs which belong to the partitioned tables in the database.
DBA_PART_TABLESDisplays partitioning information of the partitioned tables in the database.
DBA_PRIV_AUDIT_OPTSDisplays users being audited in the database.
DBA_PROCEDURESDisplays all procedures in the database.
DBA_PROFILESDescribes all profiles in the database.
DBA_QUEUESDescribes all queues in the database.
DBA_QUEUE_SUBSCRIBERSShows the list of subscribers on all queues in the database.
DBA_QUEUE_TABLESDescribes the queues in all queue tables in the database.
DBA_RECYCLEBINDisplays information of all temporarily deleted objects in the database. The columns are the same as those in ALL_RECYCLEBIN.
DBA_REDEFINITION_OBJECTSDisplays all objects in database which are being redefined online.
DBA_ROLESDisplays all roles in the database.
DBA_ROLE_PRIVSDisplays roles granted to the users in the database.
DBA_ROLLBACK_SEGSSynonym for DBA_UNDO_SGMTS.
DBA_SCHEDULER_CHAINSDisplays all scheduler chains in the database.
DBA_SCHEDULER_JOBSDisplays all scheduler jobs in the database.
Static ViewDescription
DBA_SCHEDULER_JOB_LOGDisplays all scheduler job log in the database.
DBA_SCHEDULER_JOB_RUN_DETAILSDisplays all scheduler job run details in the database.
DBA_SCHEDULER_PROGRAMSDisplays all scheduler programs in the database.
DBA_SCHEDULER_RULESDisplays all scheduler rules in the database.
DBA_SCHEDULER_RULE_CTXDisplays all scheduler rule ctx in the database.
DBA_SCHEDULER_RUNNING_JOBSDisplays all scheduler running jobs in the database.
DBA_SCHEDULER_SCHEDULESDisplays all scheduler schedules in the database.
DBA_SCHEDULER_STEPSDisplays all scheduler steps in the database.
DBA_SCHEDULER_STEP_CTXDisplays all scheduler step context in the database.
DBA_SEGMENTSDisplays all segments in the database.
DBA_SEQUENCESDisplays all sequences in the database.
DBA_SOURCEDisplays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.
DBA_SQL_PLAN_BASELINES!!! No documentation yet !!!
DBA_SQL_PROFILESdisplays information about SQL profiles currently created for specific SQL statements.
DBA_SUBPART_KEY_COLUMNSDisplays subpartitioning key columns of the partitioned tables or indexes in the database.
DBA_SYNONYMSDisplays synonyms in the database.
DBA_SYS_PRIVSDisplays system privileges granted to users and roles in the database.
DBA_TABLESDisplays all tables in the database.
DBA_TABLESPACESDisplays all tablespaces in the database.
DBA_TAB_COLSSynonym for DBA_TBL_COLS.
DBA_TAB_COLUMNSSynonym for DBA_TBL_COLUMNS.
DBA_TAB_COL_STATISTICSSynonym for DBA_TBL_COL_STATISTICS.
DBA_TAB_COMMENTSDisplays comments on all tables and views in the database.
DBA_TAB_HISTOGRAMSSynonym for DBA_TBL_HISTOGRAMS.
DBA_TAB_IDENTITY_COLSDisplays identity columns of all tables.
DBA_TAB_PARTITIONSSynonym for DBA_TBL_PARTITIONS.
DBA_TAB_PRIVSSynonym for DBA_TBL_PRIVS.
DBA_TAB_SUBPARTITIONSSynonym for DBA_TBL_SUBPARTITIONS.
DBA_TBL_COLSDisplays columns of all tables and views in the database.
DBA_TBL_COLUMNSDisplays columns of all tables and views in the database.
DBA_TBL_COL_STATISTICSDisplays statistics and a histogram of columns by extracting them from DBA_TBL_COLUMNS.
DBA_TBL_COMMENTSSynonym for DBA_TAB_COMMENTS.
DBA_TBL_HISTOGRAMSDisplays histogram information on tables and views in the database.
DBA_TBL_PARTITIONSDisplays partition information of all tables in the database.
DBA_TBL_PRIVSDisplays object privileges granted on all tables in the database.
DBA_TBL_SUBPARTITIONSDisplays subpartitions of all tables in the database.
DBA_TEMPFILESSynonym for DBA_TEMP_FILES.
DBA_TEMP_FILESDisplays information of the temporary data files.
DBA_TRIGGERSDisplays all triggers in the database.
DBA_TRIGGER_COLSDisplays column information of all triggers in the database. The columns are the same as those in ALL_TRIGGER_COLS.
DBA_TS_QUOTASDescribe tablespace quotas for all user
DBA_TYPESDisplays all types.
DBA_TYPE_ATTRSDisplays all the attributes of this type.
DBA_TYPE_METHODSDisplays all the methods of this type.
DBA_UNDO_EXTENTSDisplays information about the extents in all undo segments.
DBA_UNDO_SGMTSDisplays undo segments in the database.
DBA_UPDATABLE_COLUMNSDisplays all join view columns that the DBA can update.
DBA_USERSDisplays all users in the database.
DBA_VIEWSDisplays all views in the database.
DBMSHSXP_SQL_PROFILE_ATTRdisplays outline hints that sql profile defines.
DICTIONARYDisplays comments on tables and views in the data dictionary.
NLS_DATABASE_PARAMETERSDisplays NLS parameters of the current database.
NLS_SESSION_PARAMETERSDisplays NLS parameters of the current user session.
PUBLICSYNDisplays all public synonyms in the database.
ROLE_ROLE_PRIVSDisplays the roles granted to other roles which the current user can access.
ROLE_SYS_PRIVSDisplays system privileges granted to roles which the current user can access.
ROLE_TAB_PRIVSDisplays object privileges granted to roles which the current user can access.
SESSION_CONTEXTDisplays context attributes in the current session.
SESSION_PRIVSDisplays the system privileges granted to current session user.
SESSION_ROLESDisplays roles granted to the current session user.
SYS_OBJECTSDisplays IDs and types of all schema objects, and IDs of the segment header blocks in the database.
USER_ARGUMENTSDisplays all parameters of the procedure or function that the current user owns.
USER_AUDIT_TRAILDisplays audit trails associated with the current user.
USER_CATALOGDisplays all tables, views, synonyms, and sequences that the current user owns.
USER_COLL_TYPESDisplays all the collection types that the current user owns.
USER_COL_COMMENTSDisplays comments on all columns in the tables or views that the current user owns.
USER_COL_PRIVSDisplays object privileges of the columns for which the current user is the object owner, grantor, or grantee.
USER_COL_PRIVS_MADEDisplays columns for which the current user is the grantor.
USER_COL_PRIVS_RECDDisplays columns for which the current user is the grantee.
USER_CONSTRAINTSDisplays constraints defined in the table that the current user owns.
USER_CONS_COLUMNSDisplays columns that are owned by the current user and that are specified in integrity constraint definitions.
USER_DB_LINKSDisplays information for the database links that the current user owns.
USER_DEPENDENCIESDisplays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user owns.
USER_ENCRYPTED_COLUMNSDisplays information of all encrypted columns that the current user owns The columns are the same as those in ALL_ENCRYPTED_COLUMNS(except for OWNER)
USER_ERRORSDisplays the recent errors in every view, procedure, function, package, package body, trigger, library, and java object owned by current user. The columns are the same as those in ALL_ERRORS.(except for OWNER)
USER_EXTENTSDisplays information of the extents contained in the segments that the current user owns.
USER_EXTERNAL_LOCATIONSDisplays all external table locations that the current user owns.
USER_EXTERNAL_TABLESDisplays all external tables that the current user owns.
USER_FREE_SPACEDisplays information of the extents available for the tablespaces that the current user can access.
USER_IDX_COLUMNSDisplays index columns of all tables that the current user owns.
USER_IDX_EXPRESSIONSDisplays expressions on function-based index columns of all tables that the current user owns.
USER_INDEXESDisplays indexes of all tables that the current user owns.
USER_IND_COLUMNSSynonym for USER_IDX_COLUMNS.
USER_IND_EXPRESSIONSSynonym for USER_IDX_EXPRESSIONS.
USER_JAVA_ARGUMENTSDisplays all parameters that the current user owns.
USER_JAVA_CLASSESDisplays all classes that the current user owns.
USER_JAVA_FIELDSDisplays all fields that the current user owns.
USER_JAVA_METHODSDisplays all methods that the current user owns.
USER_JOBSDisplays all jobs that the current user owns.
USER_JOBS_WITH_NAMEDisplays all jobs with job name that the current user owns.
USER_LIBRARIESDisplays all libraries that the current user owns.
USER_LOBSDisplays large objects (LOB) which belong to all tables that the current user owns.
USER_LOB_PARTITIONSDisplays all LOB partitions which belong to all tables that the current user owns.
USER_LOB_SUBPARTITIONSDisplays all LOB subpartitions which belong to all tables that the current user owns.
USER_LOG_GROUPSDisplays the log group definitions on the tables owned by the current user.
USER_LOG_GROUP_COLUMNSDisplays columns that are owned by the current user and that are specified in log groups.
USER_METHOD_PARAMSDisplays the method parameters of the type that the current user owns.
USER_METHOD_RESULTSDisplays the result of the method of this type that the current user owns.
USER_MVIEWSDisplays all materialized views that the current user owns. The columns are the same as those in ALL_MVIEWS.
USER_MVIEW_COMMENTSDisplays comments on all materialized views that the current user owns.
USER_MVIEW_LOGSDisplays all materialized view logs that the current user owns The columns are the same as those in ALL_MVIEW_LOGS.
USER_MVIEW_REFRESH_TIMESDescribes refresh times of the materialized views owned by the current user.
USER_OBJECTSDisplays all objects that the current user owns.
USER_OBJ_AUDIT_OPTSDisplays the current user's own objects which are being audited.
USER_PACKAGE_COLL_TYPESDisplays types of the package that the current user owns.
USER_PACKAGE_MEMBER_TYPESDisplays types of the package that the current user owns.
USER_PACKAGE_TYPESDisplays types of the package that the current user owns.
USER_PART_INDEXESDisplays partitioning information for the partitioned indexes that the current user owns.
USER_PART_KEY_COLUMNSDisplays partitioning key columns for all partitioned tables or indexes that the current user owns.
USER_PART_LOBSDisplays LOBs which belong to the partitioned tables that the current user owns.
USER_PART_TABLESDisplays partitioning information of the partitioned tables that the current user owns.
USER_PROCEDURESDisplays all procedures that the current user owns.
USER_QUEUESDescribes the operational characteristics of every queue owned by the current user.
USER_QUEUE_SUBSCRIBERSShows the list of subscribers on queues that are under the current user's schema.
USER_QUEUE_TABLESDescribes the queues in the queue tables created in the current user's schema.
USER_RECYCLEBINDisplays information of all temporarily deleted objects that the current user owns. The columns are the same as those in ALL_RECYCLEBIN.
USER_ROLE_PRIVSDisplays roles granted to the current user.
USER_SCHEDULER_CHAINSDisplays all scheduler chains that the current user owns.
USER_SCHEDULER_JOBSDisplays all scheduler jobs that the current user owns.
USER_SCHEDULER_JOB_LOGDisplays all scheduler job log that the current user owns.
USER_SCHEDULER_JOB_RUN_DETAILSDisplays all scheduler job run details that the current user owns.
USER_SCHEDULER_PROGRAMSDisplays all scheduler programs that the current user owns.
USER_SCHEDULER_RULESDisplays all scheduler rules that the current user owns.
USER_SCHEDULER_RULE_CTXDisplays all scheduler rule ctx that the current user owns.
USER_SCHEDULER_RUNNING_JOBSDisplays all scheduler running jobs that the current user owns.
USER_SCHEDULER_SCHEDULESDisplays all scheduler schedules that the current user owns.
USER_SCHEDULER_STEPSDisplays all scheduler steps that the current user owns.
USER_SCHEDULER_STEP_CTXDisplays all scheduler step context the current user owns.
USER_SEGMENTSDisplays all segments which belong to the current user.
USER_SEQUENCESDisplays all sequences that the current user owns.
USER_SOURCEDisplays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.
USER_SUBPART_KEY_COLUMNSDisplays subpartitioning key columns of the partitioned tables or indexes that the current user owns.
USER_SYNONYMSDisplays synonyms that the current user owns.
USER_SYS_PRIVSDisplays system privileges granted to the current user.
USER_TABLESDisplays all tables that the current user owns.
USER_TABLESPACESSynonym for DBA_TABLESPACES.
USER_TAB_COLSSynonym for USER_TBL_COLS.
USER_TAB_COLUMNSSynonym for USER_TBL_COLUMNS.
USER_TAB_COL_STATISTICSSynonym for USER_TBL_COL_STATISTICS.
USER_TAB_COMMENTSDisplays comments on all tables and views that the current user owns.
USER_TAB_HISTOGRAMSSynonym for USER_TBL_HISTOGRAMS.
USER_TAB_IDENTITY_COLSDisplays identity columns of all tables that the current user owns.
USER_TAB_PARTITIONSSynonym for USER_TBL_PARTITIONS.
USER_TAB_PRIVSSynonym for USER_TBL_PRIVS.
USER_TAB_PRIVS_MADESynonym for USER_TBL_PRIVS_MADE.
USER_TAB_PRIVS_RECDSynonym for USER_TBL_PRIVS_RECD.
USER_TBL_COLSDisplays columns of all tables and views that the current user owns.
USER_TBL_COLUMNSDisplays columns of all tables and views that the current user owns.
USER_TBL_COL_STATISTICSDisplays statistics and a histogram of columns by extracting them from USER_TBL_COLUMNS.
USER_TBL_COMMENTSSynonym for USER_TAB_COMMENTS.
USER_TBL_HISTOGRAMSDisplays histogram information of tables that the current user owns.
USER_TBL_PARTITIONSDisplays partition information of all tables that the current user owns.
USER_TBL_PRIVSDisplays object privileges granted on all tables for which the current user is the object owner, grantor, or grantee.
USER_TBL_PRIVS_MADEDisplays object privileges granted on tables for which the current user is the object owner.
USER_TBL_PRIVS_RECDDisplays object privileges granted on tables for which the current user is the object grantee.
USER_TRIGGERSDisplays all triggers that the current user owns.
USER_TRIGGER_COLSDisplays column information of all triggers that the current user owns and all triggers on tables that the current user owns The columns are the same as those in ALL_TRIGGER_COLS.
USER_TYPESDisplays all types that the current user owns.
USER_TYPE_ATTRSDisplays all the attributes of this type that the current user owns.
USER_TYPE_METHODSDisplays all the methods of this type that the current user owns.
USER_UPDATABLE_COLUMNSDisplays all join view columns that the current user can update.
USER_USERSDisplays a description on the current user.
USER_VIEWSDisplays all views that the current user owns.
all_dba_subpartition_templatesdisplays all subpartition templates that the current user can access.
all_idx_partitionsdisplays partitions of the indexes that the current user can access.
all_ind_partitionssynonym for all_idx_partitions.
dba_idx_partitionsdisplays all index partitions in the database.
dba_ind_partitionssynonym for dba_idx_partitions.
dba_subpartition_templatesdisplays all subpartition templates in the database.
user_idx_partitionsdisplays partitions of the indexes that the current user owns.
user_ind_partitionssynonym for user_idx_partitions.

Displays all parameters of the procedure or function that the current user can call.

Displays all tables, views, synonyms, and sequences that the current user can access.

Displays all the collection types that the current user can access.

Displays comments on columns of the tables or views that the current user can access.

Displays columns for which the current user or public user is the object owner or grantor (user who granted the privilege).

Displays columns for which the current user is the object owner or grantor.

Displays columns for which the current user or public user is the grantee.

Displays constraints defined in the table that the current user can access.

Displays columns that the current user can access and that are specified in integrity constraint definitions.

Displays columns with constraint information that the current user can access and that are specified in integrity constraint definitions.

  • Columns

    Column NameData TypeDescription
    OWNERVARCHAR(128)

    Owner of the constraint

    CON_IDVARCHAR(128)

    Constraint id

    CONSTRAINT_NAMEVARCHAR(128)

    Name of the constraint

    TABLE_NAMEVARCHAR(128)

    Name of the table for which the constraint is defined

    COLUMN_NAMEVARCHAR(128)

    Name of the column defined in constraint definition

    POSITIONNUMBER

    Position of the column

    CON_TYPEVARCHAR(22)

    Type of the constraint

    - CHECK: Check constraint

    - PRIMARY KEY: Primary key constraint

    - UNIQUE: Unique key constraint

    - REFERENTIAL: Referential constraint

    - CHECK VIEW: Check view constraint

    - READ ONLY, VIEW: Read only constraint

    - NOT NULL: Not null constraint

    - ERR: Error constraint

    DELETE_RULEVARCHAR(9)

    Delete rule for the referential constraint

    - CASCADE

    - SET NULL

    - NO ACTION

    REF_CON_IDNUMBER

    Constraint id of the primary key or unique key constraint defined in the table to be referred to

Displays information for the database links that the current user can use.

Displays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user can access.

Displays all directories that the current user can access.

Displays information of all encrypted columns that the current user can access.

Displays the recent errors on every accessible view, procedure, function, package, package body, trigger, library, and java object.

Displays all external table locations that the current user can access.

Displays all external tables that the current user can access.

Displays index columns (including LOB) with index information of all tables that the current user can access

  • Columns

    Column NameData TypeDescription
    TABLE_OWNERVARCHAR(128)

    Owner of the table

    TABLE_NAMEVARCHAR(128)

    Name of the table

    INDEX_OWNERVARCHAR(128)

    Owner of the index

    INDEX_NAMEVARCHAR(128)

    Name of the index

    INDEX_TYPEVARCHAR

    Index type (string)

    COLUMN_NAMEVARCHAR(128)

    Name of the column

    COLUMN_POSITIONNUMBER

    Position of the column

Displays index columns of all tables that the current user can access.

Displays index columns with index information of all tables that the current user can access.

  • Columns

    Column NameData TypeDescription
    INDEX_OWNERVARCHAR(128)

    Owner of the index

    INDEX_NAMEVARCHAR(128)

    Name of the index

    TABLE_OWNERVARCHAR(128)

    Owner of the table

    TABLE_NAMEVARCHAR(128)

    Name of the table

    UNIQUENESSVARCHAR(9)

    Whether or not the unique key is indexed.

    - NONUNIQUE

    - UNIQUE

    - UNDEFINED

    DISTINCT_KEYSNUMBER

    The number of distinct keys in the index

    LEAF_BLOCKSNUMBER

    The number of leaf blocks in the index

    COLUMN_NAMEVARCHAR(128)

    Name of the column

    COLUMN_POSITIONNUMBER

    Position of the column within the index

    COLUMN_LENGTHNUMBER

    Length of the column within the index

    DESCENDVARCHAR(4)

    Sorting order in columns

    - DESC

    - ASC

Displays expressions on function-based index columns of all tables that the current user can access.

Displays subpartitions of the index that the current user can access.

Displays indexes of all tables that the current user can access.

Synonym for ALL_IDX_COLUMNS.

Synonym for ALL_IDX_EXPRESSIONS.

Synonym for ALL_IDX_SUBPARTITIONS.

Displays all parameters that the current user can access.

Displays all classes that the current user can access.

Displays all fields that the current user can access.

Displays all methods that the current user can access.

Displays all jobs that the current user can access.

Displays all jobs with job name that the current user can access.

Displays all libraries that the current user can access.

Displays large objects (LOB) which belong to all tables that the current user can access.

Displays all LOB partitions that the current user can access.

Displays LOB subpartitions that the current user can access.

Displays the log group definitions on the tables accessible to the current user.

Displays columns that are accessible to the current user and that are specified in log groups.

Displays all the method parameters of the type that the current user can access.

Displays the result of the method of this type that the current user can access.

Displays all materialized views that the current user can access.

Displays comments on the materialized views that the current user can access.

describes all such detail relations defined for all materialized views in the database.

Displays all materialized view logs that the current user can access.

Describes refresh times of all materialized views accessible to the current user.

Displays all objects that the current user can access.

Displays collection types of the package that the current user can access,

Displays attributes of the package type that the current user can access.

Displays member types of the package that the current user can access

Displays partition information for the partitioned indexes that the current user can access.

Displays partitioning key columns of the partitioned tables or indexes that the current user can access.

Displays LOBs which belong to all partitioned tables that the current user can access.

Displays partitioning information of all partitioned tables that the current user can access.

Displays all procedures defined in all procedures and tables that the current user owns.

Describes all queues on which the current user has enqueue or dequeue privileges.

Shows the list of subscribers that the current user has privilege to dequeue from.

Describes the queues in the queue tables accessible to the current user.

Displays information of all temporarily deleted objects that the current user can access.

Displays all scheduler chains that the current user can access.

Displays all scheduler jobs that the current user can access.

Displays all scheduler job log that the current user can access.

Displays all scheduler job run details that the current user can access.

Displays all scheduler programs that the current user can access.

Displays all scheduler rules that the current user can access.

Displays all scheduler rule ctx that the current user can access.

Displays all scheduler running jobs that the current user can access.

Displays all scheduler schedules that the current user can access.

Displays all scheduler steps that the current user can access.

Displays all scheduler step context the current user can access.

Displays all segments that the current user can access.

Displays all sequences that the current user can access.

Displays source texts of the stored objects that the current user can access such as procedures, functions, package bodies, or triggers.

Displays subpartitioning key columns of the partitioned tables or indexes that the current user can access.

Displays all synonyms that the current user can access.

Displays all tables that the current user can access.

Synonym for ALL_TBL_COLS.

Synonym for ALL_TBL_COLUMNS.

Synonym for ALL_TBL_COL_STATISTICS.

Displays comments on the tables that the current user can access.

Synonym for ALL_TBL_HISTOGRAMS.

Displays identity columns of all tables that the current user can access.

Synonym for ALL_TBL_PARTITIONS.

Synonym for ALL_TBL_PRIVS.

Synonym for ALL_TBL_PRIVS_MADE.

Synonym for ALL_TBL_PRIVS_RECD.

Synonym for ALL_TBL_SUBPARTITIONS.

Displays column information of all tables and views that the current user can access.

Displays column information of all tables and views that the current user can access.

Displays column information of all tables and views, which the current user can access, with data type number of the column.

Displays statistics and a histogram of columns by extracting them from ALL_TBL_COLUMNS.

Synonym for ALL_TAB_COMMENTS.

Displays histogram information of tables that the current user can access.

Displays partition information of all tables that the current user can access.

Displays tables for which the current user or public user is granted object privileges.

Displays object privileges granted on tables for which the current user or public user is the object owner or grantor.

Displays object privileges granted on tables for which the current user or public user is the object grantee.

Displays subpartitions of all tables that the current user can access.

Displays all triggers that the current user can access.

Displays column information of all triggers that the current user can access and all triggers on tables that the current user can access.

Displays all types that the current user can access.

Displays all the attributes that the current user can access.

Displays all the methods of this type that the current user can access.

Displays all join view columns that the current user can update.

Displays all users that the current user can view.

Displays all views that the current user can access.

Displays all views that the current user can access. (including views that can be accessed by the roles)

Displays preferences created by Tibero users, as well as all the system-defined preferences.

  • Columns

    Column NameData TypeDescription
    PRE_OWNERVARCHAR(128)

    Username of preference owner

    PRE_NAMEVARCHAR(30)

    Preference name

    PRE_CLASSVARCHAR(30)

    Preference class

    PRE_OBJECTVARCHAR(30)

    Object used

Displays the values assigned to all the preferences in the Text data dictionary.

  • Columns

    Column NameData TypeDescription
    PRV_OWNERVARCHAR(128)

    Username of preference owner

    PRV_PREFERENCEVARCHAR(30)

    Preference name

    PRV_ATTRIBUTEVARCHAR(30)

    Attribute name

    PRV_VALUEVARCHAR(500)

    Attribute value

Displays database properties.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(128)

    Name of the property

    VALUEVARCHAR(80)

    Value of the property

    COMMENT_STRVARCHAR(4000)

    Description of the property

Displays connection information for pending transactions.

  • Columns

    Column NameData TypeDescription
    LOCAL_TRAN_IDVARCHAR(65532)

    ID of the transaction

    IN_OUTNUMBER

    Connection status

    - IN: Incoming connection

    - OUT: Outgoing connection

    DATABASEVARCHAR(128)

    Name of the database

    - IN: Client database name

    - OUT: Database link name

    DBUSER_OWNERVARCHAR(128)

    Name of the owner

    - IN: Name of the user who accesses the database

    - OUT: Owner of the database link

    INTERFACEVARCHAR(1)

    Type of the interface

    - C: Commit point site

    - N: Non-commit point site

Displays pending transaction information.

  • Columns

    Column NameData TypeDescription
    LOCAL_TRAN_IDVARCHAR(65532)

    ID of the transaction

    XIDVARCHAR(550)

    XID

    STATUSVARCHAR(15)

    Status of the XA transaction

Displays all fine-grained auditing policies in the database.

  • Columns

    Column NameData TypeDescription
    OBJECT_SCHEMAVARCHAR(128)

    Owner of the table or view

    OBJECT_NAMEVARCHAR(128)

    Name of the table or view

    POLICY_OWNERVARCHAR(128)

    Owner of the policy

    POLICY_NAMEVARCHAR(128)

    Name of the policy

    POLICY_TEXTVARCHAR(4000)

    Audit condition

    POLICY_COLUMNVARCHAR(128)

    Relevant column

    PF_SCHEMAVARCHAR(128)

    Owner of the audit handler function

    PF_PACKAGEVARCHAR(128)

    Name of the package containing the audit handler function

    PF_FUNCTIONVARCHAR(128)

    Name of the audit handler function

    ENABLEDVARCHAR(3)

    Indicates whether the policy is enabled (YES) or disabled (NO)

    SELVARCHAR(3)

    Indicates whether the policy is applied to queries on the object (YES) or not (NO)

    INSVARCHAR(3)

    Indicates whether the policy is applied to INSERT statements on the object (YES) or not (NO)

    UPDVARCHAR(3)

    Indicates whether the policy is applied to UPDATE statements on the object (YES) or not (NO)

    DELVARCHAR(3)

    Indicates whether the policy is applied to DELETE statements on the object (YES) or not (NO)

    AUDIT_TRAILVARCHAR(12)

    Indicates the audit trail to which the audit records generated by this audit policy will be written: 1. DB - Audit records are written to DBA_FGA_AUDIT_TRAIL 2. DB+EXTENDED - Audit records are written to DBA_FGA_AUDIT_TRAIL and the SQL_TEXT and SQL_BIND columns are populated for this policy 3. XML - Audit records are written to V$XML_AUDIT_TRAIL 4. XML+EXTENDED - Audit records are written to V$XML_AUDIT_TRAIL and the SQL_TEXT and SQL_BIND columns are populated for this policy

    POLICY_OPTIONSVARCHAR(11)

    Indicates whether all columns in the AUDIT_COLUMN parameter (ALL_COLUMNS) or any of the columns in the AUDIT_COLUMN parameter (ANY_COLUMNS) are considered for triggering fine-grained auditing

Displays audit trails within the database.

Displays all tables, views, synonyms, and sequences in the database.

Displays all the collection types.

Displays comments on all columns in the database.

Displays object privileges of all columns of the database.

Displays integrity constraints defined in the database table.

Displays the columns for which the database integrity constraint is specified.

Synonym for DBA_DATA_FILES.

Displays data file information.

Displays information for all database links.

displays information about DDL locks.

  • Columns

    Column NameData TypeDescription
    SESS_IDNUMBER

    ID of the thread that owns the Lock(the same as SID)

    OWNERVARCHAR(128)

    Owner of the object

    NAMEVARCHAR(128)

    Name of the object

    TYPEVARCHAR(25)

    Type of the lock

    MODE_HELDVARCHAR(30)

    Mode that the Lock owner owns.

    - None

    - Row-Shared(RS)

    - Row-Exclusive(RX)

    - Shared(S)

    - Shared-Row-Exclusive(SRX)

    - Exclusive(X)

    - Pin (Special mode for TX-wait)

    MODE_REQUESTEDVARCHAR(30)

    Mode that the Lock waiter requests

Displays dependencies of all objects.

Displays all directories in the database.

displays information about DML locks.

  • Columns

    Column NameData TypeDescription
    SESS_IDNUMBER

    ID of the thread that owns the Lock(the same as SID)

    OWNERVARCHAR(128)

    Owner of the object

    NAMEVARCHAR(128)

    Name of the object

    MODE_HELDVARCHAR(30)

    Mode that the Lock owner owns.

    - None

    - Row-Shared(RS)

    - Row-Exclusive(RX)

    - Shared(S)

    - Shared-Row-Exclusive(SRX)

    - Exclusive(X)

    - Pin (Special mode for TX-wait)

    MODE_REQUESTEDVARCHAR(30)

    Mode that the Lock waiter requests

    LAST_CONVERTNUMBER

    The amount of elapsed time (in seconds) in current mode

    BLOCKING_OTHERSVARCHAR(12)

    Whether the Lock is blocking any other session.

    - Blocking: the Lock is blocking a session.

    - Non Blocking: the Lock is not blocking any session.

Displays information of all encrypted columns in the database. The columns are the same as those in ALL_ENCRYPTED_COLUMNS.

Displays the recent errors on every view, procedure, function, package, package body, trigger, library, and java object in the database. The columns are the same as those in ALL_ERRORS.

Displays information of the extents contained in the segments of all the tablespaces in the database.

Displays all external table locations in the database.

Displays all external tables in the database.

Diplays TODO. TODO

    Displays information of the extents that all tablespaces can use.

    Displays history information on active sessions.

    • Columns

      Column NameData TypeDescription
      SANP_IDNUMBER

      Snap ID

      SAMPLE_IDNUMBER

      Sample ID

      THREAD#NUMBER

      Thread#

      SAMPLE_TIMEDATE

      Sample Time

      SESSION_IDNUMBER

      Session ID

      SESS_SERIAL_NONUMBER

      A serial number of a session

      USER_NONUMBER

      The user's ID

      WAIT_EVENTNUMBER

      Type of the wait event which the session waits

      TIME_WAITEDNUMBER

      The amount of time waited for this event (msec)

      SQL_IDVARCHAR(13)

      SQL identifier

      SQL_CHILD_NUMBERNUMBER

      The number of this child physical plan

      CURR_HASHVALNUMBER

      SQL hash value

      MODULE_NAMEVARCHAR(64)

      Name of a module specified by dbms_application_info.set_module

      ACTION_NAMEVARCHAR(64)

      Name of an action specified by dbms_application_info.set_module/action

      CLIENT_INFO_NAMEVARCHAR(64)

      Name of client_info specified by dbms_application_info.set_client_info

      PROG_NAMEVARCHAR(30)

      Client program name

      SQL_EXEC_STARTDATE

      The time when the execution started.

      SQL_EXEC_IDNUMBER

      Execution identifier. It is necessary to identify multiple simultaneous SQL executions. To identify a single SQL execution, three columns; SQL_ID, SQL_EXEC_START, and SQL_EXEC_ID must be defined. The three column values are used to match with corresponding rows in the V$SQL_MONITOR.

      SQL_PLAN_LINE_IDNUMBER

      Identifier of the plan operation

      ID1NUMBER

      First Parameter

      ID2NUMBER

      Second Parameter

      WE_SEQNUMBER

      Sequence# of the Wait Event

      USGMT_IDNUMBER

      USGMT number at the time of sampling

      SLOTNONUMBER

      Slot number at the time of sampling

      WRAPNONUMBER

      Wrap number at the time of sampling

      PORTNUMBER

      Client port number

      DELTA_TIMENUMBER

      Time interval (in seconds) since the last time this session was sampled or created.

      DELTA_PHY_READ_BLKSNUMBER

      The number of blocks read from disk over the last DELTA_TIME seconds

      DELTA_LOG_READ_BLKSNUMBER

      The number of blocks read over the last DELTA_TIME seconds

      PGA_SIZENUMBER

      The amount of PGA memory consumed by this session

      WAIT_OBJ_IDNUMBER

      ID of the object which the session waits

      WAIT_FILE_NONUMBER

      Number of the file which the session waits

      WAIT_BLOCK_NONUMBER

      Number of the block which the session waits

      WAIT_ROW_NONUMBER

      Number of the row which the session waits

      WAIT_EVENT_NAMEVARCHAR(40)

      Name of wait_event

    Displays historical statistics of data file and temp file I/O. This view includes snapshots of V$ALL_FILESTAT.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      FILE#NUMBER

      File number

      PHYRDSNUMBER

      The number of read operations performed

      PHYWRTSNUMBER

      The number of write operations performed

      READTIMNUMBER

      Time spent on read operations (msec)

      WRITETIMNUMBER

      Time spent on write operations (msec)

      PHYBLKRDNUMBER

      The number of blocks read

      PHYBLKWRTNUMBER

      The number of blocks written

    Displays the historical information on spinlocks. This view includes snapshots of V$LATCH.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      LATCH#NUMBER

      Spinlock number

      GETSNUMBER

      The number of times a spinlock was acquired

      MISSESNUMBER

      The number of times the requester had to wait for a spinlock

      SLEEPSNUMBER

      The number of times the requester was put to sleep while waiting for a spinlock

      IMMEDIATE_GETSNUMBER

      The number of times a trylock was acquired

      IMMEDIATE_MISSESNUMBER

      The number of times the requester failed to acquire a trylock

      SPIN_GETSNUMBER

      The number of times the requester failed to acquire a spinlock but succeeded in gaining a spin

      WAIT_TIMENUMBER

      The total sleep time of spinlock

      SLEEPS_CNTNUMBER

      The number of actual sleep count while waiting for a spinlock

    Displays information of PP cache and DD cache. This view includes snapshots of V$LIBRARYCACHE.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      NAMESPACEVARCHAR(16)

      Name of the table

      GETSNUMBER

      Cache total access count

      GETHITSNUMBER

      Cache hit count

    Displays historical information on various OS statistics. This view includes snapshots of V$OSSTAT2.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      STAT_IDNUMBER

      Identifier of OS statistics

      VALUENUMBER

      OS statistics value

    Displays the historical statistics of PGA. This view includes the snapshot of V$PGASTAT.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      NAMEVARCHAR(64)

      Name of a PGA statistics

      VALUENUMBER

      Value of the PGA statistics

      SNAP_TIMEDATE

      Snapshot time of PGA statistics

    Displays historical information on PGA memory usage. This view gets information from V$PROCESS.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot.

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      NUM_PROCESSESNUMBER

      Number of processes

      NON_ZERO_USESNUMBER

      Number of processes with non-zero memory usage

      USED_TOTALNUMBER

      Total size of local memory occupied

      USED_AVGNUMBER

      Average size of local memory occupied

      USED_STDDEVNUMBER

      Standard deviation of local memory occupied

      USED_MAXNUMBER

      Maximum size of local memory occupied

    Displays historical information of segment-level statistics. This view includes snapshots of V$SEGMENT_STATISTICS.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      OBJ_IDNUMBER

      Object ID

      STATISTICS#NUMBER

      Segment statistics type

      STATISTICS_NAMEVARCHAR(64)

      Name of the segment statistics

      VALUENUMBER

      Value of the segment statistics

    Displays the historical information on the shared pool for a database. This view includes snapshots of V$SGASTAT.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      NAMEVARCHAR(40)

      Purpose for which shared pool is used

      SIZENUMBER

      Usage of shared pool

    Displays information about TPR snapshots.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      BEGIN_INTERVAL_TIMEDATE

      Start time of a snapshot interval

      END_INTERVAL_TIMEDATE

      End time of a snapshot interval

    Displays DBA_HIST_SQLBIND displays historical information on bind variables used by SQL cursors. This view contains snapshots of V$SQL_BIND_CAPTURE.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      SQL_HASH_VALUENUMBER

      The Hash value of the sql

      PLAN_HASH_VALUENUMBER

      The Hash value of the physical plan

      SQL_IDVARCHAR(13)

      The SQL identifier

      CHILD_NUMBERNUMBER

      The number of this child physical plan

      USER_IDNUMBER

      The user id that performed the SQL

      NAMEVARCHAR(128)

      The name of the bind variable

      POSITIONNUMBER

      The position of the bind variable in the SQL

      TYPENUMBER

      The type number of the bind variable

      TYPE_NAMEVARCHAR(128)

      The type of the bind variable

      PRECISIONNUMBER

      The precision of the bind variable

      SCALENUMBER

      The scale of the bind variable

      LENGTHNUMBER

      The length of the bind variable

      TIME_CAPTUREDDATE

      The time when the bind variable was captured

      IS_FIRSTVARCHAR(4)

      Whether or not the first value of the bind variable was captured

      VALUEVARCHAR(32413)

      The value of the bind variable

    Displays historical information for SQL statistics. This view displays the priority of items of specific criteria.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      SQL_HASH_VALUENUMBER

      Hash value of the SQL statement

      PLAN_HASH_VALUENUMBER

      Hash value of the physical plan

      LAST_ACTIVE_TIMEDATE

      Last time that statistics were collected

      PARSE_CALLSNUMBER

      The number of parsing requests

      FETCHESNUMBER

      The number of fetching times

      EXECUTIONSNUMBER

      The number of times for executing an SQL statement

      BUFFER_GETSNUMBER

      Total number of buffers read in Consistent-Read mode

      ROWS_PROCESSEDNUMBER

      Total number of processed rows

      ELAPSED_TIMENUMBER

      Total execution time (in microseconds)

      DISK_READ_TIMENUMBER

      Total disk read time

      TEMP_SGMT_READ_TIMENUMBER

      Total temp segment read time

      TEMP_SGMT_WRITE_TIMENUMBER

      Total temp segment write time

    Displays historical information about texts of SQL statements.

    • Columns

      Column NameData TypeDescription
      SQL_HASH_VALUENUMBER

      Hash value of the SQL statement

      SQL_TEXTVARCHAR(64)

      Text of an SQL statement split into 64-byte texts

      COMMAND_TYPENUMBER

      Number code of SQL statement type 1 - SELECT 2 - INSERT 3 - UPDATE 4 - DELETE 5 - MERGE 6 - CALL

    Displays historical information about SQL execution plans. This view includes snapshots of V$SQL_PLAN.

    • Columns

      Column NameData TypeDescription
      SQL_HASH_VALUENUMBER

      Hash value of the SQL statement

      PLAN_HASH_VALUENUMBER

      Hash value of the physical plan

      IDNUMBER

      Number given to each job of the physical plan

      OPERATIONVARCHAR(128)

      Name of operation job

      OBJECT_IDNUMBER

      Identifier of object accessed by the job

      OBJECT_OWNERVARCHAR(128)

      Name of user to whom the object belongs

      OBJECT_NAMEVARCHAR(128)

      Object name

      OBJECT_TYPEVARCAHR(20)

      Object type

      PARENT_IDNUMBER

      ID of a job to get the output of the current job of the physical plan as input

      DEPTHNUMBER

      Tree level of the physical plan

      POSITIONNUMBER

      Positions between all the jobs with the same PARENT_ID

      COSTNUMBER

      Job cost estimated by query optimizer

      CARDINALITYNUMBER

      The number of output results estimated by query optimizer

      PARTITION_STARTVARCHAR(38)

      In a partitioned table, the start partition for access

      PARTITION_STOPVARCHAR(38)

      In a partitioned table, the end partition for access

      OTHERVARCHAR(4000)

      Other information specific to the execution step that may be useful

      -Database link information

      -Dynamic sampling block count for table scans or index scans

      CPU_COSTNUMBER

      CPU cost of the operation as estimated by query optimizer

      IO_COSTNUMBER

      I/O cost of the operation as estimated by query optimizer

      ACCESS_PREDICATESVARCHAR(4000)

      Predicate information to access indexes indexes or to handle joins

      FILTER_PREDICATESVARCHAR(4000)

      Predicate information to handle filters

    Displays historical information about work areas used by SQl cursors. This view includes snapshots of V$SQL_WORKAREA_HISTOGRAM.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      LOW_OPTIMAL_SIZENUMBER

      The lower bounding value (in bytes) for the optimal size

      HIGH_OPTIMAL_SIZENUMBER

      The higher bounding value (in bytes) for the optimal size

      OPTIMAL_EXECUTIONSNUMBER

      The number of work areas that were executed in optimal mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

      ONEPASS_EXECUTIONSNUMBER

      The number of work areas that were executed in onepass mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

      MULTIPASSES_EXECUTIONSNUMBER

      The number of work areas that were executed in multipass mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

      TOTAL_EXECUTIONSNUMBER

      The total number of work areas that were excuted within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

    Displays a history of statistical summary of all metric values in the System Metrics Long Duration group.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      THREAD#NUMBER

      Thread#

      BEGIN_TIMEDATE

      Begin Time of the Sample

      END_TIMEDATE

      End Time of the Sample

      GROUP_IDNUMBER

      Group ID

      METRIC_IDNUMBER

      Metric ID

      METRIC_NAMEVARCHAR(64)

      Metric Name

      METRIC_UNITVARCHAR(64)

      Descriptions of the Metric Unit

      MINVALNUMBER

      Minimum value observed

      MINVALNUMBER

      Maximum value observed

      AVERAGENUMBER

      Average over the period

      STDNUMBER

      One standard deviation

    Displays historical information of events performing in the system. This view includes snapshots of V$SYSTEM_EVENT.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      EVENT_NUMBERNUMBER

      Event number

      TOTAL_WAITSNUMBER

      Total number of event calls

      TIME_WAITEDNUMBER

      The amount of time waited for this event (msec)

      AVERAGE_WAITNUMBER

      The average amount of time waited for this event (msec)

      MAX_WAITNUMBER

      The maximum amount of time waited for this event (msec)

      TOTAL_TIMEOUTSNUMBER

      The number of times that a time-out occurred in an event

    Displays historical statistics of undo storage space. This view includes snapshots of V$UNDOSTAT.

    • Columns

      Column NameData TypeDescription
      END_TIMEDATE

      End time of statistics

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      SNAP_IDNUMBER

      Unique ID of a snapshot

      UNDO_TSNONUMBER

      Tablespace number

      UNDOBLKSNUMBER

      The number of used undo blocks

      TXCOUNTNUMBER

      Total number of executed transactions

      MAXCONCURRENCYNUMBER

      The largest number of concurrently executed transcations

      SNAP_TOO_OLD_CNTNUMBER

      The number of errors caused by failing to read old data

      NOSPACEERRCNTNUMBER

      The number of errors caused by lack of undo storage space

      ACTIVEBLKSNUMBER

      The number of blocks in use

      UNEXPIREDBLKSNUMBER

      The number of non-reusable blocks

      EXPIREDBLKSNUMBER

      The number of reusuable blocks

    Displays the statistical history of block wait events for each block type and class. This view includes snapshots of V$WAITSTAT.

    • Columns

      Column NameData TypeDescription
      SNAP_IDNUMBER

      Unique ID of a snapshot

      INSTANCE_NUMBERNUMBER

      Instance number of the snapshot

      CLASSVARCHAR(20)

      Block class (Block type)

      WAIT_COUNTNUMBER

      The number of times waiting for the block class

      TIMENUMBER

      Total time spent waiting for the block class

    Displays index columns of all tables in the database.

    Displays expressions on the index columns of all tables in the database.

    Displays subpartitions of all indexes in the database.

    Displays indexes of all tables in the database.

    Synonym for DBA_IDX_COLUMNS.

    Synonym for DBA_IDX_EXPRESSIONS.

    Synonym for DBA_IDX_SUBPARTITIONS.

    Displays all parameters in the database.

    Displays all classes in the database.

    Displays all fields in the database.

    Displays all methods in the database.

    Displays all jobs in the database.

    Displays all jobs with job name in the database.

    Displays all libraries in the database.

    Displays LOBs which belong to all tables in the database.

    Displays all LOB partitions in the database.

    Displays all LOB subpartitions in the database.

    Displays the log group definitions on all tables in the database.

    Displays all columns in the database that are specified in log groups.

    Displays the method parameters of this type.

    Displays the result of the method of this type.

    Displays all materialized views in the database. The columns are the same as those in ALL_MVIEWS.

    Displays comments on all materialized views in the database. The columns are the same as those in ALL_MVIEW_COMMENTS.

    Describes the named detail relations that are either specified in the FROM list of the subquery that defines all materialized views in the database, or that are indirectly referenced through views in that FROM list. Inline views in the materialized view definition are not represented in this view or the related views.

    Displays all materialized view logs in the database. The columns are the same as those in ALL_MVIEW_LOGS.

    Describes refresh times of all materialized views in the database.

    Displays all objects in the database.

    Displays objects being audited in the database.

    Displays types of the package.

    Displays types of the package.

    Displays types of the package.

    Displays partitioning information for the partitioned indexes in the database.

    Displays partitioning key columns for all partitioned tables or indexes in the database.

    Displays LOBs which belong to the partitioned tables in the database.

    Displays partitioning information of the partitioned tables in the database.

    Displays users being audited in the database.

    • Columns

      Column NameData TypeDescription
      USER_NAMEVARCHAR(128)

      Name of the user being audited

      PROXY_NAMEVARCHAR(128)

      PROXY name of the user being audited

      PRIVILEGEVARCHAR(40)

      Name of the system privilege being audited

      SUCCESSVARCHAR(10)

      Auditing option at success

      FAILUREVARCHAR(10)

      Auditing option at failure

    Displays all procedures in the database.

    Describes all profiles in the database.

    • Columns

      Column NameData TypeDescription
      PROFILEVARCHAR(255)

      Name of the profile

      RESOURCE_NAMEVARCHAR(255)

      Name of the resource

      RESOURCE_TYPEVARCHAR(8)

      Indicates whether the resource profile is a KERNEL or a PASSWORD parameter

      LIMITVARCHAR(256)

      Limit placed on this resource for this profile

    Describes all queues in the database.

    Shows the list of subscribers on all queues in the database.

    Describes the queues in all queue tables in the database.

    Displays information of all temporarily deleted objects in the database. The columns are the same as those in ALL_RECYCLEBIN.

    Displays all objects in database which are being redefined online.

    • Columns

      Column NameData TypeDescription
      OBJECT_TYPEVARCHAR(5)

      Type of the object. (Currently, only 'TABLE' is available)

      OBJECT_OWNERVARCHAR(128)

      Owner of the object.

      OBJECT_NAMEVARCHAR(128)

      Name of the object.

      BASE_TABLE_OWNERVARCHAR(128)

      Owner of the base table of the object.

      BASE_TABLE_NAMEVARCHAR(128)

      Name of the base table of the object.

      INTERIM_OBJECT_OWNERVARCHAR(128)

      Owner of the intermediate table of the object.

      INTERIM_OBJECT_NAMEVARCHAR(128)

      Name of the intermediate table of the object.

    Displays all roles in the database.

    • Columns

      Column NameData TypeDescription
      ROLEVARCHAR(128)

      Name of the role

      PASSWORD_REQUIREDVARCHAR(3)

      Whether a password is required or not

    Displays roles granted to the users in the database.

    Synonym for DBA_UNDO_SGMTS.

    Displays all scheduler chains in the database.

    Displays all scheduler jobs in the database.

    Displays all scheduler job log in the database.

    Displays all scheduler job run details in the database.

    Displays all scheduler programs in the database.

    Displays all scheduler rules in the database.

    Displays all scheduler rule ctx in the database.

    Displays all scheduler running jobs in the database.

    Displays all scheduler schedules in the database.

    Displays all scheduler steps in the database.

    Displays all scheduler step context in the database.

    Displays all segments in the database.

    Displays all sequences in the database.

    Displays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.

    !!! No documentation yet !!!

    • Columns

      Column NameData TypeDescription
      SPL_OWNERVARCHAR(128)

      Owner of stoplist

      SPL_NAMEVARCHAR(30)

      Name of stoplist

      SPL_COUNTNUMBER

      Number of stopwords

      SPL_TYPEVARCHAR(30)

      Type of stoplist Displays information about the created SQL plan baselines

      SIGNATURENUMBER

      Unique SQL identifier generated from normalized SQL TEXT

      SQL_HANDLEVARCHAR2(30)

      Unique SQL identifier

      SQL_TEXTCLOB

      Un-normalized SQL text

      PLAN_NAMEVARCHAR2(30)

      Unique plan identifier

      CREATORVARCHAR2(30)

      User who created the plan baseline

      ORIGINVARCHAR2(14)

      How the plan baseline was created: MANUAL-LOAD AUTO-CAPTURE MANUAL-SQLTUNE AUTO-SQLTUNE

      PARSING_SCHEMA_NAMEVARCHAR2(30)

      Parsing schema name

      DESCRIPTIONVARCHAR2(500)

      Description about the plan baseline

      VERSIONVARCHAR2(64)

      Database version when the plan baseline was created

      CREATEDTIMESTAMP(6)

      Timestamp when the plan baseline was created

      LAST_MODIFIEDTIMESTAMP(6)

      Timestamp when the plan baseline was last modified

      LAST_EXECUTEDTIMESTAMP(6)

      Timestamp when the plan baseline was last executed

      LAST_VERIFIEDTIMESTAMP(6)

      Timestamp when the plan baseline was last verified

      ENABLEDVARCHAR2(3)

      Whether to enable the plan baseline

      ACCEPTEDVARCHAR2(3)

      Whether to accept the plan baseline

      FIXEDVARCHAR2(3)

      Whether to fix the plan baseline

      AUTOPURGEVARCHAR2(3)

      Whether to automatically purge the plan baselines

      OPTIMIZER_COSTNUMBER

      Optimizer cost when the plan baseline created

      MODULEVARCHAR2(48)

      Module name

      ACTIONVARCHAR2(32)

      Action

      EXECUTIONSNUMBER

      Number of executions

      ELAPSED_TIMENUMBER

      Total elapsed time

      CPU_TIMENUMBER

      Total CPU time

      BUFFER_GETSNUMBER

      Total buffer gets

      DISK_READSNUMBER

      Total disk reads

      DIRECT_WRITESNUMBER

      Total direct writes

      ROWS_PROCESSEDNUMBER

      Total rows processed

      FETCHESNUMBER

      Total number of fetches

      END_OF_FETCH_COUNTNUMBER

      Total number of full fetches

    displays information about SQL profiles currently created for specific SQL statements.

    • Columns

      Column NameData TypeDescription
      NAMEVARCHAR2(128)

      Name of the SQL profile

      CATEGORYVARCHAR2(128)

      Category of the SQL profile

      SIGNATURENUMBER

      Unique identifier generated from normalized SQL text

      SQL_TEXTCLOB

      Un-normalized SQL text

      CREATEDTIMESTAMP(6)

      Timestamp when the SQL profile was created

      LAST_MODIFIEDTIMESTAMP(6)

      Timestamp when the SQL profile was last modified

      DESCRIPTIONVARCHAR2(500)

      Text description provided for the SQL profile

      TYPEVARCHAR2(7)

      Type of the SQL profile (how it was created): MANUAL AUTO

      STATUSVARCHAR2(8)

      Status of the SQL profile: ENABLED DISABLED VOID

      FORCE_MATCHINGVARCHAR2(3)

      If YES, this causes SQL Profiles to target all SQL statements which have the same text after normalizing all literal values to bind variables. If a combination of literal values and bind variables is used in the same SQL text, then no transformation occurs. This is analogous to the matching algorithm use by the FORCE option of the CURSOR_SHARING parameter. If NO, literals are not transformed. This is analogous to the matching algorithm used by the EXACT option of the CURSOR_SHARING parameter.

    Displays subpartitioning key columns of the partitioned tables or indexes in the database.

    Displays synonyms in the database.

    Displays system privileges granted to users and roles in the database.

    Displays all tables in the database.

    Displays all tablespaces in the database.

    Synonym for DBA_TBL_COLS.

    Synonym for DBA_TBL_COLUMNS.

    Synonym for DBA_TBL_COL_STATISTICS.

    Displays comments on all tables and views in the database.

    Synonym for DBA_TBL_HISTOGRAMS.

    Displays identity columns of all tables.

    Synonym for DBA_TBL_PARTITIONS.

    Synonym for DBA_TBL_PRIVS.

    Synonym for DBA_TBL_SUBPARTITIONS.

    Displays columns of all tables and views in the database.

    Displays columns of all tables and views in the database.

    Displays statistics and a histogram of columns by extracting them from DBA_TBL_COLUMNS.

    Synonym for DBA_TAB_COMMENTS.

    Displays histogram information on tables and views in the database.

    Displays partition information of all tables in the database.

    Displays object privileges granted on all tables in the database.

    Displays subpartitions of all tables in the database.

    Synonym for DBA_TEMP_FILES.

    Displays information of the temporary data files.

    Displays all triggers in the database.

    Displays column information of all triggers in the database. The columns are the same as those in ALL_TRIGGER_COLS.

    Describe tablespace quotas for all user

    • Columns

      Column NameData TypeDescription
      TABLESPACE_NAMEVARCHAR(128)

      Name of the tablespace

      USERNAMEVARCHAR(128)

      Name of the user

      BYTESNUMBER

      Number of bytes charged to the user

      MAX_BYTESNUMBER

      User's quota in bytes

      BLOCKSNUMBER

      Number of blocks charged to the user

      MAX_BLOCKSNUMBER

      User's quota in blocks

      DROPPEDVARCHAR(3)

      Whether the tablespace has been dropped

    Displays all types.

    Displays all the attributes of this type.

    Displays all the methods of this type.

    Displays information about the extents in all undo segments.

    • Columns

      Column NameData TypeDescription
      USGMT_IDNUMBER

      ID of the undo segment containing the extent

      EXTNONUMBER

      Extent number

      TS_IDNUMBER

      ID of the tablespace containing the extent

      TS_NAMEVARCHAR

      Name of the tablespace containing the extent

      FILE_IDNUMBER

      ID of the file containing the extent

      BLOCK_IDNUMBER

      Starting block number of the extent

      BYTESNUMBER

      Size of the extent in bytes

      BLOCKSNUMBER

      Size of the extent in blocks

      STATUSVARCHAR(30)

      Current status of the extent

      IS_CURRENTVARCHAR(12)

      Whether the extent is current extent or not

    Displays undo segments in the database.

    Displays all join view columns that the DBA can update.

    Displays all users in the database.

    Displays all views in the database.

    displays outline hints that sql profile defines.

    • Columns

      Column NameData TypeDescription
      PROFILE_NAMEVARCHAR2(128)

      Name of the SQL profile

      COMP_DATACLOB

      SQL profile attribute

    Displays comments on tables and views in the data dictionary.

    • Columns

      Column NameData TypeDescription
      TABLE_NAMEVARCHAR(128)

      Name of the table or view

      COMMENTSVARCHAR(4000)

      Comments on the table or view

    Displays NLS parameters of the current database.

    • Columns

      Column NameData TypeDescription
      PARAMETERVARCHAR(64)

      Name of the parameter

      VALUEVARCHAR(64)

      Value of the parameter

    Displays NLS parameters of the current user session.

    • Columns

      Column NameData TypeDescription
      PARAMETERVARCHAR(64)

      Name of the parameter

      VALUEVARCHAR(64)

      Value of the parameter

    Displays all public synonyms in the database.

    • Columns

      Column NameData TypeDescription
      SYN_NAMEVARCHAR(128)

      Name of the synonym

      OBJ_OWNERVARCHAR(128)

      Owner of the object

      OBJ_NAMEVARCHAR(257)

      Name of the object

      OBJ_TYPEVARCHAR(9)

      Type of the object

    Displays the roles granted to other roles which the current user can access.

    • Columns

      Column NameData TypeDescription
      ROLEVARCHAR(128)

      Name of the role

      GRANTED_ROLEVARCHAR(128)

      Role that was granted

      ADMIN_OPTIONVARCHAR(3)

      Whether or not the role was assigned with ADMIN OPTION

      - YES

      - NO

      - ERR

    Displays system privileges granted to roles which the current user can access.

    • Columns

      Column NameData TypeDescription
      ROLEVARCHAR(128)

      Name of the role

      PRIVILEGEVARCHAR(40)

      Name of the privilege

      ADMIN_OPTIONVARCHAR(3)

      Whether or not the grant was assigned with ADMIN OPTION

      - YES

      - NO

      - ERR

    Displays object privileges granted to roles which the current user can access.

    • Columns

      Column NameData TypeDescription
      ROLEVARCHAR(128)

      Name of the role

      OWNERVARCHAR(128)

      Owner of the object

      TABLE_NAMEVARCHAR(128)

      Name of the object

      COLUMN_NAMEVARCHAR(128)

      Name of the column, if applicable

      PRIVILEGEVARCHAR(40)

      Object privilege granted to the role

      ADMIN_OPTIONVARCHAR(3)

      Whether or not the grant was assigned with ADMIN OPTION

      - YES

      - NO

      - ERR

    Displays context attributes in the current session.

    • Columns

      Column NameData TypeDescription
      NAMESPACEVARCHAR(128)

      The namespace of the context attribute

      ATTRIBUTEVARCHAR(128)

      The name of the attribute

      VALUEVARCHAR(65532)

      The value of the attribute

    Displays the system privileges granted to current session user.

    • Columns

      Column NameData TypeDescription
      PRIVILEGEVARCHAR(40)

      Name of the privilege

    Displays roles granted to the current session user.

    • Columns

      Column NameData TypeDescription
      ROLEVARCHAR(128)

      Name of the role

    Displays IDs and types of all schema objects, and IDs of the segment header blocks in the database.

    • Columns

      Column NameData TypeDescription
      OBJECT_TYPEVARCHAR(18)

      Type of the object

      OBJECT_TYPE_NONUMBER

      ID of the object's type

      SEGMENT_TYPE_NONUMBER

      ID of the segment's type

      OBJECT_IDNUMBER

      ID of the object

      HEADER_FILENUMBER

      ID of the data file containing the segment header

      HEADER_BLOCKNUMBER

      ID of the disk block containing the segment header

      TS_NUMBERNUMBER

      ID of the tablespace containing the object

      SEGMENT_IDNUMBER

      ID of the segment

    Displays all parameters of the procedure or function that the current user owns.

    Displays audit trails associated with the current user.

    Displays all tables, views, synonyms, and sequences that the current user owns.

    Displays all the collection types that the current user owns.

    Displays comments on all columns in the tables or views that the current user owns.

    Displays object privileges of the columns for which the current user is the object owner, grantor, or grantee.

    Displays columns for which the current user is the grantor.

    Displays columns for which the current user is the grantee.

    Displays constraints defined in the table that the current user owns.

    Displays columns that are owned by the current user and that are specified in integrity constraint definitions.

    Displays information for the database links that the current user owns.

    Displays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user owns.

    Displays information of all encrypted columns that the current user owns The columns are the same as those in ALL_ENCRYPTED_COLUMNS(except for OWNER)

    Displays the recent errors in every view, procedure, function, package, package body, trigger, library, and java object owned by current user. The columns are the same as those in ALL_ERRORS.(except for OWNER)

    Displays information of the extents contained in the segments that the current user owns.

    Displays all external table locations that the current user owns.

    Displays all external tables that the current user owns.

    Displays information of the extents available for the tablespaces that the current user can access.

    Displays index columns of all tables that the current user owns.

    Displays expressions on function-based index columns of all tables that the current user owns.

    Displays indexes of all tables that the current user owns.

    Synonym for USER_IDX_COLUMNS.

    Synonym for USER_IDX_EXPRESSIONS.

    Displays all parameters that the current user owns.

    Displays all classes that the current user owns.

    Displays all fields that the current user owns.

    Displays all methods that the current user owns.

    Displays all jobs that the current user owns.

    Displays all jobs with job name that the current user owns.

    Displays all libraries that the current user owns.

    Displays large objects (LOB) which belong to all tables that the current user owns.

    Displays all LOB partitions which belong to all tables that the current user owns.

    Displays all LOB subpartitions which belong to all tables that the current user owns.

    Displays the log group definitions on the tables owned by the current user.

    Displays columns that are owned by the current user and that are specified in log groups.

    Displays the method parameters of the type that the current user owns.

    Displays the result of the method of this type that the current user owns.

    Displays all materialized views that the current user owns. The columns are the same as those in ALL_MVIEWS.

    Displays comments on all materialized views that the current user owns.

    Displays all materialized view logs that the current user owns The columns are the same as those in ALL_MVIEW_LOGS.

    Describes refresh times of the materialized views owned by the current user.

    Displays all objects that the current user owns.

    Displays the current user's own objects which are being audited.

    Displays types of the package that the current user owns.

    Displays types of the package that the current user owns.

    Displays types of the package that the current user owns.

    Displays partitioning information for the partitioned indexes that the current user owns.

    Displays partitioning key columns for all partitioned tables or indexes that the current user owns.

    Displays LOBs which belong to the partitioned tables that the current user owns.

    Displays partitioning information of the partitioned tables that the current user owns.

    Displays all procedures that the current user owns.

    Describes the operational characteristics of every queue owned by the current user.

    Shows the list of subscribers on queues that are under the current user's schema.

    Describes the queues in the queue tables created in the current user's schema.

    Displays information of all temporarily deleted objects that the current user owns. The columns are the same as those in ALL_RECYCLEBIN.

    Displays roles granted to the current user.

    Displays all scheduler chains that the current user owns.

    Displays all scheduler jobs that the current user owns.

    Displays all scheduler job log that the current user owns.

    Displays all scheduler job run details that the current user owns.

    Displays all scheduler programs that the current user owns.

    Displays all scheduler rules that the current user owns.

    Displays all scheduler rule ctx that the current user owns.

    Displays all scheduler running jobs that the current user owns.

    Displays all scheduler schedules that the current user owns.

    Displays all scheduler steps that the current user owns.

    Displays all scheduler step context the current user owns.

    Displays all segments which belong to the current user.

    Displays all sequences that the current user owns.

    Displays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.

    Displays subpartitioning key columns of the partitioned tables or indexes that the current user owns.

    Displays synonyms that the current user owns.

    Displays system privileges granted to the current user.

    Displays all tables that the current user owns.

    Synonym for DBA_TABLESPACES.

    Synonym for USER_TBL_COLS.

    Synonym for USER_TBL_COLUMNS.

    Synonym for USER_TBL_COL_STATISTICS.

    Displays comments on all tables and views that the current user owns.

    Synonym for USER_TBL_HISTOGRAMS.

    Displays identity columns of all tables that the current user owns.

    Synonym for USER_TBL_PARTITIONS.

    Synonym for USER_TBL_PRIVS.

    Synonym for USER_TBL_PRIVS_MADE.

    Synonym for USER_TBL_PRIVS_RECD.

    Displays columns of all tables and views that the current user owns.

    Displays columns of all tables and views that the current user owns.

    Displays statistics and a histogram of columns by extracting them from USER_TBL_COLUMNS.

    Synonym for USER_TAB_COMMENTS.

    Displays histogram information of tables that the current user owns.

    Displays partition information of all tables that the current user owns.

    Displays object privileges granted on all tables for which the current user is the object owner, grantor, or grantee.

    Displays object privileges granted on tables for which the current user is the object owner.

    Displays object privileges granted on tables for which the current user is the object grantee.

    Displays all triggers that the current user owns.

    Displays column information of all triggers that the current user owns and all triggers on tables that the current user owns The columns are the same as those in ALL_TRIGGER_COLS.

    Displays all types that the current user owns.

    Displays all the attributes of this type that the current user owns.

    Displays all the methods of this type that the current user owns.

    Displays all join view columns that the current user can update.

    Displays a description on the current user.

    Displays all views that the current user owns.

    displays all subpartition templates that the current user can access.

    displays partitions of the indexes that the current user can access.

    synonym for all_idx_partitions.

    displays all index partitions in the database.

    synonym for dba_idx_partitions.

    displays all subpartition templates in the database.

    displays partitions of the indexes that the current user owns.

    synonym for user_idx_partitions.

    이전   다음
    제2장 데이터 사전 처음으로 제4장 Dynamic View