Chapter 3. Static View

Table of Contents

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

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.

Note

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 View	Description
ALL_ARGUMENTS	Displays all parameters of the procedure or function that the current user can call.
ALL_CATALOG	Displays all tables, views, synonyms, and sequences that the current user can access.
ALL_COLL_TYPES	Displays all the collection types that the current user can access.
ALL_COL_COMMENTS	Displays comments on columns of the tables or views that the current user can access.
ALL_COL_PRIVS	Displays columns for which the current user or public user is the object owner or grantor (user who granted the privilege).
ALL_COL_PRIVS_MADE	Displays columns for which the current user is the object owner or grantor.
ALL_COL_PRIVS_RECD	Displays columns for which the current user or public user is the grantee.
ALL_CONSTRAINTS	Displays constraints defined in the table that the current user can access.
ALL_CONS_COLUMNS	Displays columns that the current user can access and that are specified in integrity constraint definitions.
ALL_CONS_COLUMNS_INFO	Displays columns with constraint information that the current user can access and that are specified in integrity constraint definitions.
ALL_DB_LINKS	Displays information for the database links that the current user can use.
ALL_DEPENDENCIES	Displays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user can access.
ALL_DIRECTORIES	Displays all directories that the current user can access.
ALL_ENCRYPTED_COLUMNS	Displays information of all encrypted columns that the current user can access.
ALL_ERRORS	Displays the recent errors on every accessible view, procedure, function, package, package body, trigger, library, and java object.
ALL_EXTERNAL_LOCATIONS	Displays all external table locations that the current user can access.
ALL_EXTERNAL_TABLES	Displays all external tables that the current user can access.
ALL_IDX_AND_LOB_COLUMNS_INFO	Displays index columns (including LOB) with index information of all tables that the current user can access
ALL_IDX_COLUMNS	Displays index columns of all tables that the current user can access.
ALL_IDX_COLUMNS_INFO	Displays index columns with index information of all tables that the current user can access.
ALL_IDX_EXPRESSIONS	Displays expressions on function-based index columns of all tables that the current user can access.
ALL_IDX_PARTITIONS	Displays partitions of the indexes that the current user can access.
ALL_IDX_SUBPARTITIONS	Displays subpartitions of the index that the current user can access.
ALL_INDEXES	Displays indexes of all tables that the current user can access.
ALL_IND_COLUMNS	Synonym for ALL_IDX_COLUMNS.
ALL_IND_EXPRESSIONS	Synonym for ALL_IDX_EXPRESSIONS.
ALL_IND_PARTITIONS	Synonym for ALL_IDX_PARTITIONS.
ALL_IND_SUBPARTITIONS	Synonym for ALL_IDX_SUBPARTITIONS.
ALL_JAVA_ARGUMENTS	Displays all parameters that the current user can access.
ALL_JAVA_CLASSES	Displays all classes that the current user can access.
ALL_JAVA_FIELDS	Displays all fields that the current user can access.
ALL_JAVA_METHODS	Displays all methods that the current user can access.
ALL_JOBS	Displays all jobs that the current user can access.
ALL_LIBRARIES	Displays all libraries that the current user can access.
ALL_LOBS	Displays large objects (LOB) which belong to all tables that the current user can access.
ALL_LOB_PARTITIONS	Displays all LOB partitions that the current user can access.
ALL_LOB_SUBPARTITIONS	Displays LOB subpartitions that the current user can access.
ALL_LOG_GROUPS	Displays the log group definitions on the tables accessible to the current user.
ALL_LOG_GROUP_COLUMNS	Displays columns that are accessible to the current user and that are specified in log groups.
ALL_METHOD_PARAMS	Displays all the method parameters of the type that the current user can access.
ALL_METHOD_RESULTS	Displays the result of the method of this type that the current user can access.
ALL_MVIEWS	Displays all materialized views that the current user can access.
ALL_MVIEW_COMMENTS	Displays comments on the materialized views that the current user can access.
ALL_MVIEW_LOGS	Displays all materialized view logs that the current user can access.
ALL_OBJECTS	Displays all objects that the current user can access.
ALL_PACKAGE_MEMBER_TYPES	Displays types of the package that the current user can access.
ALL_PART_INDEXES	Displays partition information for the partitioned indexes that the current user can access.
ALL_PART_KEY_COLUMNS	Displays partitioning key columns of the partitioned tables or indexes that the current user can access.
ALL_PART_LOBS	Displays LOBs which belong to all partitioned tables that the current user can access.
ALL_PART_TABLES	Displays partitioning information of all partitioned tables that the current user can access.
ALL_PROCEDURES	Displays all procedures defined in all procedures and tables that the current user owns.
ALL_QUEUES	Describes all queues on which the current user has enqueue or dequeue privileges.
ALL_QUEUE_SUBSCRIBERS	Shows the list of subscribers that the current user has privilege to dequeue from.
ALL_QUEUE_TABLES	Describes the queues in the queue tables accessible to the current user.
ALL_RECYCLEBIN	Displays information of all temporarily deleted objects that the current user can access.
ALL_SCHEDULER_CHAINS	Displays all scheduler chains that the current user can access.
ALL_SCHEDULER_JOBS	Displays all scheduler jobs that the current user can access.
ALL_SCHEDULER_PROGRAMS	Displays all scheduler programs that the current user can access.
ALL_SCHEDULER_RULES	Displays all scheduler rules that the current user can access.
ALL_SCHEDULER_RULE_CTX	Displays all scheduler rule ctx that the current user can access.
ALL_SCHEDULER_RUNNING_JOBS	Displays all scheduler running jobs that the current user can access.
ALL_SCHEDULER_STEPS	Displays all scheduler steps that the current user can access.
ALL_SCHEDULER_STEP_CTX	Displays all scheduler step context the current user can access.
ALL_SEGMENTS	Displays all segments that the current user can access.
ALL_SEQUENCES	Displays all sequences that the current user can access.
ALL_SOURCE	Displays source texts of the stored objects that the current user can access such as procedures, functions, package bodies, or triggers.
ALL_SUBPART_KEY_COLUMNS	Displays subpartitioning key columns of the partitioned tables or indexes that the current user can access.
ALL_SYNONYMS	Displays all synonyms that the current user can access.
ALL_TABLES	Displays all tables that the current user can access.
ALL_TAB_COLS	Synonym for ALL_TBL_COLS.
ALL_TAB_COLUMNS	Synonym for ALL_TBL_COLUMNS.
ALL_TAB_COL_STATISTICS	Synonym for ALL_TBL_COL_STATISTICS.
ALL_TAB_COMMENTS	Displays comments on the tables that the current user can access.
ALL_TAB_HISTOGRAMS	Synonym for ALL_TBL_HISTOGRAMS.
ALL_TAB_PARTITIONS	Synonym for ALL_TBL_PARTITIONS.
ALL_TAB_PRIVS	Synonym for ALL_TBL_PRIVS.
ALL_TAB_PRIVS_MADE	Synonym for ALL_TBL_PRIVS_MADE.
ALL_TAB_PRIVS_RECD	Synonym for ALL_TBL_PRIVS_RECD.
ALL_TAB_SUBPARTITIONS	Synonym for ALL_TBL_SUBPARTITIONS.
ALL_TBL_COLS	Displays column information of all tables and views that the current user can access.
ALL_TBL_COLUMNS	Displays column information of all tables and views that the current user can access.
ALL_TBL_COLUMNS_WITH_DNO	Displays column information of all tables and views, which the current user can access, with data type number of the column.
ALL_TBL_COL_STATISTICS	Displays statistics and a histogram of columns by extracting them from ALL_TBL_COLUMNS.
ALL_TBL_COMMENTS	Synonym for ALL_TAB_COMMENTS.
ALL_TBL_HISTOGRAMS	Displays histogram information of tables that the current user can access.
ALL_TBL_PARTITIONS	Displays partition information of all tables that the current user can access.
ALL_TBL_PRIVS	Displays tables for which the current user or public user is granted object privileges.
ALL_TBL_PRIVS_MADE	Displays object privileges granted on tables for which the current user or public user is the object owner or grantor.
ALL_TBL_PRIVS_RECD	Displays object privileges granted on tables for which the current user or public user is the object grantee.
ALL_TBL_SUBPARTITIONS	Displays subpartitions of all tables that the current user can access.
ALL_TRIGGERS	Displays all triggers that the current user can access.
ALL_TRIGGER_COLS	Displays column information of all triggers that the current user can access and all triggers on tables that the current user can access.
ALL_TYPES	Displays all types that the current user can access.
ALL_TYPE_ATTRS	Displays all the attributes that the current user can access.
ALL_TYPE_METHODS	Displays all the methods of this type that the current user can access.
ALL_UPDATABLE_COLUMNS	Displays all join view columns that the current user can update.
ALL_USERS	Displays all users that the current user can view.
ALL_VIEWS	Displays all views that the current user can access.
ALL_VIEWS_INTERNAL	Displays all views that the current user can access. (including views that can be accessed by the roles)
DATABASE_PROPERTIES	Displays database properties.
DBA_2PC_NEIGHBORS	Displays connection information for pending transactions.
DBA_2PC_PENDING	Displays pending transaction information.
DBA_AUDIT_TRAIL	Displays audit trails within the database.
DBA_CATALOG	Displays all tables, views, synonyms, and sequences in the database.
DBA_COLL_TYPES	Displays all the collection types.
DBA_COL_COMMENTS	Displays comments on all columns in the database.
DBA_COL_PRIVS	Displays object privileges of all columns of the database.
DBA_CONSTRAINTS	Displays integrity constraints defined in the database table.
DBA_CONS_COLUMNS	Displays the columns for which the database integrity constraint is specified.
DBA_DATAFILES	Synonym for DBA_DATA_FILES.
DBA_DATA_FILES	Displays data file information.
DBA_DB_LINKS	Displays information for all database links.
DBA_DEPENDENCIES	Displays dependencies of all objects.
DBA_DIRECTORIES	Displays all directories in the database.
DBA_ENCRYPTED_COLUMNS	Displays information of all encrypted columns in the database. The columns are the same as those in ALL_ENCRYPTED_COLUMNS.
DBA_ERRORS	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.
DBA_EXTENTS	Displays information of the extents contained in the segments of all the tablespaces in the database.
DBA_EXTERNAL_LOCATIONS	Displays all external table locations in the database.
DBA_EXTERNAL_TABLES	Displays all external tables in the database.
DBA_FREE_SPACE	Displays information of the extents that all tablespaces can use.
DBA_HIST_ACTIVE_SESS_HISTORY	Displays history information on active sessions.
DBA_HIST_FILESTAT	Displays historical statistics of data file and temp file I/O. This view includes snapshots of V$ALL_FILESTAT.
DBA_HIST_LATCH	Displays the historical information on spinlocks. This view includes snapshots of V$LATCH.
DBA_HIST_LIBRARYCACHE	Displays information of PP cache and DD cache. This view includes snapshots of V$LIBRARYCACHE.
DBA_HIST_OSSTAT	Displays historical information on various OS statistics. This view includes snapshots of V$OSSTAT2.
DBA_HIST_PGASTAT	Displays the historical statistics of PGA. This view includes the snapshot of V$PGASTAT.
DBA_HIST_PROCESS_MEM_SUMMARY	Displays historical information on PGA memory usage. This view gets information from V$PROCESS.
DBA_HIST_SEG_STAT	Displays historical information of segment-level statistics. This view includes snapshots of V$SEGMENT_STATISTICS.
DBA_HIST_SGASTAT	Displays the historical information on the shared pool for a database. This view includes snapshots of V$SGASTAT.
DBA_HIST_SNAPSHOT	Displays information about TPR snapshots.
DBA_HIST_SQLSTAT	Displays historical information for SQL statistics. This view displays the priority of items of specific criteria.
DBA_HIST_SQLTEXT	Displays historical information about texts of SQL statements.
DBA_HIST_SQL_PLAN	Displays historical information about SQL execution plans. This view includes snapshots of V$SQL_PLAN.
DBA_HIST_SQL_WORKAREA_HSTGRM	Displays historical information about work areas used by SQl cursors. This view includes snapshots of V$SQL_WORKAREA_HISTOGRAM.
DBA_HIST_SYSMETRIC_SUMMARY	Displays a history of statistical summary of all metric values in the System Metrics Long Duration group.
DBA_HIST_SYSTEM_EVENT	Displays historical information of events performing in the system. This view includes snapshots of V$SYSTEM_EVENT.
DBA_HIST_UNDOSTAT	Displays historical statistics of undo storage space. This view includes snapshots of V$UNDOSTAT.
DBA_HIST_WAITSTAT	Displays the statistical history of block wait events for each block type and class. This view includes snapshots of V$WAITSTAT.
DBA_IDX_COLUMNS	Displays index columns of all tables in the database.
DBA_IDX_EXPRESSIONS	Displays expressions on the index columns of all tables in the database.
DBA_IDX_PARTITIONS	Displays all index partitions in the database.
DBA_IDX_SUBPARTITIONS	Displays subpartitions of all indexes in the database.
DBA_INDEXES	Displays indexes of all tables in the database.
DBA_IND_COLUMNS	Synonym for DBA_IDX_COLUMNS.
DBA_IND_EXPRESSIONS	Synonym for DBA_IDX_EXPRESSIONS.
DBA_IND_PARTITIONS	Synonym for DBA_IDX_PARTITIONS.
DBA_IND_SUBPARTITIONS	Synonym for DBA_IDX_SUBPARTITIONS.
DBA_JAVA_ARGUMENTS	Displays all parameters in the database.
DBA_JAVA_CLASSES	Displays all classes in the database.
DBA_JAVA_FIELDS	Displays all fields in the database.
DBA_JAVA_METHODS	Displays all methods in the database.
DBA_JOBS	Displays all jobs in the database.
DBA_LIBRARIES	Displays all libraries in the database.
DBA_LOBS	Displays LOBs which belong to all tables in the database.
DBA_LOB_PARTITIONS	Displays all LOB partitions in the database.
DBA_LOB_SUBPARTITIONS	Displays all LOB subpartitions in the database.
DBA_LOG_GROUPS	Displays the log group definitions on all tables in the database.
DBA_LOG_GROUP_COLUMNS	Displays all columns in the database that are specified in log groups.
DBA_METHOD_PARAMS	Displays the method parameters of this type.
DBA_METHOD_RESULTS	Displays the result of the method of this type.
DBA_MVIEWS	Displays all materialized views in the database. The columns are the same as those in ALL_MVIEWS.
DBA_MVIEW_COMMENTS	Displays comments on all materialized views in the database. The columns are the same as those in ALL_MVIEW_COMMENTS.
DBA_MVIEW_LOGS	Displays all materialized view logs in the database. The columns are the same as those in ALL_MVIEW_LOGS.
DBA_OBJECTS	Displays all objects in the database.
DBA_OBJ_AUDIT_OPTS	Displays objects being audited in the database.
DBA_PACKAGE_MEMBER_TYPES	Displays types of the package.
DBA_PART_INDEXES	Displays partitioning information for the partitioned indexes in the database.
DBA_PART_KEY_COLUMNS	Displays partitioning key columns for all partitioned tables or indexes in the database.
DBA_PART_LOBS	Displays LOBs which belong to the partitioned tables in the database.
DBA_PART_TABLES	Displays partitioning information of the partitioned tables in the database.
DBA_PRIV_AUDIT_OPTS	Displays users being audited in the database.
DBA_PROCEDURES	Displays all procedures in the database.
DBA_PROFILES	Describes all profiles in the database.
DBA_QUEUES	Describes all queues in the database.
DBA_QUEUE_SUBSCRIBERS	Shows the list of subscribers on all queues in the database.
DBA_QUEUE_TABLES	Describes the queues in all queue tables in the database.
DBA_RECYCLEBIN	Displays information of all temporarily deleted objects in the database. The columns are the same as those in ALL_RECYCLEBIN.
DBA_REDEFINITION_OBJECTS	Displays all objects in database which are being redefined online.
DBA_ROLES	Displays all roles in the database.
DBA_ROLE_PRIVS	Displays roles granted to the users in the database.
DBA_ROLLBACK_SEGS	Synonym for DBA_UNDO_SGMTS.
DBA_RSRC_AUDIT	Displays change history of resource plan.
DBA_RSRC_CONSUMER_GROUPS	Displays all resource consumer groups in the database.
DBA_RSRC_PLANS	Displays all resource plans in the database.
DBA_RSRC_PLAN_DIRECTIVES	Displays all resource plan directives in the database.
DBA_SCHEDULER_CHAINS	Displays all scheduler chains in the database.
DBA_SCHEDULER_JOBS	Displays all scheduler jobs in the database.
DBA_SCHEDULER_PROGRAMS	Displays all scheduler programs in the database.
DBA_SCHEDULER_RULES	Displays all scheduler rules in the database.
DBA_SCHEDULER_RULE_CTX	Displays all scheduler rule ctx in the database.
DBA_SCHEDULER_RUNNING_JOBS	Displays all scheduler running jobs in the database.
DBA_SCHEDULER_STEPS	Displays all scheduler steps in the database.
DBA_SCHEDULER_STEP_CTX	Displays all scheduler step context in the database.
DBA_SEGMENTS	Displays all segments in the database.
DBA_SEQUENCES	Displays all sequences in the database.
DBA_SOURCE	Displays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.
DBA_SUBPART_KEY_COLUMNS	Displays subpartitioning key columns of the partitioned tables or indexes in the database.
DBA_SYNONYMS	Displays synonyms in the database.
DBA_SYS_PRIVS	Displays system privileges granted to users and roles in the database.
DBA_TABLES	Displays all tables in the database.
DBA_TABLESPACES	Displays all tablespaces in the database.
DBA_TAB_COLS	Synonym for DBA_TBL_COLS.
DBA_TAB_COLUMNS	Synonym for DBA_TBL_COLUMNS.
DBA_TAB_COL_STATISTICS	Synonym for DBA_TBL_COL_STATISTICS.
DBA_TAB_COMMENTS	Displays comments on all tables and views in the database.

Static View	Description
DBA_TAB_HISTOGRAMS	Synonym for DBA_TBL_HISTOGRAMS.
DBA_TAB_PARTITIONS	Synonym for DBA_TBL_PARTITIONS.
DBA_TAB_PRIVS	Synonym for DBA_TBL_PRIVS.
DBA_TAB_SUBPARTITIONS	Synonym for DBA_TBL_SUBPARTITIONS.
DBA_TBL_COLS	Displays columns of all tables and views in the database.
DBA_TBL_COLUMNS	Displays columns of all tables and views in the database.
DBA_TBL_COL_STATISTICS	Displays statistics and a histogram of columns by extracting them from DBA_TBL_COLUMNS.
DBA_TBL_COMMENTS	Synonym for DBA_TAB_COMMENTS.
DBA_TBL_HISTOGRAMS	Displays histogram information on tables and views in the database.
DBA_TBL_PARTITIONS	Displays partition information of all tables in the database.
DBA_TBL_PRIVS	Displays object privileges granted on all tables in the database.
DBA_TBL_SUBPARTITIONS	Displays subpartitions of all tables in the database.
DBA_TEMPFILES	Synonym for DBA_TEMP_FILES.
DBA_TEMP_FILES	Displays information of the temporary data files.
DBA_TRIGGERS	Displays all triggers in the database.
DBA_TRIGGER_COLS	Displays column information of all triggers in the database. The columns are the same as those in ALL_TRIGGER_COLS.
DBA_TS_QUOTAS	Describe tablespace quotas for all user
DBA_TYPES	Displays all types.
DBA_TYPE_ATTRS	Displays all the attributes of this type.
DBA_TYPE_METHODS	Displays all the methods of this type.
DBA_UNDO_EXTENTS	Displays information about the extents in all undo segments.
DBA_UNDO_SGMTS	Displays undo segments in the database.
DBA_UPDATABLE_COLUMNS	Displays all join view columns that the DBA can update.
DBA_USERS	Displays all users in the database.
DBA_VIEWS	Displays all views in the database.
DICTIONARY	Displays comments on tables and views in the data dictionary.
NLS_SESSION_PARAMETERS	Displays NLS parameters of the current user session.
PUBLICSYN	Displays all public synonyms in the database.
ROLE_ROLE_PRIVS	Displays the roles granted to other roles which the current user can access.
ROLE_SYS_PRIVS	Displays system privileges granted to roles which the current user can access.
ROLE_TAB_PRIVS	Displays object privileges granted to roles which the current user can access.
SESSION_CONTEXT	Displays context attributes in the current session.
SESSION_PRIVS	Displays the system privileges granted to current session user.
SESSION_ROLES	Displays roles granted to the current session user.
SYS_OBJECTS	Displays IDs and types of all schema objects, and IDs of the segment header blocks in the database.
USER_ARGUMENTS	Displays all parameters of the procedure or function that the current user owns.
USER_AUDIT_TRAIL	Displays audit trails associated with the current user.
USER_CATALOG	Displays all tables, views, synonyms, and sequences that the current user owns.
USER_COLL_TYPES	Displays all the collection types that the current user owns.
USER_COL_COMMENTS	Displays comments on all columns in the tables or views that the current user owns.
USER_COL_PRIVS	Displays object privileges of the columns for which the current user is the object owner, grantor, or grantee.
USER_COL_PRIVS_MADE	Displays columns for which the current user is the grantor.
USER_COL_PRIVS_RECD	Displays columns for which the current user is the grantee.
USER_CONSTRAINTS	Displays constraints defined in the table that the current user owns.
USER_CONS_COLUMNS	Displays columns that are owned by the current user and that are specified in integrity constraint definitions.
USER_DB_LINKS	Displays information for the database links that the current user owns.
USER_DEPENDENCIES	Displays dependencies between procedures, functions, packages, package bodies, triggers, and views that the current user owns.
USER_ENCRYPTED_COLUMNS	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)
USER_ERRORS	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)
USER_EXTENTS	Displays information of the extents contained in the segments that the current user owns.
USER_EXTERNAL_LOCATIONS	Displays all external table locations that the current user owns.
USER_EXTERNAL_TABLES	Displays all external tables that the current user owns.
USER_FREE_SPACE	Displays information of the extents available for the tablespaces that the current user can access.
USER_IDX_COLUMNS	Displays index columns of all tables that the current user owns.
USER_IDX_EXPRESSIONS	Displays expressions on function-based index columns of all tables that the current user owns.
USER_IDX_PARTITIONS	Displays partitions of the indexes that the current user owns.
USER_INDEXES	Displays indexes of all tables that the current user owns.
USER_IND_COLUMNS	Synonym for USER_IDX_COLUMNS.
USER_IND_EXPRESSIONS	Synonym for USER_IDX_EXPRESSIONS.
USER_IND_PARTITIONS	Synonym for USER_IDX_PARTITIONS.
USER_JAVA_ARGUMENTS	Displays all parameters that the current user owns.
USER_JAVA_CLASSES	Displays all classes that the current user owns.
USER_JAVA_FIELDS	Displays all fields that the current user owns.
USER_JAVA_METHODS	Displays all methods that the current user owns.
USER_JOBS	Displays all jobs that the current user owns.
USER_LIBRARIES	Displays all libraries that the current user owns.
USER_LOBS	Displays large objects (LOB) which belong to all tables that the current user owns.
USER_LOB_PARTITIONS	Displays all LOB partitions which belong to all tables that the current user owns.
USER_LOB_SUBPARTITIONS	Displays all LOB subpartitions which belong to all tables that the current user owns.
USER_LOG_GROUPS	Displays the log group definitions on the tables owned by the current user.
USER_LOG_GROUP_COLUMNS	Displays columns that are owned by the current user and that are specified in log groups.
USER_METHOD_PARAMS	Displays the method parameters of the type that the current user owns.
USER_METHOD_RESULTS	Displays the result of the method of this type that the current user owns.
USER_MVIEWS	Displays all materialized views that the current user owns. The columns are the same as those in ALL_MVIEWS.
USER_MVIEW_COMMENTS	Displays comments on all materialized views that the current user owns.
USER_MVIEW_LOGS	Displays all materialized view logs that the current user owns The columns are the same as those in ALL_MVIEW_LOGS.
USER_OBJECTS	Displays all objects that the current user owns.
USER_OBJ_AUDIT_OPTS	Displays the current user's own objects which are being audited.
USER_PACKAGE_MEMBER_TYPES	Displays types of the package that the current user owns.
USER_PART_INDEXES	Displays partitioning information for the partitioned indexes that the current user owns.
USER_PART_KEY_COLUMNS	Displays partitioning key columns for all partitioned tables or indexes that the current user owns.
USER_PART_LOBS	Displays LOBs which belong to the partitioned tables that the current user owns.
USER_PART_TABLES	Displays partitioning information of the partitioned tables that the current user owns.
USER_PROCEDURES	Displays all procedures that the current user owns.
USER_QUEUES	Describes the operational characteristics of every queue owned by the current user.
USER_QUEUE_SUBSCRIBERS	Shows the list of subscribers on queues that are under the current user's schema.
USER_QUEUE_TABLES	Describes the queues in the queue tables created in the current user's schema.
USER_RECYCLEBIN	Displays information of all temporarily deleted objects that the current user owns. The columns are the same as those in ALL_RECYCLEBIN.
USER_ROLE_PRIVS	Displays roles granted to the current user.
USER_SCHEDULER_CHAINS	Displays all scheduler chains that the current user owns.
USER_SCHEDULER_JOBS	Displays all scheduler jobs that the current user owns.
USER_SCHEDULER_PROGRAMS	Displays all scheduler programs that the current user owns.
USER_SCHEDULER_RULES	Displays all scheduler rules that the current user owns.
USER_SCHEDULER_RULE_CTX	Displays all scheduler rule ctx that the current user owns.
USER_SCHEDULER_RUNNING_JOBS	Displays all scheduler running jobs that the current user owns.
USER_SCHEDULER_STEPS	Displays all scheduler steps that the current user owns.
USER_SCHEDULER_STEP_CTX	Displays all scheduler step context the current user owns.
USER_SEGMENTS	Displays all segments which belong to the current user.
USER_SEQUENCES	Displays all sequences that the current user owns.
USER_SOURCE	Displays source texts of the stored objects in the database such as procedures, functions, package bodies, or triggers.
USER_SUBPART_KEY_COLUMNS	Displays subpartitioning key columns of the partitioned tables or indexes that the current user owns.
USER_SYNONYMS	Displays synonyms that the current user owns.
USER_SYS_PRIVS	Displays system privileges granted to the current user.
USER_TABLES	Displays all tables that the current user owns.
USER_TABLESPACES	Synonym for DBA_TABLESPACES.
USER_TAB_COLS	Synonym for USER_TBL_COLS.
USER_TAB_COLUMNS	Synonym for USER_TBL_COLUMNS.
USER_TAB_COL_STATISTICS	Synonym for USER_TBL_COL_STATISTICS.
USER_TAB_COMMENTS	Displays comments on all tables and views that the current user owns.
USER_TAB_HISTOGRAMS	Synonym for USER_TBL_HISTOGRAMS.
USER_TAB_PARTITIONS	Synonym for USER_TBL_PARTITIONS.
USER_TAB_PRIVS	Synonym for USER_TBL_PRIVS.
USER_TAB_PRIVS_MADE	Synonym for USER_TBL_PRIVS_MADE.
USER_TAB_PRIVS_RECD	Synonym for USER_TBL_PRIVS_RECD.
USER_TBL_COLS	Displays columns of all tables and views that the current user owns.
USER_TBL_COLUMNS	Displays columns of all tables and views that the current user owns.
USER_TBL_COL_STATISTICS	Displays statistics and a histogram of columns by extracting them from USER_TBL_COLUMNS.
USER_TBL_COMMENTS	Synonym for USER_TAB_COMMENTS.
USER_TBL_HISTOGRAMS	Displays histogram information of tables that the current user owns.
USER_TBL_PARTITIONS	Displays partition information of all tables that the current user owns.
USER_TBL_PRIVS	Displays object privileges granted on all tables for which the current user is the object owner, grantor, or grantee.
USER_TBL_PRIVS_MADE	Displays object privileges granted on tables for which the current user is the object owner.
USER_TBL_PRIVS_RECD	Displays object privileges granted on tables for which the current user is the object grantee.
USER_TRIGGERS	Displays all triggers that the current user owns.
USER_TRIGGER_COLS	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.
USER_TYPES	Displays all types that the current user owns.
USER_TYPE_ATTRS	Displays all the attributes of this type that the current user owns.
USER_TYPE_METHODS	Displays all the methods of this type that the current user owns.
USER_UPDATABLE_COLUMNS	Displays all join view columns that the current user can update.
USER_USERS	Displays a description on the current user.
USER_VIEWS	Displays all views that the current user owns.

3.2.1. ALL_ARGUMENTS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the procedure or function
OBJECT_NAME	VARCHAR(128)	Name of the procedure or function
PACKAGE_NAME	VARCHAR(128)	Name of the package
OBJECT_ID	NUMBER	ID of the package which contains the procedure or function
ARGUMENT_NAME	VARCHAR(128)	Name of the parameter
OVERLOAD	NUMBER	Identifier of the overloaded function
POSITION	NUMBER	Position of the parameter (NULL for function return values)
DATA_TYPE	VARCHAR(65532)	Data type of the parameter
DATA_TYPE_NO	NUMBER	Data type number of the parameter
IN_OUT	VARCHAR(9)	Direction of the parameter - IN - OUT - IN/OUT
DATA_LENGTH	NUMBER	Length of the column
DATA_PRECISION	NUMBER	Precision of the column
DATA_SCALE	NUMBER	Scale of the column
NULLABLE	VARCHAR(3)	Whether NULL values are allowed or not
TYPE_OWNER	VARCHAR(128)	Owner of the parameter type
TYPE_NAME	VARCHAR(128)	Name of the parameter type (Package name for the package local type)
TYPE_SUBNAME	VARCHAR(128)	Name of the type defined in the package (Only for the package local type)

See also

USER_ARGUMENTS

3.2.2. ALL_CATALOG

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
TABLE_NAME	VARCHAR(128)	Name of the object
OBJECT_TYPE	VARCHAR(23)	Type of the object - TABLE - VIEW - SYNONYM - SEQUENCE

See also

DBA_CATALOG

USER_CATALOG

3.2.3. ALL_COLL_TYPES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
COLL_TYPE	VARCHAR(13)	Type of this collection type
UPPER_BOUND	NUMBER	Maximum array size (Only applicable to VARYING ARRAY)
ELEM_TYPE_MOD	VARCHAR(7)	Modifier of this element type (not supported)
ELEM_TYPE_OWNER	VARCHAR(128)	Owner of this element type
ELEM_TYPE_NAME	VARCHAR(65532)	Name of this element type
LENGTH	NUMBER	Length of this element type (not supported)
PRECISION	NUMBER	Precision of this element type
SCALE	NUMBER	Scale of this element type
CHARACTER_SET_NAME	VARCHAR(128)	Name of the Character set (not supported)
ELEM_STORAGE	NUMBER	(not supported)
NULLS_STORED	VARCHAR(3)	(not supported)

See also

DBA_COLL_TYPES

USER_COLL_TYPES

3.2.4. ALL_COL_COMMENTS

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

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the object
TABLE_NAME VARCHAR(128)
Name of the object
COLUMN_NAME VARCHAR(128)
Name of the column
COMMENTS VARCHAR(4000)
Comment of the column
See also

DBA_COL_COMMENTS

USER_COL_COMMENTS

3.2.5. ALL_COL_PRIVS

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the column
GRANTABLE	VARCHAR(3)	Whether privilege was granted with ADMIN OPTION or not - YES - NO

See also

DBA_COL_PRIVS

USER_COL_PRIVS

3.2.6. ALL_COL_PRIVS_MADE

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the column
GRANTABLE	VARCHAR(3)	Whether privilege was granted with ADMIN OPTION or not - YES - NO

See also

USER_COL_PRIVS_MADE

3.2.7. ALL_COL_PRIVS_RECD

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the column
GRANTABLE	VARCHAR(3)	Whether privilege was granted with ADMIN OPTION or not - YES - NO

See also

USER_COL_PRIVS_RECD

3.2.8. ALL_CONSTRAINTS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the constraint
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint
CON_TYPE	VARCHAR(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
CONSTRAINT_TYPE	VARCHAR(1)	Type of the constraint - C: CHECK, NOT NULL constraint - P: PRIMARY KEY constraint - U: UNIQUE constraint - R: REFERENTIAL constraint - O: READ ONLY VIEW constraint - V: VIEW WITH CHECK OPTION constraint
TABLE_NAME	VARCHAR(128)	Name of the table or view for which constraints are defined
SEARCH_CONDITION	VARCHAR(65532)	Search condition for CHECK constraint
R_OWNER	VARCHAR(128)	Owner of the table that is referred to by referential constraint
R_CONSTRAINT_NAME	VARCHAR(128)	Name of the primary key or unique key constraint defined in the table to be referred
DELETE_RULE	VARCHAR(9)	Delete rule for the referential constraint - CASCADE - SET NULL - NO ACTION
VALIDATED	VARCHAR(13)	All data obeys the constraint or not
GENERATED	VARCHAR(14)	Whether the name of the constraint indicates the user or the generated system
STATUS	VARCHAR(8)	Current status - ENABLED - DISABLED
DEFERRABLE	VARCHAR(14)	Indicates whether the constraint is deferrable or not
DEFERRED	VARCHAR(9)	Indicates whether the constraint is initially deferred or not
INDEX_OWNER	VARCHAR(128)	Owner of the index used by the constraint
INDEX_NAME	VARCHAR(128)	Name of the index used by the constraint

See also

DBA_CONSTRAINTS

USER_CONSTRAINTS

3.2.9. ALL_CONS_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the constraint
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint
TABLE_NAME	VARCHAR(128)	Name of the table for which the constraint is defined
COLUMN_NAME	VARCHAR(128)	Name of the column defined in constraint definition
POSITION	NUMBER	Position of the column

See also

DBA_CONS_COLUMNS

USER_CONS_COLUMNS

3.2.10. ALL_CONS_COLUMNS_INFO

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the constraint
CON_ID	VARCHAR(128)	Constraint id
CONSTRAINT_NAME	VARCHAR(128)	Name of the constraint
TABLE_NAME	VARCHAR(128)	Name of the table for which the constraint is defined
COLUMN_NAME	VARCHAR(128)	Name of the column defined in constraint definition
POSITION	NUMBER	Position of the column
CON_TYPE	VARCHAR(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_RULE	VARCHAR(9)	Delete rule for the referential constraint - CASCADE - SET NULL - NO ACTION
REF_CON_ID	NUMBER	Constraint id of the primary key or unique key constraint defined in the table to be referred to

3.2.11. ALL_DB_LINKS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the database link
DB_LINK	VARCHAR(128)	Name of the database link
USERNAME	VARCHAR(128)	User ID of the database link
HOST	VARCHAR(128)	Name of the remote database
CREATED	DATE	Database creation time

See also

DBA_DB_LINKS

USER_DB_LINKS

3.2.12. ALL_DEPENDENCIES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
NAME	VARCHAR(128)	Name of the object
TYPE	VARCHAR(12)	Type of the object - INDEX - TABLE - VIEW - SYNONYM - SEQUENCE - PROCEDURE - FUNCTION - PACKAGE - NON-EXISTENT - PACKAGE BODY - TRIGGER - UNDEFINED - DIRECTORY - LIBRARY - MATERIALIZED VIEW - JAVA - TYPE - TYPE BODY - OPERATOR - INDEXTYPE
PARENT_OBJ_OWNER	VARCHAR(128)	Owner of the parent object
PARENT_OBJ_NAME	VARCHAR(128)	Name of the parent object
PARENT_OBJ_TYPE	VARCHAR(12)	Type of the parent object

See also

DBA_DEPENDENCIES

USER_DEPENDENCIES

3.2.13. ALL_DIRECTORIES

Displays all directories that the current user can access.

Columns

Column Name Data Type Description
NAME VARCHAR(128)
Name of the directory
PATH VARCHAR(4000)
Path to the directory
See also

DBA_DIRECTORIES

Column Name	Data Type	Description
NAME	VARCHAR(128)	Name of the directory
PATH	VARCHAR(4000)	Path to the directory

3.2.14. ALL_ENCRYPTED_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
ENCRYPTION_ALG	VARCHAR(29)	Encryption algorithm used for the encrypted column
SALT	VARCHAR(3)	Whether the SALT option was used for the encrypted column - Y: Salt option used - N: Salt option not used

See also

DBA_ENCRYPTED_COLUMNS

USER_ENCRYPTED_COLUMNS

3.2.15. ALL_ERRORS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
NAME	VARCHAR(128)	Name of the object
TYPE	VARCHAR(12)	Type of the object ('VIEW', PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY', 'TRIGGER', 'LIBRARY', 'JAVA', 'UNDEFINED')
SEQUENCE	NUMBER	Serial number of the error
LINE	NUMBER	Line number of the error
POSITION	NUMBER	Position in the line of the error
TEXT	VARCHAR(4000)	Error description
ATTRIBUTE	VARCHAR(9)	Type of the error ('ERROR', 'WARNING', 'UNDEFINED')
MESSAGE_NUMBER	NUMBER	Error number

See also

DBA_ERRORS

USER_ERRORS

3.2.16. ALL_EXTERNAL_LOCATIONS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the external table location
TABLE_NAME	VARCHAR(128)	Name of the external table location
DIRECTORY_NAME	VARCHAR(30)	Name of the directory of the external table location
LOCATION	VARCHAR(4000)	External table location

See also

DBA_EXTERNAL_LOCATIONS

USER_EXTERNAL_LOCATIONS

3.2.17. ALL_EXTERNAL_TABLES

Displays all external tables that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the external table
TABLE_NAME	VARCHAR(128)	Name of the external table
DEFAULT_DIRECTORY_NAME	VARCHAR(30)	Name of the default directory of the external table
ACCESS_PARAMETERS	LONG	Access parameter of the external table

See also

DBA_EXTERNAL_TABLES

USER_EXTERNAL_TABLES

3.2.18. ALL_IDX_AND_LOB_COLUMNS_INFO

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

Columns

Column Name	Data Type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
INDEX_TYPE	VARCHAR	Index type (string)
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column

3.2.19. ALL_IDX_COLUMNS

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

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_LENGTH	NUMBER	Length of the column within the index
DESCEND	VARCHAR(4)	Sorting order in columns - DESC - ASC

See also

ALL_IND_COLUMNS

DBA_IDX_COLUMNS

DBA_IND_COLUMNS

USER_IDX_COLUMNS

USER_IND_COLUMNS

3.2.20. ALL_IDX_COLUMNS_INFO

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

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
UNIQUENESS	VARCHAR(9)	Whether or not the unique key is indexed. - NONUNIQUE - UNIQUE - UNDEFINED
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_LENGTH	NUMBER	Length of the column within the index
DESCEND	VARCHAR(4)	Sorting order in columns - DESC - ASC

3.2.21. ALL_IDX_EXPRESSIONS

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

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_EXPRESSION	LONG	Expression of the column within the index

See also

ALL_IND_EXPRESSIONS

DBA_IDX_EXPRESSIONS

DBA_IND_EXPRESSIONS

USER_IDX_EXPRESSIONS

USER_IND_EXPRESSIONS

3.2.22. ALL_IDX_PARTITIONS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
COMPOSITE	VARCHAR(3)	Whether or not partition belongs to a composite-partitioned index - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the partition
SUBPARTITION_COUNT	NUMBER	The number of the subpartitions that belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the index
BLEVEL	NUMBER	Level of B-tree index (The level is 0 for a B-tree with only a root node)
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
CLUSTERING_FACTOR	NUMBER	The clustering factor of the index
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
NUM_ROWS	NUMBER	The number of rows in the index
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_TRANS	NUMBER	Value of the MAX_TRANS parameter
INITIAL_EXTENT	NUMBER	Value of the INITIAL_EXTENT parameter
MIN_EXTENT	NUMBER	Value of the MIN_EXTENT parameter
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
LAST_ANALYZED	DATE	Date of the most recent analysis for the index partition

See also

ALL_IND_PARTITIONS

DBA_IDX_PARTITIONS

DBA_IND_PARTITIONS

USER_IDX_PARTITIONS

USER_IND_PARTITIONS

3.2.23. ALL_IDX_SUBPARTITIONS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
PARTITION_NAME	VARCHAR(128)	Name of the index partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the index subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows in the index subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the subpartition

See also

ALL_IND_SUBPARTITIONS

DBA_IDX_SUBPARTITIONS

DBA_IND_SUBPARTITIONS

3.2.24. ALL_INDEXES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
INDEX_TYPE	VARCHAR(25)	Type of the index - NORMAL - FUNCTION-BASED - LOB
TABLE_OWNER	VARCHAR(128)	Owner of the indexed object
TABLE_NAME	VARCHAR(128)	The indexed object
TABLE_TYPE	CHAR(9)	Type of the indexed object - INDEX - TABLE - VIEW - SYNONYM - UNDEFINED
UNIQUENESS	VARCHAR(9)	Whether or not the unique key is indexed. - NONUNIQUE - UNIQUE - UNDEFINED
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the index
INI_TRANS	NUMBER	Value of the INITRANS parameter
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INITIAL_EXTENT	NUMBER	Size of the initial extent
NEXT_EXTENT	NUMBER	Size of the next extent
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
BLEVEL	NUMBER	Level of B-tree index (The level is 0 for a B-tree with only a root node)
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
CLUSTERING_FACTOR	NUMBER	The clustering factor of the index
STATUS	VARCHAR(8)	Indicates whether a nonpartitioned index is USABLE or UNUSABLE, or that a partitioned index is USABLE only when all partitions of the index are USABLE.
NUM_ROWS	NUMBER	The number of rows in the index
LAST_ANALYZED	DATE	Date of the most recent analysis for the table
PARTITIONED	VARCHAR(3)	Whether or not the index is partitioned - YES - NO
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
GENERATED_BY_SYSTEM	VARCHAR(1)	Whether or not the name of the index was generated in the system - Y - N
REFERENTIAL	VARCHAR(3)	Whether the index was automatically generated for corresponding referential integrity constraints
MAX_EXTENTS	NUMBER	Maximum number of extents that the index can use
INCLUDE_COLUMN	NUMBER	ID of the last column to be included in the primary key index of the index-organized table
MIN_EXTENTS	NUMBER	Minimum number of extents that the index can use
PCT_THRESHOLD	NUMBER	Percentage of the block space allowed per index entry.
VISIBILITY	VARCHAR(9)	Visibility property of an index.
PARAMETERS	VARCHAR(30)	(Not supported)
DOMIDX_STATUS	VARCHAR(12)	(Not supported)
DOMIDX_OPSTATUS	VARCHAR(6)	(Not supported)
DOMIDX_MANAGEMENT	VARCHAR2(14)	(Not supported)

See also

DBA_INDEXES

USER_INDEXES

3.2.25. ALL_IND_COLUMNS

Synonym for ALL_IDX_COLUMNS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_LENGTH	NUMBER	Length of the column within the index
DESCEND	VARCHAR(4)	Sorting order in columns - DESC - ASC

See also

ALL_IDX_COLUMNS

DBA_IDX_COLUMNS

DBA_IND_COLUMNS

USER_IDX_COLUMNS

USER_IND_COLUMNS

3.2.26. ALL_IND_EXPRESSIONS

Synonym for ALL_IDX_EXPRESSIONS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_EXPRESSION	LONG	Expression of the column within the index

See also

ALL_IDX_EXPRESSIONS

DBA_IDX_EXPRESSIONS

DBA_IND_EXPRESSIONS

USER_IDX_EXPRESSIONS

USER_IND_EXPRESSIONS

3.2.27. ALL_IND_PARTITIONS

Synonym for ALL_IDX_PARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
COMPOSITE	VARCHAR(3)	Whether or not partition belongs to a composite-partitioned index - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the partition
SUBPARTITION_COUNT	NUMBER	The number of the subpartitions that belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the index
BLEVEL	NUMBER	Level of B-tree index (The level is 0 for a B-tree with only a root node)
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
CLUSTERING_FACTOR	NUMBER	The clustering factor of the index
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
NUM_ROWS	NUMBER	The number of rows in the index
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_TRANS	NUMBER	Value of the MAX_TRANS parameter
INITIAL_EXTENT	NUMBER	Value of the INITIAL_EXTENT parameter
MIN_EXTENT	NUMBER	Value of the MIN_EXTENT parameter
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
LAST_ANALYZED	DATE	Date of the most recent analysis for the index partition

See also

ALL_IDX_PARTITIONS

DBA_IDX_PARTITIONS

DBA_IND_PARTITIONS

USER_IDX_PARTITIONS

USER_IND_PARTITIONS

3.2.28. ALL_IND_SUBPARTITIONS

Synonym for ALL_IDX_SUBPARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
PARTITION_NAME	VARCHAR(128)	Name of the index partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the index subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows in the index subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the subpartition

See also

ALL_IDX_SUBPARTITIONS

DBA_IDX_SUBPARTITIONS

DBA_IND_SUBPARTITIONS

3.2.29. ALL_JAVA_ARGUMENTS

Displays all parameters that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the class
NAME	VARCHAR(4000)	Name of the class
METHOD_INDEX	NUMBER	Index of the method
METHOD_NAME	VARCHAR(4000)	Name of the method
ARGUMENT_POSITION	NUMBER	Position of the parameter (start position 1)
ARRAY_DEPTH	NUMBER	Array depth of the parameter type
ARGUMENT_TYPE	VARCHAR(7)	Name of the parameter type
ARGUMENT_CLASS	VARCHAR(4000)	Actual class name for the parameter whose type is class

See also

DBA_JAVA_ARGUMENTS

USER_JAVA_ARGUMENTS

3.2.30. ALL_JAVA_CLASSES

Displays all classes that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the class
NAME	VARCHAR(4000)	Name of the class
MAJOR	NUMBER	Major version of the class defined in JVM
MINOR	NUMBER	Minor version of the class defined in JVM
KIND	VARCHAR2(9)	Type of the class - Interface - Class
ACCESSIBILITY	VARCHAR(9)	Accessibility of the class
IS_INNER	VARCHAR(1)	Whether or not the class is an INNER class
IS_ABSTRACT	VARCHAR(1)	Whether or not the class is an abstract class
IS_FINAL	VARCHAR(1)	Whether or not the class is a final class
STATUS	VARCHAR(7)	Status of the library - VALID - INVALID
SOURCE	VARCHAR(4000)	Source of the class
SUPER	VARCHAR(4000)	Name of the SUPER class
OUTER	VARCHAR(4000)	Name of the OUTER class if the class is an INNER class

See also

DBA_JAVA_CLASSES

USER_JAVA_CLASSES

3.2.31. ALL_JAVA_FIELDS

Displays all fields that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the field
NAME	VARCHAR(4000)	Name of the class
FIELD_INDEX	NUMBER	Index of the field
FIELD_NAME	VARCHAR(4000)	Name of the field
ACCESSIBILITY	VARCHAR(9)	Accessibility of the field
IS_STATIC	VARCHAR(1)	Whether or not the field is a STATIC field
IS_FINAL	VARCHAR(1)	Whether or not the field is a FINAL field
IS_VOLATILE	VARCHAR(1)	Whether or not the field is a VOLATILE field
IS_TRANSIENT	VARCHAR(1)	Whether or not the field is a TRANSIENT field
ARRAY_DEPTH	NUMBER	Array depth of the field type
FIELD_TYPE	VARCHAR(7)	Name of the field type
FIELD_CLASS	VARCHAR(4000)	Actual class name if the field type is class

See also

DBA_JAVA_FIELDS

USER_JAVA_FIELDS

3.2.32. ALL_JAVA_METHODS

Displays all methods that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the method
NAME	VARCHAR(4000)	Name of the class
METHOD_INDEX	NUMBER	Index of the method
METHOD_NAME	VARCHAR(4000)	Name of the method
ACCESSIBILITY	VARCHAR(9)	Accessibility of the method
IS_STATIC	VARCHAR(1)	Whether or not the method is a STATIC method
IS_FINAL	VARCHAR(1)	Whether or not the method is a FINAL method
IS_SYNCHRONIZED	VARCHAR(1)	Whether or not the method is a SYNCHRONIZED method
IS_NATIVE	VARCHAR(1)	Whether or not the method is a NATIVE method
IS_STRICT	VARCHAR(1)	Whether or not the method is a STRICT method
ARGUMENTS	NUMBER	The number of parameters of the method
THROWS	NUMBER	The number of exceptions sent by the method
ARRAY_DEPTH	NUMBER	Array depth of the return type
RETURN_TYPE	VARCHAR(7)	Name of the return type
RETURN_CLASS	VARCHAR(4000)	Actual class name if the return type is class

See also

DBA_JAVA_METHODS

USER_JAVA_METHODS

3.2.33. ALL_JOBS

Displays all jobs that the current user can access.

Columns

Column Name	Data Type	Description
JOB	NUMBER	ID of the job
SCHEMA_USER	NUMBER	Owner ID of the job
NEXT_DATE	DATE	Next job execution date
INTERVAL	VARCHAR(4000)	Interval used to evaluate the value to be set in NEXT_DATE column after the job is executed
BROKEN	VARCHAR(1)	Status of the job - Y: Invalid - N: Valid
FAILURES	NUMBER	The number of successive failures in job executions
WHAT	VARCHAR(4000)	The contents that this job will execute
INSTANCE	NUMBER	Instance number of RDBMS which runs the job
THIS_DATE	DATE	Date that this job started
LAST_DATE	DATE	Date that this job finished successfully

See also

DBA_JOBS

USER_JOBS

3.2.34. ALL_LIBRARIES

Displays all libraries that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the library
LIBRARY_NAME	VARCHAR(128)	Name of the library
FILE_SPEC	VARCHAR(4000)	Path to the library
STATUS	VARCHAR(7)	Status of the library - VALID - INVALID

See also

DBA_LIBRARIES

USER_LIBRARIES

3.2.35. ALL_LOBS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object that contains the LOB
TABLE_NAME	VARCHAR(128)	Name of the table that contains the LOB
COLUMN_NAME	VARCHAR(128)	Name of the LOB column
SEGMENT_NAME	VARCHAR(128)	Name of the LOB segment
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the LOB belongs
INDEX_NAME	VARCHAR(128)	Name of the LOB index
IN_ROW	VARCHAR(3)	Whether STORAGE IN ROW is enabled or not - YES - NO
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
PARTITIONED	VARCHAR(3)	Whether or not the LOB column is in a partitioned table - YES - NO

See also

DBA_LOBS

USER_LOBS

3.2.36. ALL_LOB_PARTITIONS

Displays all LOB partitions that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the LOB column
PARTITION_NAME	VARCHAR(128)	Name of the table partition
LOB_PARTITION_NAME	VARCHAR(128)	Name of the LOB partition
LOB_INDPART_NAME	VARCHAR(128)	Name of the LOB index partition
PARTITION_NO	NUMBER	Partition number within the table
COMPOSITE	VARCHAR(3)	Whether or not the partition is a composite partition - YES - NO
IN_ROW	VARCHAR(3)	Whether STORAGE IN ROW is enabled or not - YES - NO
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the LOB partition belongs
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE

See also

DBA_LOB_PARTITIONS

USER_LOB_PARTITIONS

3.2.37. ALL_LOB_SUBPARTITIONS

Displays LOB subpartitions that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the LOB column
PARTITION_NAME	VARCHAR(128)	Name of the table partition
LOB_NAME	VARCHAR(128)	Name of the LOB
LOB_PARTITION_NAME	VARCHAR(128)	Name of the LOB partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the table subpartition
LOB_SUBPARTITION_NAME	VARCHAR(128)	Name of the LOB subpartition
LOB_INDSUBPART_NAME	VARCHAR(128)	Name of the LOB index subpartition
SUBPARTITION_NO	NUMBER	Subpartition number within the table
IN_ROW	VARCHAR(3)	Whether STORAGE IN ROW is enabled or not - YES - NO
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the LOB partition belongs
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE

See also

DBA_LOB_SUBPARTITIONS

USER_LOB_SUBPARTITIONS

3.2.38. ALL_LOG_GROUPS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the log group definition
LOG_GROUP_NAME	VARCHAR(128)	Name of the log group definition
TABLE_NAME	VARCHAR(128)	Name of the table where the log group is defined
LOG_GROUP_TYPE	VARCHAR(19)	Type of the log group: - PRIMARY KEY LOGGING - UNIQUE KEY LOGGING - FOREIGN KEY LOGGING - ALL COLUMN LOGGING - USER LOG GROUP
ALWAYS	VARCHAR(11)	Y Indicates that the log group is logged whenever a row is updated; N Indicates that the log group is logged whenever a member column is updated.
GENERATED	VARCHAR(14)	Whether the name of the supplemental log group indicates the system generated (GENERATED NAME) or not (USER NAME).

See also

DBA_LOG_GROUPS

USER_LOG_GROUPS

3.2.39. ALL_LOG_GROUP_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the log group definition
LOG_GROUP_NAME	VARCHAR(128)	Name of the log group definition
TABLE_NAME	VARCHAR(128)	Name of the table where the log group is defined
COLUMN_NAME	VARCHAR(128)	Name of the column or attribute of the object type column specified in the log group definition
POSITION	NUMBER	Original position of the column or attribute in the definition of the object
LOGGING_PROPERTY	VARCHAR(6)	Indicates whether the column or attribute would be supplementally logged (LOG) or not (NO LOG)

See also

DBA_LOG_GROUP_COLUMNS

USER_LOG_GROUP_COLUMNS

3.2.40. ALL_METHOD_PARAMS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
METHOD_NAME	VARCHAR(128)	Name of this method
METHOD_NO	NUMBER	Number of this method
PARAM_NAME	VARCHAR(128)	Name of this parameter
PARAM_NO	NUMBER	Location of this parameter
PARAM_MODE	VARCHAR(9)	Mode of this parameter
PARAM_TYPE_MOD	VARCHAR(128)	Modifier of this parameter type (not supported)
PARAM_TYPE_OWNER	VARCHAR(128)	Owner of this parameter type
PARAM_TYPE_NAME	VARCHAR(65532)	Name of this parameter type
CHARACTER_SET_NAME	VARCHAR(128)	Name of the Character set (not supported)

See also

DBA_METHOD_PARAMS

USER_METHOD_PARAMS

3.2.41. ALL_METHOD_RESULTS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
METHOD_NAME	VARCHAR(128)	Name of this method
METHOD_NO	NUMBER	Method number of this method
PARAM_TYPE_MOD	VARCHAR(128)	Modifier of this result type (not supported)
PARAM_TYPE_OWNER	VARCHAR(128)	Owner of this result type
PARAM_TYPE_NAME	VARCHAR(65532)	Name of this result type
CHARACTER_SET_NAME	VARCHAR(128)	Name of Character set (not supported)

See also

DBA_METHOD_RESULTS

USER_METHOD_RESULTS

3.2.42. ALL_MVIEWS

Displays all materialized views that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the materialized view
MVIEW_NAME	VARCHAR(128)	Name of the materialized view
CONTAINER_NAME	VARCHAR(128)	Container table name of the materialized view
QUERY	LONG	Defining query of the materialized view.
QUERY_LEN	NUMBER(38)	Length of the defining query in bytes
UPDATABLE	CHAR(1)	Whether or not the materialized view is updatable - Y: Updatable - N: Not updatable
UPDATE_LOG	CHAR(0)	Update log for an updatable materialized view
MASTER_ROLLBACK_SEG	CHAR(0)	Rollback segment of the master site
MASTER_LINK	CHAR(0)	Database link to the master site
REWRITE_ENABLED	VARCHAR(1)	Whether or not the rewrite of a materialized view query is enabled - Y: rewrite enabled - N: rewrite disabled
REWRITE_CAPABILITY	CHAR(7)	Rewrite capability of the materialized view
REFRESH_MODE	VARCHAR(6)	Refresh mode of the materialized view - Commit - Demand
REFRESH_METHOD	VARCHAR(1)	Refresh method of the materialized view - C (Complete) - F (Fast) - ? (Force) - N (Never)
BUILD_MODE	VARCHAR(9)	Build mode of the materialized view - Immediate - Deferred
FAST_REFRESHABLE	CHAR(2)	Whether or not the materialized view is eligible for fast refresh
LAST_REFRESH_TYPE	CHAR(2)	The most recent refresh type
LAST_REFRESH_DATE	DATE	The most recent refresh date
STALENESS	VARCHAR(9)	Staleness of the materialized view
AFTER_FAST_REFRESH	CHAR(2)	Staleness of the materialized view after the expected fast refresh
UNKNOWN_PREBUILT	CHAR(1)	Whether or not the materialized view is of unknown status as it is prebuilt (Y/N)
UNKNOWN_PLSQL_FUNC	CHAR(1)	Whether or not the materialized view is of unknown status as it contains psm function (Y/N)
UNKNOWN_EXTERNAL_TABLE	CHAR(1)	Whether or not the materialized view is of unknown status as it contains external tables (Y/N)
UNKNOWN_CONSIDER_FRESH	CHAR(1)	Whether or not the materialized view is of unknown status as it is marked consider fresh (Y/N)
UNKNOWN_IMPORT	CHAR(1)	Whether or not the materialized view is of unknown status as it is imported (Y/N)
UNKNOWN_TRUSTED_FD	CHAR(1)	Whether or not the materialized view is of unknown status as it uses trusted constraints (Y/N)
COMPILE_STATE	CHAR(5)	Compilation status of the materialized view
USE_NO_INDEX	CHAR(1)	Whether or not the index is used in the materialized view creation - Y: using no index - N: using the default index
STALE_SINCE	VARCHAR(0)	Time passed from when the materialized view became stale
INTERVAL	VARCHAR(2000)	Date function used to compute the next refresh time
REDUCED_PRECISION	VARCHAR(1)	Whether or not the reduced precision is used for prebuilt materialized view (Y/N)
REFRESH_KEY	VARCHAR(11)	Represents the key type which is used to refresh a materialized view. - ROWID: rowid - PRIMARY KEY: primary key column of the base table

See also

DBA_MVIEWS

USER_MVIEWS

3.2.43. ALL_MVIEW_COMMENTS

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

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the materialized view
MVIEW_NAME VARCHAR(128)
Name of the materialized view
COMMENTS VARCHAR(4000)
Comment on the materialized view
See also

DBA_MVIEW_COMMENTS

USER_MVIEW_COMMENTS

3.2.44. ALL_MVIEW_LOGS

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

Columns

Column Name	Data Type	Description
LOG_OWNER	VARCHAR2(128)	Owner of the materialized view log
MASTER	VARCHAR2(128)	Name of the master table whose changes are logged
LOG_TABLE	VARCHAR2(128)	Name of the log table
LOG_TRIGGER	VARCHAR2(128)	after-row trigger on the master table which inserts rows into the log
ROWIDS	VARCHAR2(3)	Whether to record the rowid information
PRIMARY_KEY	VARCHAR2(3)	Whether to record the primary key information
FILTER_COLUMNS	VARCHAR2(3)	Whether to record the filter column information
SEQUENCE	VARCHAR2(3)	Whether to record the sequence information
INCLUDE_NEW_VALUES	VARCHAR2(3)	Whether to record both old and new values - Y: Keeps both old and new values. - N: Keeps old values only.

See also

DBA_MVIEW_LOGS

USER_MVIEW_LOGS

3.2.45. ALL_OBJECTS

Displays all objects that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
SUBOBJECT_NAME	VARCHAR(128)	Name of the subobject (For example, partition name)
OBJECT_ID	NUMBER	ID of the object
OBJECT_TYPE	VARCHAR(23)	Type of the object - INDEX - TABLE - VIEW - SYNONYM - SEQUENCE - PROCEDURE - FUNCTION - PACKAGE - PACKAGE BODY - TRIGGER - TABLE PARTITION - INDEX PARTITION - LOB - LOB PARTITION - TABLE SUBPARTITION - INDEX SUBPARTITION - LOB SUBPARTITION - DIRECTORY - UNDEFINED
OBJECT_TYPE_NO	NUMBER	Type number of the object
CREATED	DATE	Date that the object was created
LAST_DDL_TIME	DATE	Date that the modification took effect on the object through DDL statement
TIMESTAMP	VARCHAR(19)	Timestamp for the latest changes on object structure
STATUS	VARCHAR(7)	Status of the object - VALID - INVALID
TEMPORARY	VARCHAR(1)	Whether or not the object is a temporary object - Y - N

See also

DBA_OBJECTS

USER_OBJECTS

3.2.46. ALL_PACKAGE_MEMBER_TYPES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
PACKAGE_NAME	VARCHAR(128)	Package name of this type
TYPE_NAME	VARCHAR(128)	Name of this type
TYPE_NO	NUMBER	Type number of this type
PRECISION	NUMBER	Precision of this type
SCALE	NUMBER	Scale of this type
TYPE_OBJ_ID	NUMBER	Object id of this type
MEMBER_NO	NUMBER	Member number of this type
KIND	NUMBER	Member kind of this type
LIMIT	NUMBER	Limit of this type
COUNT	NUMBER	Count of this type

See also

DBA_PACKAGE_MEMBER_TYPES

USER_PACKAGE_MEMBER_TYPES

3.2.47. ALL_PART_INDEXES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the partitioned index
INDEX_NAME	VARCHAR(128)	Name of the partitioned index
TABLE_NAME	VARCHAR(128)	Name of the partitioned table
PARTITIONING_TYPE	VARCHAR(5)	Type of the partition - RANGE - HASH - LIST
SUBPARTITIONING_TYPE	VARCHAR(5)	Type of the composite partition - RANGE - HASH - LIST - NONE
PARTITION_COUNT	NUMBER	The number of partitions
DEF_SUBPARTITION_COUNT	NUMBER	In the case of composite partition, the default number for the number of subpartitions (when only it is defined)
PARTITIONING_KEY_COUNT	NUMBER	The number of columns used as partitioning key
SUBPARTITIONING_KEY_COUNT	NUMBER	For a composite partition, the number of columns used as subpartitioning key
LOCALITY	VARCHAR(6)	Whether the index is a local index or global index - LOCAL: Local index - GLOBAL: Global index
ALIGNMENT	VARCHAR(12)	Whether or not the partitioned key column is prefixed - PREFIXED: prefixed - NON_PREFIXED: not prefixed
DEF_TABLESPACE_NAME	VARCHAR(128)	Name of the default tablespace used to add or split a partition
DEF_PCT_FREE	NUMBER	Default value of PCTFREE used to add a partition
DEF_INI_TRANS	NUMBER	Default value of INITRANS used to add a partition.
DEF_NEXT_EXTENT	NUMBER	Default value of NEXT_EXTENT used to add a partition
DEF_MAX_EXTENTS	NUMBER	Default value of MAX_EXTENTS used to add a partition
DEF_BUFFER_POOL	VARCHAR(7)	Default value of buffer pool type used to add a partition - DEFAULT - KEEP - RECYCLE

See also

DBA_PART_INDEXES

USER_PART_INDEXES

3.2.48. ALL_PART_KEY_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the partitioned table or index
NAME	VARCHAR(128)	Name of the partitioned table or index
OBJECT_TYPE	CHAR(5)	Type of the partition - TABLE - INDEX
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the partitioning key

See also

DBA_PART_KEY_COLUMNS

USER_PART_KEY_COLUMNS

3.2.49. ALL_PART_LOBS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the partitioned table
TABLE_NAME	VARCHAR(128)	Name of the partitioned table
COLUMN_NAME	VARCHAR(128)	Name of the LOB column
LOB_NAME	VARCHAR(128)	Name of the LOB
LOB_INDEX_NAME	VARCHAR(128)	Name of the LOB index
DEF_IN_ROW	VARCHAR(3)	Whether STORAGE IN ROW used by default to add or split a partition is enabled or not - YES - NO
DEF_TABLESPACE_NAME	VARCHAR(128)	Name of the default tablespace used to add or split a partition
DEF_NEXT_EXTENT	NUMBER	Default value of NEXT_EXTENT used to add a partition
DEF_MAX_EXTENTS	NUMBER	Default value of MAX_EXTENTS used to add a partition
DEF_BUFFER_POOL	VARCHAR(7)	Default value of buffer pool type used to add a partition - DEFAULT - KEEP - RECYCLE

See also

DBA_PART_LOBS

USER_PART_LOBS

3.2.50. ALL_PART_TABLES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the partitioned table
TABLE_NAME	VARCHAR(128)	Name of the partitioned table
PARTITIONING_TYPE	VARCHAR(5)	Type of the partitioning method - RANGE - HASH - LIST
SUBPARTITIONING_TYPE	VARCHAR(5)	Type of the composite partition - RANGE - HASH - LIST - NONE
PARTITION_COUNT	NUMBER	The number of partitions
DEF_SUBPARTITION_COUNT	NUMBER	For a composite partition, the number of subpartitions (only when it is defined)
PARTITIONING_KEY_COUNT	NUMBER	The number of columns participating in the partitioning key
SUBPARTITIONING_KEY_COUNT	NUMBER	For a composite partition, the number of columns used as subpartitioning key
DEF_TABLESPACE_NAME	VARCHAR(128)	Name of default tablespace used to add or split a partition
DEF_PCT_FREE	NUMBER	Default value of PCTFREE used to add a partition
DEF_INI_TRANS	NUMBER	Default value of INITRANS used to add a partition
DEF_NEXT_EXTENT	NUMBER	Default value of NEXT_EXTENT used to add a partition
DEF_MAX_EXTENTS	NUMBER	Default value of MAX_EXTENTS used to add a partition
DEF_BUFFER_POOL	VARCHAR(7)	Default value of buffer pool type used to add a partition - DEFAULT - KEEP - RECYCLE
MAX_TRANS	NUMBER	Value of the MAX_TRANS parameter
INITIAL_EXTENT	NUMBER	Value of the INITIAL_EXTENT parameter
MIN_EXTENT	NUMBER	Value of the MIN_EXTENT parameter
INTERVAL	VARCHAR(128)	String of the interval values

See also

DBA_PART_TABLES

USER_PART_TABLES

3.2.51. ALL_PROCEDURES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the procedure
OBJECT_NAME	VARCHAR(128)	Name of the object
PROCEDURE_NAME	VARCHAR(128)	Name of the procedure
AGGREGATE	CHAR(2)	Whether or not it is an AGGREGATE function
PIPELINED	CHAR(2)	Whether or not the table function is pipelined
IMPLTYPEOWNER	CHAR(0)	Owner of the IMPLEMENTATION type
IMPLTYPENAME	CHAR(0)	Name of the IMPLEMENTATION type
PARALLEL	CHAR(2)	Whether PARALLEL is enabled or not
INTERFACE	CHAR(2)	Whether or not it is an INTERFACE function
DETERMINISTIC	CHAR(2)	Whether or not it is a DETERMINISTIC function
FUNCTIONABLE	VARCHAR(3)	Whether or not it is a function
WRAPPED	VARCHAR(3)	Whether or not it is encrypted (deprecated)
AUTHID	VARCHAR(7)	Name of AUTHID
MEMBER_NO	NUMBER	Index of its object

See also

DBA_PROCEDURES

USER_PROCEDURES

3.2.52. ALL_QUEUES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the queue
NAME	VARCHAR(128)	Name of the queue
QUEUE_TABLE	VARCHAR(128)	Name of the queue table
QID	NUMBER	Object number of the queue
QUEUE_TYPE	VARCHAR(20)	Type of the queue - EXCEPTION_QUEUE - NON_PERSISTENT_QUEUE - NORMAL_QUEUE
MAX_RETRIES	NUMBER	Maximum number of retries allowed when dequeuing from the queue
RETRY_DELAY	NUMBER	Time interval between retries
ENQUEUE_ENABLED	VARCHAR(3)	Indicates whether the queue is enabled for enqueue (YES) or not (NO)
DEQUEUE_ENABLED	VARCHAR(3)	Indicates whether the queue is enabled for dequeue (YES) or not (NO)
RETENTION	VARCHAR(256)	Time interval (in seconds) processed messages are retained in the queue, or FOREVER
USER_COMMENT	VARCHAR(100)	User specified comment

See also

DBA_QUEUES

USER_QUEUES

3.2.53. ALL_QUEUE_SUBSCRIBERS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the queue
QUEUE_NAME	VARCHAR(128)	Name of the queue
QUEUE_TABLE	VARCHAR(128)	Name of the queue table on which the queue is defined
CONSUMER_NAME	VARCHAR(128)	Name of the subscriber
ADDRESS	VARCHAR(1024)	Address of the subscriber
PROTOCOL	NUMBER	Protocol of the subscriber
TRANSFORMATION	VARCHAR(0)	Transformation for the subscriber
RULE	VARCHAR(0)	Rule condition for the subscriber
DELIVERY_MODE	CHAR(10)	Message delivery mode for the subscriber
IF_NONDURABLE_SUBSCRIBER	CHAR(2)	Indicates whether the subscriber is a non-durable subscriber (YES) or not (NO)
QUEUE_TO_QUEUE	CHAR(5)	Indicates whether the subscriber is a queue-to-queue subscriber (TRUE) or not (FALSE)

See also

DBA_QUEUE_SUBSCRIBERS

USER_QUEUE_SUBSCRIBERS

3.2.54. ALL_QUEUE_TABLES

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the queue table
QUEUE_TABLE	VARCHAR(128)	Name of the queue table
TYPE	VARCHAR(6)	Type of user data - RAW: Raw type - OBJECT: User-defined object type
OBJECT_TYPE	VARCHAR(0)	Object type of the payload when TYPE is OBJECT
SORT_ORDER	VARCHAR(22)	User-specified sort order
RECIPIENTS	VARCHAR(8)	SINGLE or MULTIPLE recipients
MESSAGE_GROUPING	VARCHAR(13)	NONE or TRANSACTIONAL
PRIMARY_INSTANCE	NUMBER	Indicates the instance number of the instance which is the primary owner of the queue table. A value of 0 indicates that there is no primary owner
SECONDARY_INSTANCE	NUMBER	Indicates the instance number of the instance which is the secondary owner of the queue table. This instance becomes the owner of the queue table if the primary owner is not alive. A value of 0 indicates that there is no secondary owner
OWNER_INSTANCE	NUMBER	Instance number of the instance which currently owns the queue table
USER_COMMENT	VARCHAR(100)	User specified comment

See also

DBA_QUEUE_TABLES

USER_QUEUE_TABLES

3.2.55. ALL_RECYCLEBIN

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

Columns

Column Name	Data Type	Description
OBJECT_NAME	VARCHAR(128)	Current name of the object
ORIGINAL_NAME	VARCHAR(128)	Original name of the object
TYPE	VARCHAR(7)	Type of the object - Table - Index - Trigger
TS_NAME	VARCHAR(128)	Name of the tablespace containing the object
CREATETIME	VARCHAR(19)	Timestamp for the object creation
DROPTIME	VARCHAR(19)	Timestamp for the object deletion
DROPTSN	NUMBER	TSN of the transaction which dropped the object
BASE_OBJECT	VARCHAR(256)	Object ID of the base object
SPACE	VARCHAR(0)	Number of blocks used by the object

See also

DBA_RECYCLEBIN

USER_RECYCLEBIN

3.2.56. ALL_SCHEDULER_CHAINS

Displays all scheduler chains that the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
CHAIN_NAME	VARCHAR2(30)	Name of the chain
RULE_SET_NAME	VARCHAR2(30)	This column is for future use.
EVALUATION_INTERVAL	INTERVAL	This column is for future use.
COMMENTS	VARCHAR2(240)	Comments on the chain

See also

DBA_SCHEDULER_CHAINS

USER_SCHEDULER_CHAINS

3.2.57. ALL_SCHEDULER_JOBS

Displays all scheduler jobs that the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
JOB_NAME	VARCHAR2(30)	Name of the job
JOB_SUBNAME	VARCHAR2(30)	Subname of the job (for a job in chain)
JOB_STYLE	VARCHAR2(11)	This column is for future use.
JOB_CREATOR	VARCHAR2(30)	This column is for future use.
CLIENT_ID	VARCHAR2(64)	This column is for future use.
GLOBAL_UID	VARCHAR2(32)	This column is for future use.
PROGRAM_OWNER	VARCHAR2(128)	This column is for future use.
PROGRAM_NAME	VARCHAR2(30)	This column is for future use.
JOB_TYPE	VARCHAR2(16)	Job action type: - PSM_BLOCK - CHAIN
JOB_ACTION	VARCHAR2(4000)	Job action
NUMBER_OF_ARGUMENTS	NUMBER	This column is for future use.
SCHEDULE_OWNER	VARCHAR2(4000)	This column is for future use.
SCHEDULE_NAME	VARCHAR2(4000)	This column is for future use.
SCHEDULE_TYPE	VARCHAR2(12)	This column is for future use.
START_DATE	TIMESTAMP(6)	Start date of the job
REPEAT_INTERVAL	VARCHAR2(4000)	Cron expression
EVENT_QUEUE_OWNER	VARCHAR2(30)	This column is for future use.
EVENT_QUEUE_NAME	VARCHAR2(30)	This column is for future use.
EVENT_QUEUE_AGENT	VARCHAR2(256)	This column is for future use.
EVENT_CONDITION	VARCHAR2(4000)	This column is for future use.
EVENT_RULE	VARCHAR2(65)	This column is for future use.
FILE_WATCHER_OWNER	VARCHAR2(65)	This column is for future use.
FILE_WATCHER_NAME	VARCHAR2(65)	This column is for future use.
END_DATE	TIMESTAMP(6)	Date after which the job will no longer run
JOB_CLASS	VARCHAR2(30)	This column is for future use.
ENABLED	VARCHAR2(5)	Indicates whether the job is enabled (TRUE) or not (FALSE)
AUTO_DROP	VARCHAR2(5)	This column is for future use.
RESTARTABLE	VARCHAR2(5)	This column is for future use.
STATE	VARCHAR2(15)	This column is for future use.
JOB_PRIORITY	NUMBER	This column is for future use.
RUN_COUNT	NUMBER	This column is for future use.
MAX_RUNS	NUMBER	This column is for future use.
FAILURE_COUNT	NUMBER	This column is for future use.
MAX_FAILURES	NUMBER	This column is for future use.
RETRY_COUNT	NUMBER	This column is for future use.
LAST_START_DATE	TIMESTAMP(6)	This column is for future use.
LAST_RUN_DURATION	INTERVAL	This column is for future use.
NEXT_RUN_DATE	TIMESTAMP(6)	This column is for future use.
SCHEDULE_LIMIT	INTERVAL	This column is for future use.
MAX_RUN_DURATION	INTERVAL	This column is for future use.
LOGGING_LEVEL	VARCHAR2(11)	This column is for future use.
STOP_ON_WINDOW_CLOSE	VARCHAR2(5)	This column is for future use.
INSTANCE_STICKINESS	VARCHAR2(5)	This column is for future use.
RAISE_EVENTS	VARCHAR2(4000)	This column is for future use.
SYSTEM	VARCHAR2(5)	This column is for future use.
JOB_WEIGHT	NUMBER	This column is for future use.
NLS_ENV	VARCHAR2(4000)	This column is for future use.
SOURCE	VARCHAR2(128)	This column is for future use.
NUMBER_OF_DESTINATIONS	NUMBER	This column is for future use.
DESTINATION_OWNER	VARCHAR2(128)	This column is for future use.
DESTINATION	VARCHAR2(128)	This column is for future use.
CREDENTIAL_OWNER	VARCHAR2(30)	This column is for future use.
CREDENTIAL_NAME	VARCHAR2(30)	This column is for future use.
INSTANCE_ID	NUMBER	ID of the instance (for TAC)
DEFERRED_DROP	VARCHAR2(5)	This column is for future use.
ALLOW_RUNS_IN_RESTRICTED_MODE	VARCHAR2(5)	This column is for future use.
COMMENTS	VARCHAR2(240)	Comments on the job
FLAGS	NUMBER	This column is for internal use.
JOB_ID	NUMBER	This column is for internal use.
CHAIN_NAME	VARCHAR2(30)	This column is for internal use.
STEP_NAME	VARCHAR2(30)	This column is for internal use.
CTX_ID	NUMBER	This column is for internal use.

See also

DBA_SCHEDULER_JOBS

USER_SCHEDULER_JOBS

3.2.58. ALL_SCHEDULER_PROGRAMS

Displays all scheduler programs that the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
PROGRAM_NAME	VARCHAR2(128)	Name of the program
PROGRAM_TYPE	VARCHAR2(16)	Type of the program - PSM_BLOCK
PROGRAM_ACTION	VARCHAR2(4000)	Program action
NUMBER_OF_ARGUMENTS	NUMBER	This column is for future use.
ENABLED	VARCHAR2(5)	Indicates whether the program is enabled (TRUE) or not (FALSE)
DETACHED	VARCHAR2(5)	This column is for future use.
SCHEDULE_LIMIT	INTERVAL	This column is for future use.
PRIORITY	NUMBER	This column is for future use.
WEIGHT	NUMBER	This column is for future use.
MAX_RUNS	NUMBER	This column is for future use.
MAX_FAILURES	NUMBER	This column is for future use.
MAX_RUN_DURATION	INTERVAL	This column is for future use.
NLS_ENV	VARCHAR2(4000)	This column is for future use.
COMMENTS	VARCHAR2(240)	Comments on the program

See also

DBA_SCHEDULER_PROGRAMS

USER_SCHEDULER_PROGRAMS

3.2.59. ALL_SCHEDULER_RULES

Displays all scheduler rules that the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
CHAIN_NAME	VARCHAR2(30)	Name of the chain
CONDITION	VARCHAR2(4000)	Condition of the rule
ACTION	VARCHAR2(4000)	Action of the rule
RULE_NAME	VARCHAR2(30)	Name of the rule
COMMENTS	VARCHAR2(240)	Comments on the rule

See also

DBA_SCHEDULER_RULES

USER_SCHEDULER_RULES

3.2.60. ALL_SCHEDULER_RULE_CTX

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

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
CHAIN_NAME	VARCHAR2(30)	Name of the chain
CONDITION	VARCHAR2(4000)	Condition of the rule
ACTION	VARCHAR2(4000)	Action of the rule
RULE_NAME	VARCHAR2(30)	Name of the rule
CTX_ID	NUMBER	ID of the context (for internal use)

See also

DBA_SCHEDULER_RULE_CTX

USER_SCHEDULER_RULE_CTX

3.2.61. ALL_SCHEDULER_RUNNING_JOBS

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

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
JOB_NAME	VARCHAR2(30)	Name of the job
JOB_SUBNAME	VARCHAR2(30)	Subname of the job (for a job in chain)
JOB_STYLE	VARCHAR2(11)	This column is for future use.
JOB_CREATOR	VARCHAR2(30)	This column is for future use.
CLIENT_ID	VARCHAR2(64)	This column is for future use.
GLOBAL_UID	VARCHAR2(32)	This column is for future use.
PROGRAM_OWNER	VARCHAR2(128)	This column is for future use.
PROGRAM_NAME	VARCHAR2(30)	This column is for future use.
JOB_TYPE	VARCHAR2(16)	Job action type: - PSM_BLOCK - CHAIN
JOB_ACTION	VARCHAR2(4000)	Job action
NUMBER_OF_ARGUMENTS	NUMBER	This column is for future use.
SCHEDULE_OWNER	VARCHAR2(4000)	This column is for future use.
SCHEDULE_NAME	VARCHAR2(4000)	This column is for future use.
SCHEDULE_TYPE	VARCHAR2(12)	This column is for future use.
START_DATE	TIMESTAMP(6)	Start date of the job
REPEAT_INTERVAL	VARCHAR2(4000)	Cron expression
EVENT_QUEUE_OWNER	VARCHAR2(30)	This column is for future use.
EVENT_QUEUE_NAME	VARCHAR2(30)	This column is for future use.
EVENT_QUEUE_AGENT	VARCHAR2(256)	This column is for future use.
EVENT_CONDITION	VARCHAR2(4000)	This column is for future use.
EVENT_RULE	VARCHAR2(65)	This column is for future use.
FILE_WATCHER_OWNER	VARCHAR2(65)	This column is for future use.
FILE_WATCHER_NAME	VARCHAR2(65)	This column is for future use.
END_DATE	TIMESTAMP(6)	Date after which the job will no longer run
JOB_CLASS	VARCHAR2(30)	This column is for future use.
ENABLED	VARCHAR2(5)	Indicates whether the job is enabled (TRUE) or not (FALSE)
AUTO_DROP	VARCHAR2(5)	This column is for future use.
RESTARTABLE	VARCHAR2(5)	This column is for future use.
STATE	VARCHAR2(15)	This column is for future use.
JOB_PRIORITY	NUMBER	This column is for future use.
RUN_COUNT	NUMBER	This column is for future use.
MAX_RUNS	NUMBER	This column is for future use.
FAILURE_COUNT	NUMBER	This column is for future use.
MAX_FAILURES	NUMBER	This column is for future use.
RETRY_COUNT	NUMBER	This column is for future use.
LAST_START_DATE	TIMESTAMP(6)	This column is for future use.
LAST_RUN_DURATION	INTERVAL	This column is for future use.
NEXT_RUN_DATE	TIMESTAMP(6)	This column is for future use.
SCHEDULE_LIMIT	INTERVAL	This column is for future use.
MAX_RUN_DURATION	INTERVAL	This column is for future use.
LOGGING_LEVEL	VARCHAR2(11)	This column is for future use.
STOP_ON_WINDOW_CLOSE	VARCHAR2(5)	This column is for future use.
INSTANCE_STICKINESS	VARCHAR2(5)	This column is for future use.
RAISE_EVENTS	VARCHAR2(4000)	This column is for future use.
SYSTEM	VARCHAR2(5)	This column is for future use.
JOB_WEIGHT	NUMBER	This column is for future use.
NLS_ENV	VARCHAR2(4000)	This column is for future use.
SOURCE	VARCHAR2(128)	This column is for future use.
NUMBER_OF_DESTINATIONS	NUMBER	This column is for future use.
DESTINATION_OWNER	VARCHAR2(128)	This column is for future use.
DESTINATION	VARCHAR2(128)	This column is for future use.
CREDENTIAL_OWNER	VARCHAR2(30)	This column is for future use.
CREDENTIAL_NAME	VARCHAR2(30)	This column is for future use.
INSTANCE_ID	NUMBER	ID of the instance (for TAC)
DEFERRED_DROP	VARCHAR2(5)	This column is for future use.
ALLOW_RUNS_IN_RESTRICTED_MODE	VARCHAR2(5)	This column is for future use.
COMMENTS	VARCHAR2(240)	Comments on the job
FLAGS	NUMBER	This column is for internal use.
JOB_ID	NUMBER	This column is for internal use.
CHAIN_NAME	VARCHAR2(30)	This column is for internal use.
STEP_NAME	VARCHAR2(30)	This column is for internal use.
CTX_ID	NUMBER	This column is for internal use.

See also

DBA_SCHEDULER_RUNNING_JOBS

USER_SCHEDULER_RUNNING_JOBS

3.2.62. ALL_SCHEDULER_STEPS

Displays all scheduler steps that the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
CHAIN_NAME	VARCHAR2(30)	Name of the chain
STEP_NAME	VARCHAR2(30)	Name of the step
PROGRAM_NAME	VARCHAR2(30)	Name of the program
COMMENTS	VARCHAR2(240)	Comments on the step

See also

DBA_SCHEDULER_STEPS

USER_SCHEDULER_STEPS

3.2.63. ALL_SCHEDULER_STEP_CTX

Displays all scheduler step context the current user can access.

Columns

Column Name	Data Type	Description
OWNER_ID	NUMBER	ID of the owner
CHAIN_NAME	VARCHAR2(30)	Name of the chain
STEP_NAME	VARCHAR2(30)	Name of the step
CTX_ID	NUMBER	This column is for internal use.
JOB_ID	NUMBER	ID of the job
INSTANCE_ID	NUMBER	ID of the instance (for TAC)
COMPLETED	VARCHAR2(5)	State of the step context (completed or not)
STATE	VARCHAR2(16)	State of the step context
START_DATE	TIMESTAMP(6)	This column is for internal use.
END_DATE	TIMESTAMP(6)	This column is for internal use.
ERROR_CODE	NUMBER	This column is for internal use.
DURATION	INTERVAL	This column is for future use.

See also

DBA_SCHEDULER_STEP_CTX

USER_SCHEDULER_STEP_CTX

3.2.64. ALL_SEGMENTS

Displays all segments that the current user can access.

Columns

Column Name	Data Type	Description
SEGMENT_NAME	VARCHAR(128)	Name of the segment
PARTITION_NAME	VARCHAR(128)	Partition number of the object (Set to NULL for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(18)	Type of the segment - TABLE - TABLE PARTITION - TABLE SUBPARTITION - LOB - INDEX - INDEX PARTITION - INDEX SUBPARTITION - LOB - LOB PARTITION - LOB SUBPARTITION - UNDO
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the segment
HEADER_FILE	NUMBER	ID of the file containing the segment header
HEADER_BLOCK	NUMBER	ID of the block containing the segment header
BLOCKS	NUMBER	Size of the segment in blocks
EXTENTS	NUMBER	Size of the segment in extents
RELATIVE_FNO	NUMBER	Relative file number of the segment header
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_EXTENTS	NUMBER	Maximum number of extents that the segment can use
BYTES	NUMBER	Size of segment in bytes
INITIAL_EXTENT	NUMBER	Size in bytes requested for the initial extent of the segment
NEXT_EXTENT	NUMBER	Size in bytes of the next extent to be allocated to the segment

See also

DBA_SEGMENTS

USER_SEGMENTS

3.2.65. ALL_SEQUENCES

Displays all sequences that the current user can access.

Columns

Column Name	Data Type	Description
SEQUENCE_OWNER	VARCHAR(128)	Owner of the sequence
SEQUENCE_NAME	VARCHAR(128)	Name of the sequence
MIN_VALUE	NUMBER	Minimum value of the sequence
MAX_VALUE	NUMBER	Maximum value of the sequence
INCREMENT_BY	NUMBER	Increment value of the sequence
CYCLE_FLAG	VARCHAR(1)	Whether the sequence is reused when the maximum value is reached - Y - N - E
ORDER_FLAG	CHAR(1)	Whether sequences are generated in order - Y
IF_AVAIL	VARCHAR(1)	Whether the last value is readable - Y - N - E
CACHE_SIZE	NUMBER	The number of cached sequences
LAST_NUMBER	NUMBER	Last sequence number to be written to disk

See also

DBA_SEQUENCES

USER_SEQUENCES

3.2.66. ALL_SOURCE

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
NAME	VARCHAR(128)	Name of the object
TYPE	VARCHAR(12)	Type of the object - PROCEDURE - FUNCTION - PACKAGE - PACKAGE BODY - TRIGGER - TYPE - TYPE BODY - UNDEFINED
LINE	NUMBER	Line number of the source
TEXT	VARCHAR(4000)	Source text

See also

DBA_SOURCE

USER_SOURCE

3.2.67. ALL_SUBPART_KEY_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the partitioned table or index
NAME	VARCHAR(128)	Name of the partitioned table or index
OBJECT_TYPE	VARCHAR(5)	Type of the object - TABLE - INDEX
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the subpartitioning key

See also

DBA_SUBPART_KEY_COLUMNS

USER_SUBPART_KEY_COLUMNS

3.2.68. ALL_SYNONYMS

Displays all synonyms that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the synonym
SYNONYM_NAME	VARCHAR(128)	Name of the synonym
ORG_OBJECT_OWNER	VARCHAR(128)	Owner of the object to which the synonym refers
ORG_OBJECT_NAME	VARCHAR(257)	Name of the object to which the synonym refers

See also

DBA_SYNONYMS

USER_SYNONYMS

3.2.69. ALL_TABLES

Displays all tables that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace that contains the table
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows within the table
BLOCKS	NUMBER	The number of data blocks containing information about the table
AVG_ROW_LEN	NUMBER	Average length of rows within the table (in bytes)
DEGREE	NUMBER	The number of threads used for table scanning
SAMPLE_SIZE	NUMBER	Size of the sample used for analyzing statistics for the table
LAST_ANALYZED	DATE	Date of the most recent analysis for the table
PARTITIONED	VARCHAR(3)	Whether partitioning is used or not - YES - NO
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
ROW_MOVEMENT	VARCHAR(8)	Whether or not partitioned row movement is enabled - ENABLED - DISABLED
DURATION	VARCHAR(11)	Retention period of the temporary table - SESSION: Rows are preserved during the session period - TRANSACTION: Rows are deleted at every commit
COMPRESSION	VARCHAR(3)	Whether or not the table has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the table - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
DROPPED	VARCHAR(3)	Whether or not the table has been dropped - YES - NO
READ_ONLY	VARCHAR(3)	Whether or not the table is in read-only mode - YES - NO
TEMPORARY	VARCHAR(3)	Whether or not the table is temporary - YES - NO
IOT_TYPE	VARCHAR(12)	If the table is an index-organized table, the IOT_TYPE is IOT or IOT_OVERFLOW. If the table is not an index-organized table, the IOT_TYPE is NULL - IOT - IOT_OVERFLOW - NULL
MAX_EXTENTS	NUMBER	Maximum number of extents that the table can use
INITIAL_EXTENT	NUMBER	Size in bytes of the initial extent
NEXT_EXTENT	NUMBER	Size in bytes of the next extent to be allocated to the table
MIN_EXTENTS	NUMBER	Minimum number of extents that the table can use
IS_VIRTUAL	VARCHAR(1)	Whether or not the table is virtual

See also

DBA_TABLES

USER_TABLES

3.2.70. ALL_TAB_COLS

Synonym for ALL_TBL_COLS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
NUM_NULLS	NUMBER	(Not supported)
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
HIDDEN_COLUMN	CHAR(3)	(Not supported)
SEGMENT_COLUMN_ID	VARCHAR(3)	(Not supported)
INTERNAL_COLUMN_ID	VARCHAR(3)	(Not supported)
QUALIFIED_COL_NAME	VARCHAR(4000)	(Not supported)
OBJ_ID	NUMBER	ID of the object

See also

ALL_TBL_COLS

DBA_TAB_COLS

DBA_TBL_COLS

USER_TAB_COLS

USER_TBL_COLS

3.2.71. ALL_TAB_COLUMNS

Synonym for ALL_TBL_COLUMNS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
OBJ_ID	NUMBER	ID of the object

See also

ALL_TBL_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TAB_COLUMNS

DBA_TBL_COLUMNS

USER_TAB_COLUMNS

USER_TBL_COLUMNS

3.2.72. ALL_TAB_COL_STATISTICS

Synonym for ALL_TBL_COL_STATISTICS.

Columns

Column Name	Data Type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
NUM_DISTINCT	NUMBER	The number of distinct values
LOW_VALUE	VARCHAR(4000)	The lowest value in the column
HIGH_VALUE	VARCHAR(4000)	The highest value in the column
DENSITY	NUMBER	Density of the column
NUM_NULLS	NUMBER	The number of NULL values
NUM_BUCKETS	NUMBER	The number of buckets for the histogram
LAST_ANALYZED	DATE	Date of the most recent analysis for the column
SAMPLE_SIZE	NUMBER	Size of the sample used for analyzing statistics for the column
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
HISTOGRAM	VARCHAR(15)	Indicates the type of histogram

See also

ALL_TBL_COL_STATISTICS

DBA_TAB_COL_STATISTICS

DBA_TBL_COL_STATISTICS

USER_TAB_COL_STATISTICS

USER_TBL_COL_STATISTICS

3.2.73. ALL_TAB_COMMENTS

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

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the object
TABLE_NAME VARCHAR(128)
Name of the object
TABLE_TYPE VARCHAR(9)
Type of the object
COMMENTS VARCHAR(4000)
Comment on the object
See also

ALL_TBL_COMMENTS

DBA_TAB_COMMENTS

DBA_TBL_COMMENTS

3.2.74. ALL_TAB_HISTOGRAMS

Synonym for ALL_TBL_HISTOGRAMS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
ENDPOINT_NUMBER	NUMBER	History bucket number
ENDPOINT_VALUE	NUMBER	End point value of the current bucket
ENDPOINT_ACTUAL_VALUE	VARCHAR(4000)	Actual string value of the end point value of the current bucket

See also

ALL_TBL_HISTOGRAMS

DBA_TAB_HISTOGRAMS

DBA_TBL_HISTOGRAMS

USER_TAB_HISTOGRAMS

USER_TBL_HISTOGRAMS

3.2.75. ALL_TAB_PARTITIONS

Synonym for ALL_TBL_PARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
COMPOSITE	VARCHAR(3)	Whether or not the partition belongs to a composite-partitioned table - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_COUNT	NUMBER	The number of subpartitions which belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the partition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
NUM_ROWS	NUMBER	The number of rows within the table partition
BLOCKS	NUMBER	The number of data blocks containing information about the table partition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table partition
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO

See also

ALL_TBL_PARTITIONS

DBA_TAB_PARTITIONS

DBA_TBL_PARTITIONS

USER_TAB_PARTITIONS

USER_TBL_PARTITIONS

3.2.76. ALL_TAB_PRIVS

Synonym for ALL_TBL_PRIVS.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with GRANT OPTION - YES - NO

See also

ALL_TBL_PRIVS

DBA_TAB_PRIVS

DBA_TBL_PRIVS

USER_TAB_PRIVS

USER_TBL_PRIVS

3.2.77. ALL_TAB_PRIVS_MADE

Synonym for ALL_TBL_PRIVS_MADE.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

ALL_TBL_PRIVS_MADE

USER_TAB_PRIVS_MADE

USER_TBL_PRIVS_MADE

3.2.78. ALL_TAB_PRIVS_RECD

Synonym for ALL_TBL_PRIVS_RECD.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

ALL_TBL_PRIVS_RECD

3.2.79. ALL_TAB_SUBPARTITIONS

Synonym for ALL_TBL_SUBPARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the table subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number within the partition
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the table subpartition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows within the table subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table subpartition

See also

ALL_TBL_SUBPARTITIONS

DBA_TAB_SUBPARTITIONS

DBA_TBL_SUBPARTITIONS

3.2.80. ALL_TBL_COLS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
NUM_NULLS	NUMBER	(Not supported)
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
HIDDEN_COLUMN	CHAR(3)	(Not supported)
SEGMENT_COLUMN_ID	VARCHAR(3)	(Not supported)
INTERNAL_COLUMN_ID	VARCHAR(3)	(Not supported)
QUALIFIED_COL_NAME	VARCHAR(4000)	(Not supported)
OBJ_ID	NUMBER	ID of the object

See also

ALL_TAB_COLS

DBA_TAB_COLS

DBA_TBL_COLS

USER_TAB_COLS

USER_TBL_COLS

3.2.81. ALL_TBL_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
OBJ_ID	NUMBER	ID of the object

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TAB_COLUMNS

DBA_TBL_COLUMNS

USER_TAB_COLUMNS

USER_TBL_COLUMNS

3.2.82. ALL_TBL_COLUMNS_WITH_DNO

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_TYPE_NO	NUMBER	Data type number of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
OBJ_ID	NUMBER	ID of the object

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS

DBA_TAB_COLUMNS

DBA_TBL_COLUMNS

USER_TAB_COLUMNS

USER_TBL_COLUMNS

3.2.83. ALL_TBL_COL_STATISTICS

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

Columns

Column Name	Data Type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
NUM_DISTINCT	NUMBER	The number of distinct values
LOW_VALUE	VARCHAR(4000)	The lowest value in the column
HIGH_VALUE	VARCHAR(4000)	The highest value in the column
DENSITY	NUMBER	Density of the column
NUM_NULLS	NUMBER	The number of NULL values
NUM_BUCKETS	NUMBER	The number of buckets for the histogram
LAST_ANALYZED	DATE	Date of the most recent analysis for the column
SAMPLE_SIZE	NUMBER	Size of the sample used for analyzing statistics for the column
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
HISTOGRAM	VARCHAR(15)	Indicates the type of histogram

See also

ALL_TAB_COL_STATISTICS

DBA_TAB_COL_STATISTICS

DBA_TBL_COL_STATISTICS

USER_TAB_COL_STATISTICS

USER_TBL_COL_STATISTICS

3.2.84. ALL_TBL_COMMENTS

Synonym for ALL_TAB_COMMENTS.

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the object
TABLE_NAME VARCHAR(128)
Name of the object
TABLE_TYPE VARCHAR(9)
Type of the object
COMMENTS VARCHAR(4000)
Comment on the object
See also

ALL_TAB_COMMENTS

DBA_TAB_COMMENTS

DBA_TBL_COMMENTS

3.2.85. ALL_TBL_HISTOGRAMS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
ENDPOINT_NUMBER	NUMBER	History bucket number
ENDPOINT_VALUE	NUMBER	End point value of the current bucket
ENDPOINT_ACTUAL_VALUE	VARCHAR(4000)	Actual string value of the end point value of the current bucket

See also

ALL_TAB_HISTOGRAMS

DBA_TAB_HISTOGRAMS

DBA_TBL_HISTOGRAMS

USER_TAB_HISTOGRAMS

USER_TBL_HISTOGRAMS

3.2.86. ALL_TBL_PARTITIONS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
COMPOSITE	VARCHAR(3)	Whether or not the partition belongs to a composite-partitioned table - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_COUNT	NUMBER	The number of subpartitions which belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the partition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
NUM_ROWS	NUMBER	The number of rows within the table partition
BLOCKS	NUMBER	The number of data blocks containing information about the table partition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table partition
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO

See also

ALL_TAB_PARTITIONS

DBA_TAB_PARTITIONS

DBA_TBL_PARTITIONS

USER_TAB_PARTITIONS

USER_TBL_PARTITIONS

3.2.87. ALL_TBL_PRIVS

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with GRANT OPTION - YES - NO

See also

ALL_TAB_PRIVS

DBA_TAB_PRIVS

DBA_TBL_PRIVS

USER_TAB_PRIVS

USER_TBL_PRIVS

3.2.88. ALL_TBL_PRIVS_MADE

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

ALL_TAB_PRIVS_MADE

USER_TAB_PRIVS_MADE

USER_TBL_PRIVS_MADE

3.2.89. ALL_TBL_PRIVS_RECD

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

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

ALL_TAB_PRIVS_RECD

3.2.90. ALL_TBL_SUBPARTITIONS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the table subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number within the partition
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the table subpartition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows within the table subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table subpartition

See also

ALL_TAB_SUBPARTITIONS

DBA_TAB_SUBPARTITIONS

DBA_TBL_SUBPARTITIONS

3.2.91. ALL_TRIGGERS

Displays all triggers that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the trigger
TRIGGER_NAME	VARCHAR(128)	Name of the trigger
TRIGGER_TYPE	VARCHAR(16)	When the trigger is enabled - BEFORE STATEMENT - BEFORE EACH ROW - AFTER STATEMENT - AFTER EACH ROW
TRIGGERING_EVENT	VARCHAR(52)	Event that activates the trigger
TABLE_OWNER	VARCHAR(128)	Owner of the table where the trigger is defined
TABLE_NAME	VARCHAR(128)	Name of the table where the trigger is defined
REFERENCING_NAMES	VARCHAR(422)	Name to which the trigger refers to read OLD and NEW column values
WHEN_CLAUSE	LONG	Conditions that should be evaluated before the trigger is enabled
STATUS	VARCHAR(8)	Whether or not the trigger is enabled

See also

DBA_TRIGGERS

USER_TRIGGERS

3.2.92. ALL_TRIGGER_COLS

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

Columns

Column Name	Data Type	Description
TRIGGER_OWNER	VARCHAR(128)	Owner of the trigger
TRIGGER_NAME	VARCHAR(128)	Name of the trigger
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_LIST	VARCHAR(3)	Whether or not the column is used in UPDATE OF clause (Yes/No)
COLUMN_USAGE	VARCHAR(17)	Column usage in the trigger

See also

DBA_TRIGGER_COLS

USER_TRIGGER_COLS

3.2.93. ALL_TYPES

Displays all types that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
TYPE_OID	RAW(16)	Object identifier (OID) of this type
TYPECODE	VARCHAR(10)	Typecode of this type
ATTRIBUTES	NUMBER	The number of attributes for this type
METHODS	NUMBER	The number of methods for this type
PREDEFINED	VARCHAR(3)	Indicates whether this type is predefined (Not supported)
INCOMPLETE	VARCHAR(3)	Indicates whether this type is incomplete (Not supported)
FINAL	VARCHAR(3)	Indicates whether this type is final
INSTANTIABLE	VARCHAR(3)	Indicates whether this type is instantiable
SUPERTYPE_OWNER	VARCHAR(128)	Owner of this supertype
SUPERTYPE_NAME	VARCHAR(128)	Name of this supertype
LOCAL_ATTRIBUTES	VARCHAR(256)	The number of local attributes
LOCAL_METHODS	VARCHAR(256)	The number of the local methods
TYPEID	RAW(8)	TYPEID of this type

See also

DBA_TYPES

USER_TYPES

3.2.94. ALL_TYPE_ATTRS

Displays all the attributes that the current user can access.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
ATTR_NAME	VARCHAR(128)	Name of this attribute
ATTR_TYPE_MOD	VARCHAR(7)	Modifier of this attribute type (not supported)
ATTR_TYPE_OWNER	VARCHAR(128)	Owner of this attribute type
ATTR_TYPE_NAME	VARCHAR(128)	Name of this attribute type
LENGTH	NUMBER	Length of this type (not supported)
PRECISION	NUMBER	Precision of this type
SCALE	NUMBER	Scale of this type
CHARACTER_SET_NAME	VARCHAR(128)	Name of the Character set (not supported)
ATTR_NO	NUMBER	Attribute number
INHERITED	VARCHAR(3)	Indicates whether this is inherited

See also

DBA_TYPE_ATTRS

USER_TYPE_ATTRS

3.2.95. ALL_TYPE_METHODS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of this type
TYPE_NAME	VARCHAR(128)	Name of this type
METHOD_NAME	VARCHAR(128)	Name of this method
METHOD_NO	NUMBER	Method number for this method (not supported)
METHOD_TYPE	VARCHAR(11)	Type of this method
PARAMETERS	NUMBER	The number of parameters
RESULTS	VARCHAR(3)	Indicates whether this method has results to return.
FINAL	VARCHAR(3)	Indicates whether this method is final. (not supported)
INSTANTIABLE	VARCHAR(3)	Indicates whether this method is instantiable. (not supported)
OVERRIDING	VARCHAR(3)	Indicates whether this method is overriding a supertype method. (not supported)
INHERITED	VARCHAR(3)	Indicates whether this is inherited from a supertype method. (not supported)
STATIC	VARCHAR(3)	Indicates whether this method is static.
CONSTRUCTOR	VARCHAR(3)	Indicates whether this method is constructor.

See also

DBA_TYPE_METHODS

USER_TYPE_METHODS

3.2.96. ALL_UPDATABLE_COLUMNS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
UPDATABLE	VARCHAR(3)	Whether or not the column is updatable - YES - NO
INSERTABLE	VARCHAR(3)	Whether or not the column is insertable - YES - NO
DELETABLE	VARCHAR(3)	Whether or not column is deletable - YES - NO

See also

DBA_UPDATABLE_COLUMNS

USER_UPDATABLE_COLUMNS

3.2.97. ALL_USERS

Displays all users that the current user can view.

Columns

Column Name Data Type Description
USERNAME VARCHAR(128)
Name of the user
USER_ID NUMBER
ID of the user
CREATED DATE
Date that the user was created
See also

DBA_USERS

USER_USERS

3.2.98. ALL_VIEWS

Displays all views that the current user can access.

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the view
VIEW_NAME VARCHAR(128)
Name of the view
TEXT LONG
Definition of the view
See also

ALL_VIEWS_INTERNAL

DBA_VIEWS

USER_VIEWS

3.2.99. ALL_VIEWS_INTERNAL

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

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the view
VIEW_NAME VARCHAR(128)
Name of the view
OBJ_ID NUMBER
ID of the view
See also

ALL_VIEWS

DBA_VIEWS

USER_VIEWS

3.2.100. DATABASE_PROPERTIES

Displays database properties.

Columns

Column Name Data Type Description
NAME VARCHAR(128)
Name of the property
VALUE VARCHAR(80)
Value of the property
COMMENT_STR VARCHAR(4000)
Description of the property

3.2.101. DBA_2PC_NEIGHBORS

Displays connection information for pending transactions.

Columns

Column Name	Data Type	Description
LOCAL_TRAN_ID	VARCHAR(65532)	ID of the transaction
IN_OUT	NUMBER	Connection status - IN: Incoming connection - OUT: Outgoing connection
DATABASE	VARCHAR(128)	Name of the database - IN: Client database name - OUT: Database link name
DBUSER_OWNER	VARCHAR(128)	Name of the owner - IN: Name of the user who accesses the database - OUT: Owner of the database link
INTERFACE	VARCHAR(1)	Type of the interface - C: Commit point site - N: Non-commit point site

3.2.102. DBA_2PC_PENDING

Displays pending transaction information.

Columns

Column Name Data Type Description
LOCAL_TRAN_ID VARCHAR(65532)
ID of the transaction
XID VARCHAR(550)
XID
STATUS VARCHAR(15)
Status of the XA transaction

3.2.103. DBA_AUDIT_TRAIL

Displays audit trails within the database.

Columns

Column Name	Data Type	Description
OS_USERNAME	VARCHAR(128)	Operating system user name who was set to be audited
USERNAME	VARCHAR(128)	Name of the user who was set to be audited
USERHOST	VARCHAR(21)	Name of the host machine from which the client has connected
TIMESTAMP	VARCHAR(19)	Audit trail-created time
OWNER	VARCHAR(128)	Owner of the object associated with the audited action
OBJ_NAME	VARCHAR(128)	Name of the object associated with the audited action
SESSIONID	NUMBER	Session ID
SERIALNO	NUMBER	Sequence number of the session
ENTRYID	NUMBER	Sequence number for each audit trail in the session
STATEMENTID	NUMBER	ID of the executed statement
PRIV_USED	VARCHAR(80)	Name of the privilege used to execute the audited action
CLIENT_ID	VARCHAR(30)	Client identifier
INSTANCE_NUMBER	NUMBER	Instance number of RDBMS which performed the action
OS_PROCESS	VARCHAR(16)	Process ID of RDBMS
TRANSACTIONID	VARCHAR(65532)	Transaction ID that participated in the audited action
TSN	NUMBER	TSN of the audited action
SQL_TEXT	LONG	SQL of the audited action

See also

USER_AUDIT_TRAIL

3.2.104. DBA_CATALOG

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

See also

ALL_CATALOG

USER_CATALOG

3.2.105. DBA_COLL_TYPES

Displays all the collection types.

See also

ALL_COLL_TYPES

USER_COLL_TYPES

3.2.106. DBA_COL_COMMENTS

Displays comments on all columns in the database.

See also

ALL_COL_COMMENTS

USER_COL_COMMENTS

3.2.107. DBA_COL_PRIVS

Displays object privileges of all columns of the database.

See also

ALL_COL_PRIVS

USER_COL_PRIVS

3.2.108. DBA_CONSTRAINTS

Displays integrity constraints defined in the database table.

See also

ALL_CONSTRAINTS

USER_CONSTRAINTS

3.2.109. DBA_CONS_COLUMNS

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

See also

ALL_CONS_COLUMNS

USER_CONS_COLUMNS

3.2.110. DBA_DATAFILES

Synonym for DBA_DATA_FILES.

Columns

Column Name	Data Type	Description
FILE_NAME	VARCHAR(256)	Name of the data file
FILE_ID	NUMBER	ID of the data file
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace where the data file is contained.
BYTES	NUMBER	Size of the data file in bytes
BLOCKS	NUMBER	Size of the data file in blocks
STATUS	CHAR(9)	Status of the data file - UNUSED - ONLINE - OFFLINE - RESETLOG - RECOVERY
RELATIVE_FNO	NUMBER	Relative data file number
AUTOEXTENSIBLE	VARCHAR(3)	Auto extensible indicator - YES - NO
MAXBYTES	NUMBER	Maximum data file size in bytes
MAXBLOCKS	NUMBER	Maximum data file size in blocks
INCREMENT_BY	NUMBER	Auto increment value

See also

DBA_DATA_FILES

3.2.111. DBA_DATA_FILES

Displays data file information.

Columns

Column Name	Data Type	Description
FILE_NAME	VARCHAR(256)	Name of the data file
FILE_ID	NUMBER	ID of the data file
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace where the data file is contained.
BYTES	NUMBER	Size of the data file in bytes
BLOCKS	NUMBER	Size of the data file in blocks
STATUS	CHAR(9)	Status of the data file - UNUSED - ONLINE - OFFLINE - RESETLOG - RECOVERY
RELATIVE_FNO	NUMBER	Relative data file number
AUTOEXTENSIBLE	VARCHAR(3)	Auto extensible indicator - YES - NO
MAXBYTES	NUMBER	Maximum data file size in bytes
MAXBLOCKS	NUMBER	Maximum data file size in blocks
INCREMENT_BY	NUMBER	Auto increment value

See also

DBA_DATAFILES

3.2.112. DBA_DB_LINKS

Displays information for all database links.

See also

ALL_DB_LINKS

USER_DB_LINKS

3.2.113. DBA_DEPENDENCIES

Displays dependencies of all objects.

See also

ALL_DEPENDENCIES

USER_DEPENDENCIES

3.2.114. DBA_DIRECTORIES

Displays all directories in the database.

See also

ALL_DIRECTORIES

3.2.115. DBA_ENCRYPTED_COLUMNS

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

See also

ALL_ENCRYPTED_COLUMNS

USER_ENCRYPTED_COLUMNS

3.2.116. DBA_ERRORS

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.

See also

ALL_ERRORS

USER_ERRORS

3.2.117. DBA_EXTENTS

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the segment containing the extent
SEGMENT_NAME	VARCHAR(128)	Name of the segment containing the extent
PARTITION_NAME	VARCHAR(128)	Partition name of the object (Null value for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(18)	Type of the segment
TABLESPACE_NAME	VARCHAR(30)	Name of the tablespace containing the extent
EXTENT_ID	NUMBER	ID of the extent
FILE_ID	NUMBER	ID of the file containing the extent
BLOCK_ID	NUMBER	Starting block number of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in blocks
RELATIVE_FNO	NUMBER	Relative file number of the extent

See also

USER_EXTENTS

3.2.118. DBA_EXTERNAL_LOCATIONS

Displays all external table locations in the database.

See also

ALL_EXTERNAL_LOCATIONS

USER_EXTERNAL_LOCATIONS

3.2.119. DBA_EXTERNAL_TABLES

Displays all external tables in the database.

See also

ALL_EXTERNAL_TABLES

USER_EXTERNAL_TABLES

3.2.120. DBA_FREE_SPACE

Displays information of the extents that all tablespaces can use.

Columns

Column Name	Data Type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the extent
FILE_ID	NUMBER	ID of the file containing the extent
BLOCK_ID	NUMBER	Starting block number of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in blocks
RELATIVE_FNO	NUMBER	Relative file number of the extent

See also

USER_FREE_SPACE

3.2.121. DBA_HIST_ACTIVE_SESS_HISTORY

Displays history information on active sessions.

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Snap ID
SAMPLE_ID	NUMBER	Sample ID
THREAD#	NUMBER	Thread#
SAMPLE_TIME	DATE	Sample Time
SESSION_ID	NUMBER	Session ID
SESS_SERIAL_NO	NUMBER	A serial number of a session
USER_NO	NUMBER	The user's ID
WAIT_EVENT	NUMBER	Type of the wait event which the session waits
TIME_WAITED	NUMBER	The amount of time waited for this event (msec)
SQL_ID	VARCHAR(13)	SQL identifier
SQL_CHILD_NUMBER	NUMBER	The number of this child physical plan
CURR_HASHVAL	NUMBER	SQL hash value
MODULE_NAME	VARCHAR(64)	Name of a module specified by dbms_application_info.set_module
ACTION_NAME	VARCHAR(64)	Name of an action specified by dbms_application_info.set_module/action
CLIENT_INFO_NAME	VARCHAR(64)	Name of client_info specified by dbms_application_info.set_client_info
PROG_NAME	VARCHAR(30)	Client program name
SQL_EXEC_START	DATE	The time when the execution started.
SQL_EXEC_ID	NUMBER	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_ID	NUMBER	Identifier of the plan operation
ID1	NUMBER	First Parameter
ID2	NUMBER	Second Parameter
WE_SEQ	NUMBER	Sequence# of the Wait Event
USGMT_ID	NUMBER	USGMT number at the time of sampling
SLOTNO	NUMBER	Slot number at the time of sampling
WRAPNO	NUMBER	Wrap number at the time of sampling
PORT	NUMBER	Client port number
DELTA_TIME	NUMBER	Time interval (in seconds) since the last time this session was sampled or created.
DELTA_PHY_READ_BLKS	NUMBER	The number of blocks read from disk over the last DELTA_TIME seconds
DELTA_PHY_WRITE_BLKS	NUMBER	The number of blocks written to disk over the last DELTA_TIME seconds
DELTA_LOG_READ_BLKS	NUMBER	The number of blocks read over the last DELTA_TIME seconds
PGA_SIZE	NUMBER	The amount of PGA memory consumed by this session
WAIT_OBJ_ID	NUMBER	ID of the object which the session waits
WAIT_FILE_NO	NUMBER	Number of the file which the session waits
WAIT_BLOCK_NO	NUMBER	Number of the block which the session waits
WAIT_ROW_NO	NUMBER	Number of the row which the session waits
WAIT_EVENT_NAME	VARCHAR(40)	Name of wait_event

3.2.122. DBA_HIST_FILESTAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
FILE#	NUMBER	File number
PHYRDS	NUMBER	The number of read operations performed
PHYWRTS	NUMBER	The number of write operations performed
READTIM	NUMBER	Time spent on read operations (msec)
WRITETIM	NUMBER	Time spent on write operations (msec)
PHYBLKRD	NUMBER	The number of blocks read
PHYBLKWRT	NUMBER	The number of blocks written

3.2.123. DBA_HIST_LATCH

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
LATCH#	NUMBER	Spinlock number
GETS	NUMBER	The number of times a spinlock was acquired
MISSES	NUMBER	The number of times the requester had to wait for a spinlock
SLEEPS	NUMBER	The number of times the requester was put to sleep while waiting for a spinlock
IMMEDIATE_GETS	NUMBER	The number of times a trylock was acquired
IMMEDIATE_MISSES	NUMBER	The number of times the requester failed to acquire a trylock
SPIN_GETS	NUMBER	The number of times the requester failed to acquire a spinlock but succeeded in gaining a spin
WAIT_TIME	NUMBER	The total sleep time of spinlock
SLEEPS_CNT	NUMBER	The number of actual sleep count while waiting for a spinlock

3.2.124. DBA_HIST_LIBRARYCACHE

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
NAMESPACE	VARCHAR(16)	Name of the table
GETS	NUMBER	Cache total access count
GETHITS	NUMBER	Cache hit count

3.2.125. DBA_HIST_OSSTAT

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

Columns

Column Name Data Type Description
SNAP_ID NUMBER
Unique ID of a snapshot
INSTANCE_NUMBER NUMBER
Instance number of the snapshot
STAT_ID NUMBER
Identifier of OS statistics
VALUE NUMBER
OS statistics value

3.2.126. DBA_HIST_PGASTAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
NAME	VARCHAR(64)	Name of a PGA statistics
VALUE	NUMBER	Value of the PGA statistics
SNAP_TIME	DATE	Snapshot time of PGA statistics

3.2.127. DBA_HIST_PROCESS_MEM_SUMMARY

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot.
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
NUM_PROCESSES	NUMBER	Number of processes
NON_ZERO_USES	NUMBER	Number of processes with non-zero memory usage
USED_TOTAL	NUMBER	Total size of local memory occupied
USED_AVG	NUMBER	Average size of local memory occupied
USED_STDDEV	NUMBER	Standard deviation of local memory occupied
USED_MAX	NUMBER	Maximum size of local memory occupied

3.2.128. DBA_HIST_SEG_STAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
OBJ_ID	NUMBER	Object ID
STATISTICS#	NUMBER	Segment statistics type
STATISTICS_NAME	VARCHAR(64)	Name of the segment statistics
VALUE	NUMBER	Value of the segment statistics

3.2.129. DBA_HIST_SGASTAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
NAME	VARCHAR(40)	Purpose for which shared pool is used
SIZE	NUMBER	Usage of shared pool

3.2.130. DBA_HIST_SNAPSHOT

Displays information about TPR snapshots.

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
BEGIN_INTERVAL_TIME	DATE	Start time of a snapshot interval
END_INTERVAL_TIME	DATE	End time of a snapshot interval

3.2.131. DBA_HIST_SQLSTAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
SQL_HASH_VALUE	NUMBER	Hash value of the SQL statement
PLAN_HASH_VALUE	NUMBER	Hash value of the physical plan
LAST_ACTIVE_TIME	DATE	Last time that statistics were collected
PARSE_CALLS	NUMBER	The number of parsing requests
FETCHES	NUMBER	The number of fetching times
EXECUTIONS	NUMBER	The number of times for executing an SQL statement
BUFFER_GETS	NUMBER	Total number of buffers read in Consistent-Read mode
ROWS_PROCESSED	NUMBER	Total number of processed rows
ELAPSED_TIME	NUMBER	Total execution time (in microseconds)
DISK_READ_TIME	NUMBER	Total disk read time
TEMP_SGMT_READ_TIME	NUMBER	Total temp segment read time
TEMP_SGMT_WRITE_TIME	NUMBER	Total temp segment write time

3.2.132. DBA_HIST_SQLTEXT

Displays historical information about texts of SQL statements.

Columns

Column Name	Data Type	Description
SQL_HASH_VALUE	NUMBER	Hash value of the SQL statement
SQL_TEXT	VARCHAR(64)	Text of an SQL statement split into 64-byte texts
COMMAND_TYPE	NUMBER	Number code of SQL statement type 1 - SELECT 2 - INSERT 3 - UPDATE 4 - DELETE 5 - MERGE 6 - CALL

3.2.133. DBA_HIST_SQL_PLAN

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

Columns

Column Name	Data Type	Description
SQL_HASH_VALUE	NUMBER	Hash value of the SQL statement
PLAN_HASH_VALUE	NUMBER	Hash value of the physical plan
ID	NUMBER	Number given to each job of the physical plan
OPERATION	VARCHAR(128)	Name of operation job
OBJECT_ID	NUMBER	Identifier of object accessed by the job
OBJECT_OWNER	VARCHAR(128)	Name of user to whom the object belongs
OBJECT_NAME	VARCHAR(128)	Object name
OBJECT_TYPE	VARCAHR(20)	Object type
PARENT_ID	NUMBER	ID of a job to get the output of the current job of the physical plan as input
DEPTH	NUMBER	Tree level of the physical plan
POSITION	NUMBER	Positions between all the jobs with the same PARENT_ID
COST	NUMBER	Job cost estimated by query optimizer
CARDINALITY	NUMBER	The number of output results estimated by query optimizer
PARTITION_START	VARCHAR(38)	In a partitioned table, the start partition for access
PARTITION_STOP	VARCHAR(38)	In a partitioned table, the end partition for access
OTHER	VARCHAR(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_COST	NUMBER	CPU cost of the operation as estimated by query optimizer
IO_COST	NUMBER	I/O cost of the operation as estimated by query optimizer
ACCESS_PREDICATES	VARCHAR(4000)	Predicate information to access indexes indexes or to handle joins
FILTER_PREDICATES	VARCHAR(4000)	Predicate information to handle filters

3.2.134. DBA_HIST_SQL_WORKAREA_HSTGRM

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
LOW_OPTIMAL_SIZE	NUMBER	The lower bounding value (in bytes) for the optimal size
HIGH_OPTIMAL_SIZE	NUMBER	The higher bounding value (in bytes) for the optimal size
OPTIMAL_EXECUTIONS	NUMBER	The number of work areas that were executed in optimal mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound
ONEPASS_EXECUTIONS	NUMBER	The number of work areas that were executed in onepass mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound
MULTIPASSES_EXECUTIONS	NUMBER	The number of work areas that were executed in multipass mode within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound
TOTAL_EXECUTIONS	NUMBER	The total number of work areas that were executed within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

3.2.135. DBA_HIST_SYSMETRIC_SUMMARY

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
THREAD#	NUMBER	Thread#
BEGIN_TIME	DATE	Begin Time of the Sample
END_TIME	DATE	End Time of the Sample @column GROUP_ID NUMBER Group ID
METRIC_ID	NUMBER	Metric ID
METRIC_NAME	VARCHAR(64)	Metric Name
METRIC_UNIT	VARCHAR(64)	Descriptions of the Metric Unit
MINVAL	NUMBER	Minimum value observed
MINVAL	NUMBER	Maximum value observed
AVERAGE	NUMBER	Average over the period
STD	NUMBER	One standard deviation

3.2.136. DBA_HIST_SYSTEM_EVENT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
EVENT_NUMBER	NUMBER	Event number
TOTAL_WAITS	NUMBER	Total number of event calls
TIME_WAITED	NUMBER	The amount of time waited for this event (msec)
AVERAGE_WAIT	NUMBER	The average amount of time waited for this event (msec)
MAX_WAIT	NUMBER	The maximum amount of time waited for this event (msec)
TOTAL_TIMEOUTS	NUMBER	The number of times that a time-out occurred in an event

3.2.137. DBA_HIST_UNDOSTAT

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

Columns

Column Name	Data Type	Description
END_TIME	DATE	End time of statistics
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
SNAP_ID	NUMBER	Unique ID of a snapshot
UNDO_TSNO	NUMBER	Tablespace number
UNDOBLKS	NUMBER	The number of used undo blocks
TXCOUNT	NUMBER	Total number of executed transactions
MAXCONCURRENCY	NUMBER	The largest number of concurrently executed transactions.
SNAP_TOO_OLD_CNT	NUMBER	The number of errors caused by failing to read old data
NOSPACEERRCNT	NUMBER	The number of errors caused by lack of undo storage space
ACTIVEBLKS	NUMBER	The number of blocks in use
UNEXPIREDBLKS	NUMBER	The number of non-reusable blocks
EXPIREDBLKS	NUMBER	The number of reusuable blocks

3.2.138. DBA_HIST_WAITSTAT

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

Columns

Column Name	Data Type	Description
SNAP_ID	NUMBER	Unique ID of a snapshot
INSTANCE_NUMBER	NUMBER	Instance number of the snapshot
CLASS	VARCHAR(20)	Block class (Block type)
WAIT_COUNT	NUMBER	The number of times waiting for the block class
TIME	NUMBER	Total time spent waiting for the block class

3.2.139. DBA_IDX_COLUMNS

Displays index columns of all tables in the database.

See also

ALL_IDX_COLUMNS

ALL_IND_COLUMNS

DBA_IND_COLUMNS

USER_IDX_COLUMNS

USER_IND_COLUMNS

3.2.140. DBA_IDX_EXPRESSIONS

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

See also

ALL_IDX_EXPRESSIONS

ALL_IND_EXPRESSIONS

DBA_IND_EXPRESSIONS

USER_IDX_EXPRESSIONS

USER_IND_EXPRESSIONS

3.2.141. DBA_IDX_PARTITIONS

Displays all index partitions in the database.

See also

ALL_IDX_PARTITIONS

ALL_IND_PARTITIONS

DBA_IND_PARTITIONS

USER_IDX_PARTITIONS

USER_IND_PARTITIONS

3.2.142. DBA_IDX_SUBPARTITIONS

Displays subpartitions of all indexes in the database.

See also

ALL_IDX_SUBPARTITIONS

ALL_IND_SUBPARTITIONS

DBA_IND_SUBPARTITIONS

3.2.143. DBA_INDEXES

Displays indexes of all tables in the database.

See also

ALL_INDEXES

USER_INDEXES

3.2.144. DBA_IND_COLUMNS

Synonym for DBA_IDX_COLUMNS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_LENGTH	NUMBER	Length of the column within the index
DESCEND	VARCHAR(4)	Sorting order in columns - DESC - ASC

See also

ALL_IDX_COLUMNS

ALL_IND_COLUMNS

DBA_IDX_COLUMNS

USER_IDX_COLUMNS

USER_IND_COLUMNS

3.2.145. DBA_IND_EXPRESSIONS

Synonym for DBA_IDX_EXPRESSIONS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_EXPRESSION	LONG	Expression of the column within the index

See also

ALL_IDX_EXPRESSIONS

ALL_IND_EXPRESSIONS

DBA_IDX_EXPRESSIONS

USER_IDX_EXPRESSIONS

USER_IND_EXPRESSIONS

3.2.146. DBA_IND_PARTITIONS

Synonym for DBA_IDX_PARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
COMPOSITE	VARCHAR(3)	Whether or not partition belongs to a composite-partitioned index - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the partition
SUBPARTITION_COUNT	NUMBER	The number of the subpartitions that belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the index
BLEVEL	NUMBER	Level of B-tree index (The level is 0 for a B-tree with only a root node)
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
CLUSTERING_FACTOR	NUMBER	The clustering factor of the index
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
NUM_ROWS	NUMBER	The number of rows in the index
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_TRANS	NUMBER	Value of the MAX_TRANS parameter
INITIAL_EXTENT	NUMBER	Value of the INITIAL_EXTENT parameter
MIN_EXTENT	NUMBER	Value of the MIN_EXTENT parameter
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
LAST_ANALYZED	DATE	Date of the most recent analysis for the index partition

See also

ALL_IDX_PARTITIONS

ALL_IND_PARTITIONS

DBA_IDX_PARTITIONS

USER_IDX_PARTITIONS

USER_IND_PARTITIONS

3.2.147. DBA_IND_SUBPARTITIONS

Synonym for DBA_IDX_SUBPARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
PARTITION_NAME	VARCHAR(128)	Name of the index partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the index subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows in the index subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the subpartition

See also

ALL_IDX_SUBPARTITIONS

ALL_IND_SUBPARTITIONS

DBA_IDX_SUBPARTITIONS

3.2.148. DBA_JAVA_ARGUMENTS

Displays all parameters in the database.

See also

ALL_JAVA_ARGUMENTS

USER_JAVA_ARGUMENTS

3.2.149. DBA_JAVA_CLASSES

Displays all classes in the database.

See also

ALL_JAVA_CLASSES

USER_JAVA_CLASSES

3.2.150. DBA_JAVA_FIELDS

Displays all fields in the database.

See also

ALL_JAVA_FIELDS

USER_JAVA_FIELDS

3.2.151. DBA_JAVA_METHODS

Displays all methods in the database.

See also

ALL_JAVA_METHODS

USER_JAVA_METHODS

3.2.152. DBA_JOBS

Displays all jobs in the database.

See also

ALL_JOBS

USER_JOBS

3.2.153. DBA_LIBRARIES

Displays all libraries in the database.

See also

ALL_LIBRARIES

USER_LIBRARIES

3.2.154. DBA_LOBS

Displays LOBs which belong to all tables in the database.

See also

ALL_LOBS

USER_LOBS

3.2.155. DBA_LOB_PARTITIONS

Displays all LOB partitions in the database.

See also

ALL_LOB_PARTITIONS

USER_LOB_PARTITIONS

3.2.156. DBA_LOB_SUBPARTITIONS

Displays all LOB subpartitions in the database.

See also

ALL_LOB_SUBPARTITIONS

USER_LOB_SUBPARTITIONS

3.2.157. DBA_LOG_GROUPS

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

See also

ALL_LOG_GROUPS

USER_LOG_GROUPS

3.2.158. DBA_LOG_GROUP_COLUMNS

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

See also

ALL_LOG_GROUP_COLUMNS

USER_LOG_GROUP_COLUMNS

3.2.159. DBA_METHOD_PARAMS

Displays the method parameters of this type.

See also

ALL_METHOD_PARAMS

USER_METHOD_PARAMS

3.2.160. DBA_METHOD_RESULTS

Displays the result of the method of this type.

See also

ALL_METHOD_RESULTS

USER_METHOD_RESULTS

3.2.161. DBA_MVIEWS

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

See also

ALL_MVIEWS

USER_MVIEWS

3.2.162. DBA_MVIEW_COMMENTS

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

See also

ALL_MVIEW_COMMENTS

USER_MVIEW_COMMENTS

3.2.163. DBA_MVIEW_LOGS

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

See also

ALL_MVIEW_LOGS

USER_MVIEW_LOGS

3.2.164. DBA_OBJECTS

Displays all objects in the database.

See also

ALL_OBJECTS

USER_OBJECTS

3.2.165. DBA_OBJ_AUDIT_OPTS

Displays objects being audited in the database.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
OBJECT_NAME	VARCHAR(128)	Name of the object
OBJECT_TYPE	VARCHAR(9)	Type of the object - TABLE - VIEW - SEQUENCE - PROCEDURE - DIRECTORY - JAVA
ALT	VARCHAR(5)	ALTER auditing option for success or failure
DEL	VARCHAR(5)	DELETE auditing option for success or failure
IND	VARCHAR(5)	INDEX auditing option for success or failure
INS	VARCHAR(5)	INSERT auditing option for success or failure
LOC	VARCHAR(5)	LOCK auditing option for success or failure
SEL	VARCHAR(5)	SELECT auditing option for success or failure
UPD	VARCHAR(5)	UPDATE auditing option for success or failure
REF	VARCHAR(5)	REFERENCE auditing option for success or failure
EXE	VARCHAR(5)	EXECUTE auditing option for success or failure
REA	VARCHAR(5)	READ auditing option for success or failure
WRI	VARCHAR(5)	WRITE auditing option for success or failure

See also

USER_OBJ_AUDIT_OPTS

3.2.166. DBA_PACKAGE_MEMBER_TYPES

Displays types of the package.

See also

ALL_PACKAGE_MEMBER_TYPES

USER_PACKAGE_MEMBER_TYPES

3.2.167. DBA_PART_INDEXES

Displays partitioning information for the partitioned indexes in the database.

See also

ALL_PART_INDEXES

USER_PART_INDEXES

3.2.168. DBA_PART_KEY_COLUMNS

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

See also

ALL_PART_KEY_COLUMNS

USER_PART_KEY_COLUMNS

3.2.169. DBA_PART_LOBS

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

See also

ALL_PART_LOBS

USER_PART_LOBS

3.2.170. DBA_PART_TABLES

Displays partitioning information of the partitioned tables in the database.

See also

ALL_PART_TABLES

USER_PART_TABLES

3.2.171. DBA_PRIV_AUDIT_OPTS

Displays users being audited in the database.

Columns

Column Name	Data Type	Description
USER_NAME	VARCHAR(128)	Name of the user being audited
PROXY_NAME	VARCHAR(128)	PROXY name of the user being audited
PRIVILEGE	VARCHAR(40)	Name of the system privilege being audited
SUCCESS	VARCHAR(10)	Auditing option at success
FAILURE	VARCHAR(10)	Auditing option at failure

3.2.172. DBA_PROCEDURES

Displays all procedures in the database.

See also

ALL_PROCEDURES

USER_PROCEDURES

3.2.173. DBA_PROFILES

Describes all profiles in the database.

Columns

Column Name	Data Type	Description
PROFILE	VARCHAR(255)	Name of the profile
RESOURCE_NAME	VARCHAR(255)	Name of the resource
RESOURCE_TYPE	VARCHAR(8)	Indicates whether the resource profile is a KERNEL or a PASSWORD parameter
LIMIT	VARCHAR(256)	Limit placed on this resource for this profile

3.2.174. DBA_QUEUES

Describes all queues in the database.

See also

ALL_QUEUES

USER_QUEUES

3.2.175. DBA_QUEUE_SUBSCRIBERS

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

See also

ALL_QUEUE_SUBSCRIBERS

USER_QUEUE_SUBSCRIBERS

3.2.176. DBA_QUEUE_TABLES

Describes the queues in all queue tables in the database.

See also

ALL_QUEUE_TABLES

USER_QUEUE_TABLES

3.2.177. DBA_RECYCLEBIN

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the object
OBJECT_NAME	VARCHAR(128)	Current name of the object
ORIGINAL_NAME	VARCHAR(128)	Original name of the object
TYPE	VARCHAR(7)	Type of the object - Table - Index - Trigger
TS_NAME	VARCHAR(128)	Name of the tablespace containing the object
CREATETIME	VARCHAR(19)	Timestamp for the object creation
DROPTIME	VARCHAR(19)	Timestamp for the object deletion
DROPTSN	NUMBER	TSN of the transaction which dropped the object
BASE_OBJECT	VARCHAR(256)	Object ID of the base object
SPACE	VARCHAR(0)	Number of blocks used by the object

See also

ALL_RECYCLEBIN

USER_RECYCLEBIN

3.2.178. DBA_REDEFINITION_OBJECTS

Displays all objects in database which are being redefined online.

Columns

Column Name	Data Type	Description
OBJECT_TYPE	VARCHAR(5)	Type of the object. (Currently, only 'TABLE' is available)
OBJECT_OWNER	VARCHAR(128)	Owner of the object.
OBJECT_NAME	VARCHAR(128)	Name of the object.
BASE_TABLE_OWNER	VARCHAR(128)	Owner of the base table of the object.
BASE_TABLE_NAME	VARCHAR(128)	Name of the base table of the object.
INTERIM_OBJECT_OWNER	VARCHAR(128)	Owner of the intermediate table of the object.
INTERIM_OBJECT_NAME	VARCHAR(128)	Name of the intermediate table of the object.

3.2.179. DBA_ROLES

Displays all roles in the database.

Columns

Column Name Data Type Description
ROLE VARCHAR(128)
Name of the role
PASSWORD_REQUIRED VARCHAR(3)
Whether a password is required or not

3.2.180. DBA_ROLE_PRIVS

Displays roles granted to the users in the database.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user or role which was granted the role
GRANTED_ROLE	VARCHAR(128)	Granted role
ADMIN_OPTION	VARCHAR(3)	Whether or not the role was assigned with ADMIN OPTION - YES - NO - ERR
DEFAULT_ROLE	VARCHAR(3)	Whether the role is set to default role for the user - YES - NO - ERR

See also

USER_ROLE_PRIVS

3.2.181. DBA_ROLLBACK_SEGS

Synonym for DBA_UNDO_SGMTS.

Columns

Column Name	Data Type	Description
SEGMENT_ID	NUMBER	ID of the segment
TABLESPACE_NAME	VARCHAR(128)	Name of the undo tablespace
FILE_ID	NUMBER	ID of the file containing the segment header
BLOCK_ID	NUMBER	ID of the block containing the segment header
STATUS	VARCHAR(15)	Status of the segment - ONLINE - OFFLINE - OFFLINE PENDING - DROPPED (Never reused)
RELATIVE_FNO	NUMBER	Relative file number of the segment header

See also

DBA_UNDO_SGMTS

3.2.182. DBA_RSRC_AUDIT

Displays change history of resource plans.

Columns

Column Name Data Type Description
OLD_PLAN VARCHAR2(30)
Name of old plan
NEW_PLAN VARCHAR2(30)
Name of new plan
SWITCH_DATE VARCHAR2(60)
Switch date of plan
SWITCH_TIME VARCHAR2(60)
Switch time of plan

3.2.183. DBA_RSRC_CONSUMER_GROUPS

Displays all resource consumer groups in database.

Columns

Column Name	Data Type	Description
CONSUMER_GROUP	VARCHAR2(30)	Name of the consumer group
COMMENTS	VARCHAR2(240)	Comments of the consumer group
ATTRIBUTE	VARCHAR(30)	Attributes of the consumer group
VALUE	VARCHAR(30)	Value of the consumer group

3.2.184. DBA_RSRC_PLANS

Displays all resource plans in database.

Columns

Column Name Data Type Description
PLAN VARCHAR2(30)
Name of the resource plan
COMMENTS VARCHAR2(240)
Comments of the resource plan
IS_ACTIVE_PLAN CHAR(1)
Activeness of the resource plan

3.2.185. DBA_RSRC_PLAN_DIRECTIVES

Displays all resource plan directives in the database.

Columns

Column Name	Data Type	Description
PLAN	VARCHAR2(30)	Name of the resource plan directives
GROUP_OR_SUBPLAN	VARCHAR2(30)	Name of the consumer group or subplan
COMMENTS	VARCHAR2(240)	Comments of the resource plan directives
MGMT_P1	NUMBER	Parameter for the resource allocation method

3.2.186. DBA_SCHEDULER_CHAINS

Displays all scheduler chains in the database.

See also

ALL_SCHEDULER_CHAINS

USER_SCHEDULER_CHAINS

3.2.187. DBA_SCHEDULER_JOBS

Displays all scheduler jobs in the database.

See also

ALL_SCHEDULER_JOBS

USER_SCHEDULER_JOBS

3.2.188. DBA_SCHEDULER_PROGRAMS

Displays all scheduler programs in the database.

See also

ALL_SCHEDULER_PROGRAMS

USER_SCHEDULER_PROGRAMS

3.2.189. DBA_SCHEDULER_RULES

Displays all scheduler rules in the database.

See also

ALL_SCHEDULER_RULES

USER_SCHEDULER_RULES

3.2.190. DBA_SCHEDULER_RULE_CTX

Displays all scheduler rule ctx in the database.

See also

ALL_SCHEDULER_RULE_CTX

USER_SCHEDULER_RULE_CTX

3.2.191. DBA_SCHEDULER_RUNNING_JOBS

Displays all scheduler running jobs in the database.

See also

ALL_SCHEDULER_RUNNING_JOBS

USER_SCHEDULER_RUNNING_JOBS

3.2.192. DBA_SCHEDULER_STEPS

Displays all scheduler steps in the database.

See also

ALL_SCHEDULER_STEPS

USER_SCHEDULER_STEPS

3.2.193. DBA_SCHEDULER_STEP_CTX

Displays all scheduler step context in the database.

See also

ALL_SCHEDULER_STEP_CTX

USER_SCHEDULER_STEP_CTX

3.2.194. DBA_SEGMENTS

Displays all segments in the database.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the segment
SEGMENT_NAME	VARCHAR(128)	Name of the segment
PARTITION_NAME	VARCHAR(128)	Partition number of the object (Set to NULL for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(18)	Type of the segment - TABLE - TABLE PARTITION - TABLE SUBPARTITION - LOB - INDEX - INDEX PARTITION - INDEX SUBPARTITION - LOB - LOB PARTITION - LOB SUBPARTITION - UNDO
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the segment
HEADER_FILE	NUMBER	ID of the file containing the segment header
HEADER_BLOCK	NUMBER	ID of the block containing the segment header
BLOCKS	NUMBER	Size of the segment in blocks
EXTENTS	NUMBER	Size of the segment in extents
RELATIVE_FNO	NUMBER	Relative file number of the segment header
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_EXTENTS	NUMBER	Maximum number of extents that the segment can use
BYTES	NUMBER	Size of segment in bytes
INITIAL_EXTENT	NUMBER	Size in bytes requested for the initial extent of the segment
NEXT_EXTENT	NUMBER	Size in bytes of the next extent to be allocated to the segment

See also

ALL_SEGMENTS

USER_SEGMENTS

3.2.195. DBA_SEQUENCES

Displays all sequences in the database.

See also

ALL_SEQUENCES

USER_SEQUENCES

3.2.196. DBA_SOURCE

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

See also

ALL_SOURCE

USER_SOURCE

3.2.197. DBA_SUBPART_KEY_COLUMNS

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

See also

ALL_SUBPART_KEY_COLUMNS

USER_SUBPART_KEY_COLUMNS

3.2.198. DBA_SYNONYMS

Displays synonyms in the database.

See also

ALL_SYNONYMS

USER_SYNONYMS

3.2.199. DBA_SYS_PRIVS

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

Columns

Column Name

Data Type

Description

GRANTEE

VARCHAR(128)

Name of the user to whom the privilege was granted

PRIVILEGE

VARCHAR(40)

Name of the privilege

ADMIN_OPTION

VARCHAR(3)

Whether or not the privilege was granted with ADMIN OPTION

- YES

- NO

- ERR

See also

USER_SYS_PRIVS

3.2.200. DBA_TABLES

Displays all tables in the database.

See also

ALL_TABLES

USER_TABLES

3.2.201. DBA_TABLESPACES

Displays all tablespaces in the database.

Columns

Column Name	Data Type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace that contains the table
TS_ID	NUMBER	ID of the tablespace
DATAFILE_COUNT	NUMBER	The number of data files
BLOCK_SIZE	NUMBER	Size of the tablespace block
NEXT_EXTENT	NUMBER	Size of the next extent
STATUS	VARCHAR(9)	Current status of the tablespace - ONLINE - OFFLINE
CONTENTS	VARCHAR(9)	Contents of the tablespace - TEMPORARY - PERMANENT - UNDO
LOGGING	VARCHAR(9)	Whether logging is enabled or not - YES - NO
FORCE_LOGGING	VARCHAR(3)	Whether force logging is enabled or not - YES - NO
ALLOCATION_TYPE	VARCHAR(7)	Type of extent allocation in effect for the tablespace: - SYSTEM - UNIFORM
ENCRYPTED	VARCHAR(3)	Whether tablespace encryption is enabled or not - YES - NO
INITIAL_EXTENT	NUMBER	Default initial extent size
MIN_EXTENTS	NUMBER	Default minimum number of extents
MAX_EXTENTS	NUMBER	Default maximum number of extents
EXTENT_MANAGEMENT	VARCHAR(5)	Type of extent management - LOCAL
SEGMENT_SPACE_MANAGEMENT	VARCHAR(4)	Type of segment space management - AUTO

See also

USER_TABLESPACES

3.2.202. DBA_TAB_COLS

Synonym for DBA_TBL_COLS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
NUM_NULLS	NUMBER	(Not supported)
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
HIDDEN_COLUMN	CHAR(3)	(Not supported)
SEGMENT_COLUMN_ID	VARCHAR(3)	(Not supported)
INTERNAL_COLUMN_ID	VARCHAR(3)	(Not supported)
QUALIFIED_COL_NAME	VARCHAR(4000)	(Not supported)

See also

ALL_TAB_COLS

ALL_TBL_COLS

DBA_TBL_COLS

USER_TAB_COLS

USER_TBL_COLS

3.2.203. DBA_TAB_COLUMNS

Synonym for DBA_TBL_COLUMNS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table or view
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TBL_COLUMNS

USER_TAB_COLUMNS

USER_TBL_COLUMNS

3.2.204. DBA_TAB_COL_STATISTICS

Synonym for DBA_TBL_COL_STATISTICS.

Columns

Column Name	Data Type	Description
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
NUM_DISTINCT	NUMBER	The number of distinct values
LOW_VALUE	VARCHAR(4000)	The lowest value in the column
HIGH_VALUE	VARCHAR(4000)	The highest value in the column
DENSITY	NUMBER	Density of the column
NUM_NULLS	NUMBER	The number of NULL values
NUM_BUCKETS	NUMBER	The number of buckets for the histogram
LAST_ANALYZED	DATE	Date of the most recent analysis for the column
SAMPLE_SIZE	NUMBER	Size of the sample used for analyzing statistics for the column
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
HISTOGRAM	VARCHAR(15)	Indicates the type of histogram

See also

ALL_TAB_COL_STATISTICS

ALL_TBL_COL_STATISTICS

DBA_TBL_COL_STATISTICS

USER_TAB_COL_STATISTICS

USER_TBL_COL_STATISTICS

3.2.205. DBA_TAB_COMMENTS

Displays comments on all tables and views in the database.

See also

ALL_TAB_COMMENTS

ALL_TBL_COMMENTS

DBA_TBL_COMMENTS

3.2.206. DBA_TAB_HISTOGRAMS

Synonym for DBA_TBL_HISTOGRAMS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
ENDPOINT_NUMBER	NUMBER	History bucket number
ENDPOINT_VALUE	NUMBER	End point value of the current bucket
ENDPOINT_ACTUAL_VALUE	VARCHAR(4000)	Actual string value of the end point value of the current bucket

See also

ALL_TAB_HISTOGRAMS

ALL_TBL_HISTOGRAMS

DBA_TBL_HISTOGRAMS

USER_TAB_HISTOGRAMS

USER_TBL_HISTOGRAMS

3.2.207. DBA_TAB_PARTITIONS

Synonym for DBA_TBL_PARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
COMPOSITE	VARCHAR(3)	Whether or not the partition belongs to a composite-partitioned table - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_COUNT	NUMBER	The number of subpartitions which belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the partition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
NUM_ROWS	NUMBER	The number of rows within the table partition
BLOCKS	NUMBER	The number of data blocks containing information about the table partition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table partition
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO

See also

ALL_TAB_PARTITIONS

ALL_TBL_PARTITIONS

DBA_TBL_PARTITIONS

USER_TAB_PARTITIONS

USER_TBL_PARTITIONS

3.2.208. DBA_TAB_PRIVS

Synonym for DBA_TBL_PRIVS.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with GRANT OPTION - YES - NO

See also

ALL_TAB_PRIVS

ALL_TBL_PRIVS

DBA_TBL_PRIVS

USER_TAB_PRIVS

USER_TBL_PRIVS

3.2.209. DBA_TAB_SUBPARTITIONS

Synonym for DBA_TBL_SUBPARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
TABLE_NAME	VARCHAR(128)	Name of the table
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_NAME	VARCHAR(128)	Name of the table subpartition
BOUND	LONG	Subpartition bound value
SUBPARTITION_NO	NUMBER	Subpartition number within the partition
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the subpartition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the table subpartition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
NUM_ROWS	NUMBER	The number of rows within the table subpartition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table subpartition

See also

ALL_TAB_SUBPARTITIONS

ALL_TBL_SUBPARTITIONS

DBA_TBL_SUBPARTITIONS

3.2.210. DBA_TBL_COLS

Displays columns of all tables and views in the database.

See also

ALL_TAB_COLS

ALL_TBL_COLS

DBA_TAB_COLS

USER_TAB_COLS

USER_TBL_COLS

3.2.211. DBA_TBL_COLUMNS

Displays columns of all tables and views in the database.

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TAB_COLUMNS

USER_TAB_COLUMNS

USER_TBL_COLUMNS

3.2.212. DBA_TBL_COL_STATISTICS

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

See also

ALL_TAB_COL_STATISTICS

ALL_TBL_COL_STATISTICS

DBA_TAB_COL_STATISTICS

USER_TAB_COL_STATISTICS

USER_TBL_COL_STATISTICS

3.2.213. DBA_TBL_COMMENTS

Synonym for DBA_TAB_COMMENTS.

Columns

Column Name Data Type Description
OWNER VARCHAR(128)
Owner of the object
TABLE_NAME VARCHAR(128)
Name of the object
TABLE_TYPE VARCHAR(9)
Type of the object
COMMENTS VARCHAR(4000)
Comment on the object
See also

ALL_TAB_COMMENTS

ALL_TBL_COMMENTS

DBA_TAB_COMMENTS

3.2.214. DBA_TBL_HISTOGRAMS

Displays histogram information on tables and views in the database.

See also

ALL_TAB_HISTOGRAMS

ALL_TBL_HISTOGRAMS

DBA_TAB_HISTOGRAMS

USER_TAB_HISTOGRAMS

USER_TBL_HISTOGRAMS

3.2.215. DBA_TBL_PARTITIONS

Displays partition information of all tables in the database.

See also

ALL_TAB_PARTITIONS

ALL_TBL_PARTITIONS

DBA_TAB_PARTITIONS

USER_TAB_PARTITIONS

USER_TBL_PARTITIONS

3.2.216. DBA_TBL_PRIVS

Displays object privileges granted on all tables in the database.

See also

ALL_TAB_PRIVS

ALL_TBL_PRIVS

DBA_TAB_PRIVS

USER_TAB_PRIVS

USER_TBL_PRIVS

3.2.217. DBA_TBL_SUBPARTITIONS

Displays subpartitions of all tables in the database.

See also

ALL_TAB_SUBPARTITIONS

ALL_TBL_SUBPARTITIONS

DBA_TAB_SUBPARTITIONS

3.2.218. DBA_TEMPFILES

Synonym for DBA_TEMP_FILES.

Columns

Column Name	Data Type	Description
FILE_NAME	VARCHAR(256)	Name of the temporary data file
FILE_ID	NUMBER	ID of the data file
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace where the data file is contained
BYTES	NUMBER	Size of the data file in bytes
BLOCKS	NUMBER	Size of the data file in blocks
STATUS	CHAR(9)	Status of the data file - UNUSED - ONLINE - OFFLINE - RESETLOG - RECOVERY
RELATIVE_FNO	NUMBER	Relative data file number
AUTOEXTENSIBLE	VARCHAR(3)	Auto extensible indicator - YES - NO
MAXBYTES	NUMBER	Maximum data file size in bytes
MAXBLOCKS	NUMBER	Maximum data file size in blocks
INCREMENT_BY	NUMBER	Auto increment value

See also

DBA_TEMP_FILES

3.2.219. DBA_TEMP_FILES

Displays information of the temporary data files.

Columns

Column Name	Data Type	Description
FILE_NAME	VARCHAR(256)	Name of the temporary data file
FILE_ID	NUMBER	ID of the data file
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace where the data file is contained
BYTES	NUMBER	Size of the data file in bytes
BLOCKS	NUMBER	Size of the data file in blocks
STATUS	CHAR(9)	Status of the data file - UNUSED - ONLINE - OFFLINE - RESETLOG - RECOVERY
RELATIVE_FNO	NUMBER	Relative data file number
AUTOEXTENSIBLE	VARCHAR(3)	Auto extensible indicator - YES - NO
MAXBYTES	NUMBER	Maximum data file size in bytes
MAXBLOCKS	NUMBER	Maximum data file size in blocks
INCREMENT_BY	NUMBER	Auto increment value

See also

DBA_TEMPFILES

3.2.220. DBA_TRIGGERS

Displays all triggers in the database.

See also

ALL_TRIGGERS

USER_TRIGGERS

3.2.221. DBA_TRIGGER_COLS

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

See also

ALL_TRIGGER_COLS

USER_TRIGGER_COLS

3.2.222. DBA_TS_QUOTAS

Describe tablespace quotas for all user

Columns

Column Name	Data Type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace
USERNAME	VARCHAR(128)	Name of the user
BYTES	NUMBER	Number of bytes charged to the user
MAX_BYTES	NUMBER	User's quota in bytes
BLOCKS	NUMBER	Number of blocks charged to the user
MAX_BLOCKS	NUMBER	User's quota in blocks
DROPPED	VARCHAR(3)	Whether the tablespace has been dropped

3.2.223. DBA_TYPES

Displays all types.

See also

ALL_TYPES

USER_TYPES

3.2.224. DBA_TYPE_ATTRS

Displays all the attributes of this type.

See also

ALL_TYPE_ATTRS

USER_TYPE_ATTRS

3.2.225. DBA_TYPE_METHODS

Displays all the methods of this type.

See also

ALL_TYPE_METHODS

USER_TYPE_METHODS

3.2.226. DBA_UNDO_EXTENTS

Displays information about the extents in all undo segments.

Columns

Column Name	Data Type	Description
USGMT_ID	NUMBER	ID of the undo segment containing the extent
EXTNO	NUMBER	Extent number
TS_ID	NUMBER	ID of the tablespace containing the extent
TS_NAME	VARCHAR	Name of the tablespace containing the extent
FILE_ID	NUMBER	ID of the file containing the extent
BLOCK_ID	NUMBER	Starting block number of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in blocks
STATUS	VARCHAR(30)	Current status of the extent
IS_CURRENT	VARCHAR(12)	Whether the extent is current extent or not

3.2.227. DBA_UNDO_SGMTS

Displays undo segments in the database.

Columns

Column Name	Data Type	Description
SEGMENT_ID	NUMBER	ID of the segment
TABLESPACE_NAME	VARCHAR(128)	Name of the undo tablespace
FILE_ID	NUMBER	ID of the file containing the segment header
BLOCK_ID	NUMBER	ID of the block containing the segment header
STATUS	VARCHAR(15)	Status of the segment - ONLINE - OFFLINE - OFFLINE PENDING - DROPPED (Never reused)
RELATIVE_FNO	NUMBER	Relative file number of the segment header

See also

DBA_ROLLBACK_SEGS

3.2.228. DBA_UPDATABLE_COLUMNS

Displays all join view columns that the DBA can update.

See also

ALL_UPDATABLE_COLUMNS

USER_UPDATABLE_COLUMNS

3.2.229. DBA_USERS

Displays all users in the database.

Columns

Column Name	Data Type	Description
USERNAME	VARCHAR(128)	Name of the user
USER_ID	NUMBER	ID of the user
PASSWORD	VARCHAR(24)	Password of the user (Password is encrypted.)
ACCOUNT_STATUS	VARCHAR(30)	Account status - LOCKED - EXPIRED - LOCKED(TIMED) - EXPIRED(GRACE) - EXPIRED & LOCKED(TIMED) - EXPIRED(GRACE) & LOCKED(TIMED) - EXPIRED(GRACE) & LOCKED - EXPIRED & LOCKED - OPEN
LOCK_DATE	DATE	Date that the account was locked
EXPIRY_DATE	DATE	Date that the account was expired
DEFAULT_TABLESPACE	VARCHAR(128)	Default tablespace for data
CREATED	DATE	Date that the user was created
PROFILE	VARCHAR(255)	Profile assigned to the user
DEFAULT_TEMP_TABLESPACE	VARCHAR(128)	Default temporary tablespace for data
AUTHENTICATION_TYPE	VARCHAR(8)	Type of the authentication process for the user - PASSWORD - EXTERNAL

See also

ALL_USERS

USER_USERS

3.2.230. DBA_VIEWS

Displays all views in the database.

See also

ALL_VIEWS

ALL_VIEWS_INTERNAL

USER_VIEWS

3.2.231. DICTIONARY

Displays comments on tables and views in the data dictionary.

Columns

Column Name Data Type Description
TABLE_NAME VARCHAR(128)
Name of the table or view
COMMENTS VARCHAR(4000)
Comments on the table or view

3.2.232. NLS_SESSION_PARAMETERS

Displays NLS parameters of the current user session.

Columns

Column Name Data Type Description
PARAMETER VARCHAR(64)
Name of the parameter
VALUE VARCHAR(64)
Value of the parameter

3.2.233. PUBLICSYN

Displays all public synonyms in the database.

Columns

Column Name Data Type Description
SYN_NAME VARCHAR(128)
Name of the synonym
OBJ_OWNER VARCHAR(128)
Owner of the object
OBJ_NAME VARCHAR(257)
Name of the object
OBJ_TYPE VARCHAR(9)
Type of the object

3.2.234. ROLE_ROLE_PRIVS

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

Columns

Column Name

Data Type

Description

ROLE

VARCHAR(128)

Name of the role

GRANTED_ROLE

VARCHAR(128)

Role that was granted

ADMIN_OPTION

VARCHAR(3)

Whether or not the role was assigned with ADMIN OPTION

- YES

- NO

- ERR

3.2.235. ROLE_SYS_PRIVS

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

Columns

Column Name

Data Type

Description

ROLE

VARCHAR(128)

Name of the role

PRIVILEGE

VARCHAR(40)

Name of the privilege

ADMIN_OPTION

VARCHAR(3)

Whether or not the grant was assigned with ADMIN OPTION

- YES

- NO

- ERR

3.2.236. ROLE_TAB_PRIVS

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

Columns

Column Name	Data Type	Description
ROLE	VARCHAR(128)	Name of the role
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
COLUMN_NAME	VARCHAR(128)	Name of the column, if applicable
PRIVILEGE	VARCHAR(40)	Object privilege granted to the role
ADMIN_OPTION	VARCHAR(3)	Whether or not the grant was assigned with ADMIN OPTION - YES - NO - ERR

3.2.237. SESSION_CONTEXT

Displays context attributes in the current session.

Columns

Column Name Data Type Description
NAMESPACE VARCHAR(128)
The namespace of the context attribute
ATTRIBUTE VARCHAR(128)
The name of the attribute
VALUE VARCHAR(65532)
The value of the attribute

3.2.238. SESSION_PRIVS

Displays the system privileges granted to current session user.

Columns

Column Name Data Type Description
PRIVILEGE VARCHAR(40)
Name of the privilege

3.2.239. SESSION_ROLES

Displays roles granted to the current session user.

Columns

Column Name Data Type Description
ROLE VARCHAR(128)
Name of the role

3.2.240. SYS_OBJECTS

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

Columns

Column Name	Data Type	Description
OBJECT_TYPE	VARCHAR(18)	Type of the object
OBJECT_TYPE_NO	NUMBER	ID of the object's type
SEGMENT_TYPE_NO	NUMBER	ID of the segment's type
OBJECT_ID	NUMBER	ID of the object
HEADER_FILE	NUMBER	ID of the data file containing the segment header
HEADER_BLOCK	NUMBER	ID of the disk block containing the segment header
TS_NUMBER	NUMBER	ID of the tablespace containing the object
SEGMENT_ID	NUMBER	ID of the segment

3.2.241. USER_ARGUMENTS

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

See also

ALL_ARGUMENTS

3.2.242. USER_AUDIT_TRAIL

Displays audit trails associated with the current user.

Columns

Column Name	Data Type	Description
OS_USERNAME	VARCHAR(128)	Operating system user name who was set to be audited
USERNAME	VARCHAR(128)	Name of the user who was set to be audited
USERHOST	VARCHAR(21)	Name of the host machine from which the client has connected
TIMESTAMP	VARCHAR(19)	Audit trail-created time
OWNER	VARCHAR(128)	Owner of the object associated with the audited action
OBJ_NAME	VARCHAR(128)	Name of the object associated with the audited action
SESSIONID	NUMBER	Session ID
SERIALNO	NUMBER	Sequence number of the session
ENTRYID	NUMBER	Sequence number for each audit trail in the session
STATEMENTID	NUMBER	ID of the executed statement
PRIV_USED	VARCHAR(80)	Name of the privilege used to execute the audited action
CLIENT_ID	VARCHAR(30)	Client identifier
INSTANCE_NUMBER	NUMBER	Instance number of RDBMS which performed the action
OS_PROCESS	VARCHAR(16)	Process ID of RDBMS
TRANSACTIONID	VARCHAR(65532)	Transaction ID that participated in the audited action
TSN	NUMBER	TSN of the audited action
SQL_TEXT	LONG	SQL of the audited action

See also

DBA_AUDIT_TRAIL

3.2.243. USER_CATALOG

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

See also

ALL_CATALOG

DBA_CATALOG

3.2.244. USER_COLL_TYPES

Displays all the collection types that the current user owns.

See also

ALL_COLL_TYPES

DBA_COLL_TYPES

3.2.245. USER_COL_COMMENTS

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

See also

ALL_COL_COMMENTS

DBA_COL_COMMENTS

3.2.246. USER_COL_PRIVS

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

See also

ALL_COL_PRIVS

DBA_COL_PRIVS

3.2.247. USER_COL_PRIVS_MADE

Displays columns for which the current user is the grantor.

See also

ALL_COL_PRIVS_MADE

3.2.248. USER_COL_PRIVS_RECD

Displays columns for which the current user is the grantee.

See also

ALL_COL_PRIVS_RECD

3.2.249. USER_CONSTRAINTS

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

See also

ALL_CONSTRAINTS

DBA_CONSTRAINTS

3.2.250. USER_CONS_COLUMNS

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

See also

ALL_CONS_COLUMNS

DBA_CONS_COLUMNS

3.2.251. USER_DB_LINKS

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

See also

ALL_DB_LINKS

DBA_DB_LINKS

3.2.252. USER_DEPENDENCIES

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

See also

ALL_DEPENDENCIES

DBA_DEPENDENCIES

3.2.253. USER_ENCRYPTED_COLUMNS

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).

See also

ALL_ENCRYPTED_COLUMNS

DBA_ENCRYPTED_COLUMNS

3.2.254. USER_ERRORS

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).

See also

ALL_ERRORS

DBA_ERRORS

3.2.255. USER_EXTENTS

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

Columns

Column Name	Data Type	Description
SEGMENT_NAME	VARCHAR(128)	Name of the segment containing the extent
PARTITION_NAME	VARCHAR(128)	Partition name of the object (Null value for non-partitioned objects)
SEGMENT_TYPE	VARCHAR(18)	Type of the segment
TABLESPACE_NAME	VARCHAR(30)	Name of the tablespace containing the extent
EXTENT_ID	NUMBER	ID of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in blocks

See also

DBA_EXTENTS

3.2.256. USER_EXTERNAL_LOCATIONS

Displays all external table locations that the current user owns.

See also

ALL_EXTERNAL_LOCATIONS

DBA_EXTERNAL_LOCATIONS

3.2.257. USER_EXTERNAL_TABLES

Displays all external tables that the current user owns.

See also

ALL_EXTERNAL_TABLES

DBA_EXTERNAL_TABLES

3.2.258. USER_FREE_SPACE

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

Columns

Column Name	Data Type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace containing the extent
FILE_ID	NUMBER	ID of the file containing the extent
BLOCK_ID	NUMBER	Starting block number of the extent
BYTES	NUMBER	Size of the extent in bytes
BLOCKS	NUMBER	Size of the extent in blocks
RELATIVE_FNO	NUMBER	Relative file number of the extent

See also

DBA_FREE_SPACE

3.2.259. USER_IDX_COLUMNS

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

See also

ALL_IDX_COLUMNS

ALL_IND_COLUMNS

DBA_IDX_COLUMNS

DBA_IND_COLUMNS

USER_IND_COLUMNS

3.2.260. USER_IDX_EXPRESSIONS

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

See also

ALL_IDX_EXPRESSIONS

ALL_IND_EXPRESSIONS

DBA_IDX_EXPRESSIONS

DBA_IND_EXPRESSIONS

USER_IND_EXPRESSIONS

3.2.261. USER_IDX_PARTITIONS

Displays partitions of the indexes that the current user owns.

See also

ALL_IDX_PARTITIONS

ALL_IND_PARTITIONS

DBA_IDX_PARTITIONS

DBA_IND_PARTITIONS

USER_IND_PARTITIONS

3.2.262. USER_INDEXES

Displays indexes of all tables that the current user owns.

See also

ALL_INDEXES

DBA_INDEXES

3.2.263. USER_IND_COLUMNS

Synonym for USER_IDX_COLUMNS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_LENGTH	NUMBER	Length of the column within the index
DESCEND	VARCHAR(4)	Sorting order in columns - DESC - ASC

See also

ALL_IDX_COLUMNS

ALL_IND_COLUMNS

DBA_IDX_COLUMNS

DBA_IND_COLUMNS

USER_IDX_COLUMNS

3.2.264. USER_IND_EXPRESSIONS

Synonym for USER_IDX_EXPRESSIONS.

Columns

Column Name	Data Type	Description
INDEX_OWNER	VARCHAR(128)	Owner of the index
INDEX_NAME	VARCHAR(128)	Name of the index
TABLE_OWNER	VARCHAR(128)	Owner of the table
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_POSITION	NUMBER	Position of the column within the index
COLUMN_EXPRESSION	LONG	Expression of the column within the index

See also

ALL_IDX_EXPRESSIONS

ALL_IND_EXPRESSIONS

DBA_IDX_EXPRESSIONS

DBA_IND_EXPRESSIONS

USER_IDX_EXPRESSIONS

3.2.265. USER_IND_PARTITIONS

Synonym for USER_IDX_PARTITIONS.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the user
INDEX_NAME	VARCHAR(128)	Name of the index
COMPOSITE	VARCHAR(3)	Whether or not partition belongs to a composite-partitioned index - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the partition
SUBPARTITION_COUNT	NUMBER	The number of the subpartitions that belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the index
BLEVEL	NUMBER	Level of B-tree index (The level is 0 for a B-tree with only a root node)
LEAF_BLOCKS	NUMBER	The number of leaf blocks in the index
DISTINCT_KEYS	NUMBER	The number of distinct keys in the index
CLUSTERING_FACTOR	NUMBER	The clustering factor of the index
STATUS	VARCHAR(8)	Current status of the index - USABLE - UNUSABLE
NUM_ROWS	NUMBER	The number of rows in the index
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
MAX_TRANS	NUMBER	Value of the MAX_TRANS parameter
INITIAL_EXTENT	NUMBER	Value of the INITIAL_EXTENT parameter
MIN_EXTENT	NUMBER	Value of the MIN_EXTENT parameter
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO
LAST_ANALYZED	DATE	Date of the most recent analysis for the index partition

See also

ALL_IDX_PARTITIONS

ALL_IND_PARTITIONS

DBA_IDX_PARTITIONS

DBA_IND_PARTITIONS

USER_IDX_PARTITIONS

3.2.266. USER_JAVA_ARGUMENTS

Displays all parameters that the current user owns.

See also

ALL_JAVA_ARGUMENTS

DBA_JAVA_ARGUMENTS

3.2.267. USER_JAVA_CLASSES

Displays all classes that the current user owns.

See also

ALL_JAVA_CLASSES

DBA_JAVA_CLASSES

3.2.268. USER_JAVA_FIELDS

Displays all fields that the current user owns.

See also

ALL_JAVA_FIELDS

DBA_JAVA_FIELDS

3.2.269. USER_JAVA_METHODS

Displays all methods that the current user owns.

See also

ALL_JAVA_METHODS

DBA_JAVA_METHODS

3.2.270. USER_JOBS

Displays all jobs that the current user owns.

See also

ALL_JOBS

DBA_JOBS

3.2.271. USER_LIBRARIES

Displays all libraries that the current user owns.

See also

ALL_LIBRARIES

DBA_LIBRARIES

3.2.272. USER_LOBS

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

See also

ALL_LOBS

DBA_LOBS

3.2.273. USER_LOB_PARTITIONS

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

See also

ALL_LOB_PARTITIONS

DBA_LOB_PARTITIONS

3.2.274. USER_LOB_SUBPARTITIONS

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

See also

ALL_LOB_SUBPARTITIONS

DBA_LOB_SUBPARTITIONS

3.2.275. USER_LOG_GROUPS

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

See also

ALL_LOG_GROUPS

DBA_LOG_GROUPS

3.2.276. USER_LOG_GROUP_COLUMNS

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

See also

ALL_LOG_GROUP_COLUMNS

DBA_LOG_GROUP_COLUMNS

3.2.277. USER_METHOD_PARAMS

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

See also

ALL_METHOD_PARAMS

DBA_METHOD_PARAMS

3.2.278. USER_METHOD_RESULTS

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

See also

ALL_METHOD_RESULTS

DBA_METHOD_RESULTS

3.2.279. USER_MVIEWS

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

See also

ALL_MVIEWS

DBA_MVIEWS

3.2.280. USER_MVIEW_COMMENTS

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

See also

ALL_MVIEW_COMMENTS

DBA_MVIEW_COMMENTS

3.2.281. USER_MVIEW_LOGS

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

See also

ALL_MVIEW_LOGS

DBA_MVIEW_LOGS

3.2.282. USER_OBJECTS

Displays all objects that the current user owns.

See also

ALL_OBJECTS

DBA_OBJECTS

3.2.283. USER_OBJ_AUDIT_OPTS

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

Columns

Column Name	Data Type	Description
OBJECT_NAME	VARCHAR(128)	Name of the object
OBJECT_TYPE	VARCHAR(9)	Type of the object - TABLE - VIEW - SEQUENCE - PROCEDURE - DIRECTORY - JAVA
ALT	VARCHAR(5)	ALTER auditing option for success or failure
DEL	VARCHAR(5)	DELETE auditing option for success or failure
IND	VARCHAR(5)	INDEX auditing option for success or failure
INS	VARCHAR(5)	INSERT auditing option for success or failure
LOC	VARCHAR(5)	LOCK auditing option for success or failure
SEL	VARCHAR(5)	SELECT auditing option for success or failure
UPD	VARCHAR(5)	UPDATE auditing option for success or failure
REF	VARCHAR(5)	REFERENCE auditing option for success or failure
EXE	VARCHAR(5)	EXECUTE auditing option for success or failure
REA	VARCHAR(5)	READ auditing option for success or failure
WRI	VARCHAR(5)	WRITE auditing option for success or failure

See also

DBA_OBJ_AUDIT_OPTS

3.2.284. USER_PACKAGE_MEMBER_TYPES

Displays types of the package that the current user owns.

See also

ALL_PACKAGE_MEMBER_TYPES

DBA_PACKAGE_MEMBER_TYPES

3.2.285. USER_PART_INDEXES

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

See also

ALL_PART_INDEXES

DBA_PART_INDEXES

3.2.286. USER_PART_KEY_COLUMNS

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

See also

ALL_PART_KEY_COLUMNS

DBA_PART_KEY_COLUMNS

3.2.287. USER_PART_LOBS

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

See also

ALL_PART_LOBS

DBA_PART_LOBS

3.2.288. USER_PART_TABLES

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

See also

ALL_PART_TABLES

DBA_PART_TABLES

3.2.289. USER_PROCEDURES

Displays all procedures that the current user owns.

See also

ALL_PROCEDURES

DBA_PROCEDURES

3.2.290. USER_QUEUES

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

See also

ALL_QUEUES

DBA_QUEUES

3.2.291. USER_QUEUE_SUBSCRIBERS

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

See also

ALL_QUEUE_SUBSCRIBERS

DBA_QUEUE_SUBSCRIBERS

3.2.292. USER_QUEUE_TABLES

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

See also

ALL_QUEUE_TABLES

DBA_QUEUE_TABLES

3.2.293. USER_RECYCLEBIN

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

See also

ALL_RECYCLEBIN

DBA_RECYCLEBIN

3.2.294. USER_ROLE_PRIVS

Displays roles granted to the current user.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user or role which was granted the role
GRANTED_ROLE	VARCHAR(128)	Granted role
ADMIN_OPTION	VARCHAR(3)	Whether or not the role was assigned with ADMIN OPTION - YES - NO - ERR
DEFAULT_ROLE	VARCHAR(3)	Whether the role is set to default role for the user - YES - NO - ERR

See also

DBA_ROLE_PRIVS

3.2.295. USER_SCHEDULER_CHAINS

Displays all scheduler chains that the current user owns.

See also

ALL_SCHEDULER_CHAINS

DBA_SCHEDULER_CHAINS

3.2.296. USER_SCHEDULER_JOBS

Displays all scheduler jobs that the current user owns.

See also

ALL_SCHEDULER_JOBS

DBA_SCHEDULER_JOBS

3.2.297. USER_SCHEDULER_PROGRAMS

Displays all scheduler programs that the current user owns.

See also

ALL_SCHEDULER_PROGRAMS

DBA_SCHEDULER_PROGRAMS

3.2.298. USER_SCHEDULER_RULES

Displays all scheduler rules that the current user owns.

See also

ALL_SCHEDULER_RULES

DBA_SCHEDULER_RULES

3.2.299. USER_SCHEDULER_RULE_CTX

Displays all scheduler rule ctx that the current user owns.

See also

ALL_SCHEDULER_RULE_CTX

DBA_SCHEDULER_RULE_CTX

3.2.300. USER_SCHEDULER_RUNNING_JOBS

Displays all scheduler running jobs that the current user owns.

See also

ALL_SCHEDULER_RUNNING_JOBS

DBA_SCHEDULER_RUNNING_JOBS

3.2.301. USER_SCHEDULER_STEPS

Displays all scheduler steps that the current user owns.

See also

ALL_SCHEDULER_STEPS

DBA_SCHEDULER_STEPS

3.2.302. USER_SCHEDULER_STEP_CTX

Displays all scheduler step context the current user owns.

See also

ALL_SCHEDULER_STEP_CTX

DBA_SCHEDULER_STEP_CTX

3.2.303. USER_SEGMENTS

Displays all segments which belong to the current user.

See also

ALL_SEGMENTS

DBA_SEGMENTS

3.2.304. USER_SEQUENCES

Displays all sequences that the current user owns.

See also

ALL_SEQUENCES

DBA_SEQUENCES

3.2.305. USER_SOURCE

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

See also

ALL_SOURCE

DBA_SOURCE

3.2.306. USER_SUBPART_KEY_COLUMNS

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

See also

ALL_SUBPART_KEY_COLUMNS

DBA_SUBPART_KEY_COLUMNS

3.2.307. USER_SYNONYMS

Displays synonyms that the current user owns.

See also

ALL_SYNONYMS

DBA_SYNONYMS

3.2.308. USER_SYS_PRIVS

Displays system privileges granted to the current user.

Columns

Column Name

Data Type

Description

USERNAME

VARCHAR(128)

Name of the current user or PUBLIC

PRIVILEGE

VARCHAR(40)

Name of the privilege

ADMIN_OPTION

VARCHAR(3)

Whether or not the privilege was granted with ADMIN OPTION

- YES

- NO

- ERR

See also

DBA_SYS_PRIVS

3.2.309. USER_TABLES

Displays all tables that the current user owns.

See also

ALL_TABLES

DBA_TABLES

3.2.310. USER_TABLESPACES

Synonym for DBA_TABLESPACES.

Columns

Column Name	Data Type	Description
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace that contains the table
TS_ID	NUMBER	ID of the tablespace
DATAFILE_COUNT	NUMBER	The number of data files
BLOCK_SIZE	NUMBER	Size of the tablespace block
NEXT_EXTENT	NUMBER	Size of the next extent
STATUS	VARCHAR(9)	Current status of the tablespace - ONLINE - OFFLINE
CONTENTS	VARCHAR(9)	Contents of the tablespace - TEMPORARY - PERMANENT - UNDO
LOGGING	VARCHAR(9)	Whether logging is enabled or not - YES - NO
FORCE_LOGGING	VARCHAR(3)	Whether force logging is enabled or not - YES - NO
ALLOCATION_TYPE	VARCHAR(7)	Type of extent allocation in effect for the tablespace: - SYSTEM - UNIFORM
ENCRYPTED	VARCHAR(3)	Whether tablespace encryption is enabled or not - YES - NO
INITIAL_EXTENT	NUMBER	Default initial extent size
MIN_EXTENTS	NUMBER	Default minimum number of extents
MAX_EXTENTS	NUMBER	Default maximum number of extents
EXTENT_MANAGEMENT	VARCHAR(5)	Type of extent management - LOCAL
SEGMENT_SPACE_MANAGEMENT	VARCHAR(4)	Type of segment space management - AUTO

See also

DBA_TABLESPACES

3.2.311. USER_TAB_COLS

Synonym for USER_TBL_COLS.

Columns

Column Name	Data Type	Description
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
NUM_NULLS	NUMBER	(Not supported)
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column
HIDDEN_COLUMN	CHAR(3)	(Not supported)
SEGMENT_COLUMN_ID	VARCHAR(3)	(Not supported)
INTERNAL_COLUMN_ID	VARCHAR(3)	(Not supported)
QUALIFIED_COL_NAME	VARCHAR(4000)	(Not supported)

See also

ALL_TAB_COLS

ALL_TBL_COLS

DBA_TAB_COLS

DBA_TBL_COLS

USER_TBL_COLS

3.2.312. USER_TAB_COLUMNS

Synonym for USER_TBL_COLUMNS.

Columns

Column Name	Data Type	Description
TABLE_NAME	VARCHAR(128)	Name of the table or view
COLUMN_NAME	VARCHAR(128)	Name of the column
DATA_TYPE	VARCHAR(65532)	Data type of the column
DATA_LENGTH	NUMBER	Column length (in bytes)
DATA_PRECISION	NUMBER	Precision level of the column value
DATA_SCALE	NUMBER	Scale of the column value
NULLABLE	VARCHAR(1)	Whether NULL values are allowed or not - Y - N (It is set to "N" if NOT NULL constraints are defined or the column is a part of the primary key)
COLUMN_ID	NUMBER	ID of the column
DATA_DEFAULT	LONG	Default value of the column
CHAR_USED	VARCHAR(1)	Length semantics of the column - C - B (It is set to "C" if the length was specified in characters, "B" if in bytes)
VIRTUAL_COLUMN	CHAR(1)	Whether the column is a virtual column

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TAB_COLUMNS

DBA_TBL_COLUMNS

USER_TBL_COLUMNS

3.2.313. USER_TAB_COL_STATISTICS

Synonym for USER_TBL_COL_STATISTICS.

Columns

Column Name	Data Type	Description
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
NUM_DISTINCT	NUMBER	The number of distinct values
LOW_VALUE	VARCHAR(4000)	The lowest value in the column
HIGH_VALUE	VARCHAR(4000)	The highest value in the column
DENSITY	NUMBER	Density of the column
NUM_NULLS	NUMBER	The number of NULL values
NUM_BUCKETS	NUMBER	The number of buckets for the histogram
LAST_ANALYZED	DATE	Date of the most recent analysis for the column
SAMPLE_SIZE	NUMBER	Size of the sample used for analyzing statistics for the column
AVG_COL_LEN	NUMBER	Average length of the column (in bytes)
HISTOGRAM	VARCHAR(15)	Indicates the type of histogram

See also

ALL_TAB_COL_STATISTICS

ALL_TBL_COL_STATISTICS

DBA_TAB_COL_STATISTICS

DBA_TBL_COL_STATISTICS

USER_TBL_COL_STATISTICS

3.2.314. USER_TAB_COMMENTS

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

Columns

Column Name Data Type Description
TABLE_NAME VARCHAR(128)
Name of the object
TABLE_TYPE VARCHAR(9)
Type of the object
COMMENTS VARCHAR(4000)
Comment on the object
See also

USER_TBL_COMMENTS

3.2.315. USER_TAB_HISTOGRAMS

Synonym for USER_TBL_HISTOGRAMS.

Columns

Column Name	Data Type	Description
TABLE_NAME	VARCHAR(128)	Name of the table
COLUMN_NAME	VARCHAR(128)	Name of the column
ENDPOINT_NUMBER	NUMBER	History bucket number
ENDPOINT_VALUE	NUMBER	End point value of the current bucket
ENDPOINT_ACTUAL_VALUE	VARCHAR(4000)	Actual string value of the end point value of the current bucket

See also

ALL_TAB_HISTOGRAMS

ALL_TBL_HISTOGRAMS

DBA_TAB_HISTOGRAMS

DBA_TBL_HISTOGRAMS

USER_TBL_HISTOGRAMS

3.2.316. USER_TAB_PARTITIONS

Synonym for USER_TBL_PARTITIONS.

Columns

Column Name	Data Type	Description
TABLE_NAME	VARCHAR(128)	Name of the table
COMPOSITE	VARCHAR(3)	Whether or not the partition belongs to a composite-partitioned table - YES - NO
PARTITION_NAME	VARCHAR(128)	Name of the table partition
SUBPARTITION_COUNT	NUMBER	The number of subpartitions which belong to the partition
BOUND	LONG	Partition bound value
PARTITION_NO	NUMBER	Partition number within the table
TABLESPACE_NAME	VARCHAR(128)	Name of the tablespace to which the partition belongs
PCT_FREE	NUMBER	Value of the PCTFREE parameter
INI_TRANS	NUMBER	Value of the INITRANS parameter
NEXT_EXTENT	NUMBER	Size of the next extent
MAX_EXTENTS	NUMBER	Value of the MAX EXTENTS parameter
COMPRESSION	VARCHAR(3)	Whether or not the table partition has been compressed - YES - NO
COMPRESS_FOR	VARCHAR(12)	Compression level of the partition - QUERY LOW - QUERY HIGH - ARCHIVE LOW - ARCHIVE HIGH - NULL
BUFFER_POOL	VARCHAR(7)	Type of the buffer pool - DEFAULT - KEEP - RECYCLE
NUM_ROWS	NUMBER	The number of rows within the table partition
BLOCKS	NUMBER	The number of data blocks containing information about the table partition
LAST_ANALYZED	DATE	Date of the most recent analysis for the table partition
LOGGING	VARCHAR(3)	Whether logging is enabled or not - YES - NO

See also

ALL_TAB_PARTITIONS

ALL_TBL_PARTITIONS

DBA_TAB_PARTITIONS

DBA_TBL_PARTITIONS

USER_TBL_PARTITIONS

3.2.317. USER_TAB_PRIVS

Synonym for USER_TBL_PRIVS.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Owner of the object
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with GRANT OPTION - YES - NO

See also

ALL_TAB_PRIVS

ALL_TBL_PRIVS

DBA_TAB_PRIVS

DBA_TBL_PRIVS

USER_TBL_PRIVS

3.2.318. USER_TAB_PRIVS_MADE

Synonym for USER_TBL_PRIVS_MADE.

Columns

Column Name	Data Type	Description
GRANTEE	VARCHAR(128)	Name of the user to whom the privilege was granted
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

ALL_TAB_PRIVS_MADE

ALL_TBL_PRIVS_MADE

USER_TBL_PRIVS_MADE

3.2.319. USER_TAB_PRIVS_RECD

Synonym for USER_TBL_PRIVS_RECD.

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

USER_TBL_PRIVS_RECD

3.2.320. USER_TBL_COLS

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

See also

ALL_TAB_COLS

ALL_TBL_COLS

DBA_TAB_COLS

DBA_TBL_COLS

USER_TAB_COLS

3.2.321. USER_TBL_COLUMNS

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

See also

ALL_TAB_COLUMNS

ALL_TBL_COLUMNS

ALL_TBL_COLUMNS_WITH_DNO

DBA_TAB_COLUMNS

DBA_TBL_COLUMNS

USER_TAB_COLUMNS

3.2.322. USER_TBL_COL_STATISTICS

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

See also

ALL_TAB_COL_STATISTICS

ALL_TBL_COL_STATISTICS

DBA_TAB_COL_STATISTICS

DBA_TBL_COL_STATISTICS

USER_TAB_COL_STATISTICS

3.2.323. USER_TBL_COMMENTS

Synonym for USER_TAB_COMMENTS.

Columns

Column Name Data Type Description
TABLE_NAME VARCHAR(128)
Name of the object
TABLE_TYPE VARCHAR(9)
Type of the object
COMMENTS VARCHAR(4000)
Comment on the object
See also

USER_TAB_COMMENTS

3.2.324. USER_TBL_HISTOGRAMS

Displays histogram information of tables that the current user owns.

See also

ALL_TAB_HISTOGRAMS

ALL_TBL_HISTOGRAMS

DBA_TAB_HISTOGRAMS

DBA_TBL_HISTOGRAMS

USER_TAB_HISTOGRAMS

3.2.325. USER_TBL_PARTITIONS

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

See also

ALL_TAB_PARTITIONS

ALL_TBL_PARTITIONS

DBA_TAB_PARTITIONS

DBA_TBL_PARTITIONS

USER_TAB_PARTITIONS

3.2.326. USER_TBL_PRIVS

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

See also

ALL_TAB_PRIVS

ALL_TBL_PRIVS

DBA_TAB_PRIVS

DBA_TBL_PRIVS

USER_TAB_PRIVS

3.2.327. USER_TBL_PRIVS_MADE

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

See also

ALL_TAB_PRIVS_MADE

ALL_TBL_PRIVS_MADE

USER_TAB_PRIVS_MADE

3.2.328. USER_TBL_PRIVS_RECD

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

Columns

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Name of the object owner
TABLE_NAME	VARCHAR(128)	Name of the object
GRANTOR	VARCHAR(128)	Name of the user who granted the privilege
PRIVILEGE	VARCHAR(40)	Name of the privilege to the table
GRANTABLE	VARCHAR(3)	Whether or not the privilege was granted with ADMIN OPTION - YES - NO

See also

USER_TAB_PRIVS_RECD

3.2.329. USER_TRIGGERS

Displays all triggers that the current user owns.

See also

ALL_TRIGGERS

DBA_TRIGGERS

3.2.330. USER_TRIGGER_COLS

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.

See also

ALL_TRIGGER_COLS

DBA_TRIGGER_COLS

3.2.331. USER_TYPES

Displays all types that the current user owns.

See also

ALL_TYPES

DBA_TYPES

3.2.332. USER_TYPE_ATTRS

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

See also

ALL_TYPE_ATTRS

DBA_TYPE_ATTRS

3.2.333. USER_TYPE_METHODS

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

See also

ALL_TYPE_METHODS

DBA_TYPE_METHODS

3.2.334. USER_UPDATABLE_COLUMNS

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

See also

ALL_UPDATABLE_COLUMNS

DBA_UPDATABLE_COLUMNS

3.2.335. USER_USERS

Displays a description on the current user.

Columns

Column Name	Data Type	Description
USERNAME	VARCHAR(128)	Name of the user
USER_ID	NUMBER	ID of the user
ACCOUNT_STATUS	VARCHAR(30)	Account status - LOCKED - EXPIRED - LOCKED(TIMED) - EXPIRED(GRACE) - EXPIRED & LOCKED(TIMED) - EXPIRED(GRACE) & LOCKED(TIMED) - EXPIRED(GRACE) & LOCKED - EXPIRED & LOCKED - OPEN
LOCK_DATE	DATE	Date that the account was locked
EXPIRY_DATE	DATE	Date that the account was expired
DEFAULT_TABLESPACE	VARCHAR(128)	Default tablespace for data
CREATED	DATE	Date that the user was created

See also

ALL_USERS

DBA_USERS

3.2.336. USER_VIEWS

Displays all views that the current user owns.

See also

ALL_VIEWS

ALL_VIEWS_INTERNAL

DBA_VIEWS

Column Name	Data Type	Description
OWNER	VARCHAR(128)	Owner of the view
VIEW_NAME	VARCHAR(128)	Name of the view
TEXT	LONG	Definition of the view

Column Name	Data Type	Description
NAME	VARCHAR(128)	Name of the property
VALUE	VARCHAR(80)	Value of the property
COMMENT_STR	VARCHAR(4000)	Description of the property

Column Name	Data Type	Description
OLD_PLAN	VARCHAR2(30)	Name of old plan
NEW_PLAN	VARCHAR2(30)	Name of new plan
SWITCH_DATE	VARCHAR2(60)	Switch date of plan
SWITCH_TIME	VARCHAR2(60)	Switch time of plan

Column Name	Data Type	Description
PLAN	VARCHAR2(30)	Name of the resource plan
COMMENTS	VARCHAR2(240)	Comments of the resource plan
IS_ACTIVE_PLAN	CHAR(1)	Activeness of the resource plan

Column Name	Data Type	Description
PARAMETER	VARCHAR(64)	Name of the parameter
VALUE	VARCHAR(64)	Value of the parameter

Column Name	Data Type	Description
SYN_NAME	VARCHAR(128)	Name of the synonym
OBJ_OWNER	VARCHAR(128)	Owner of the object
OBJ_NAME	VARCHAR(257)	Name of the object
OBJ_TYPE	VARCHAR(9)	Type of the object

Column Name	Data Type	Description
NAMESPACE	VARCHAR(128)	The namespace of the context attribute
ATTRIBUTE	VARCHAR(128)	The name of the attribute
VALUE	VARCHAR(65532)	The value of the attribute

Prev		Next
Chapter 2. Data Dictionary	Home	Chapter 4. Dynamic View