Friday, January 18, 2008

基金买卖操盘方式

  1. 买入:
    跌幅
    百分比 买入金额
    -20%
    81% 1000 (短期) :从近期高处下跌
    -10% 72% 1 / 3 (中期)
    -10% 63% 1 / 2 (中期)
    -10% 54% 1 (长期)
    -10% 45% reserved 10k (长期)
    -10% 34% reserved 20k (长期)

  2. 卖出:
    涨幅 百分比 卖出金额
    20%
    120% 1000 (短期) :从近期低处上涨
    20% 144% 1 / 4 (中期) :中期走势
    20% 172% 1 / 3 (中期)
    20% 206% 1 / 2 (长期)
    20% 247% 1 (长期)

  3. 取参照点:
    以上一次拐点为参照点.
    举例:
    A涨B跌C涨, 在C点时, 涨幅20%, 拐点B, 卖出金额1000.
    A涨BC涨, 在C点时, 涨幅20%, 拐点A, 卖出金额1 / 4.
    A涨B跌C, 在C点时, 幅20%, 拐点B, 买入金额1000.
    AB跌C, 在C点时, 幅10%, 拐点A, 买入金额1 / 3.

Thursday, January 3, 2008

Oracle Dictionary - Dynamic Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%' ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
V$ACCESS - Synonym for V_$ACCESS
V$ACTIVE_INSTANCES - Synonym for V_$ACTIVE_INSTANCES
V$ACTIVE_SERVICES - Synonym for V_$ACTIVE_SERVICES
V$ACTIVE_SESSION_HISTORY - Synonym for V_$ACTIVE_SESSION_HISTORY
V$ACTIVE_SESS_POOL_MTH - Synonym for V_$ACTIVE_SESS_POOL_MTH
V$ADVISOR_PROGRESS - Synonym for V_$ADVISOR_PROGRESS
V$ALERT_TYPES - Synonym for V_$ALERT_TYPES
V$AQ - Synonym for V_$AQ
V$AQ1 - Synonym for V_$AQ1
V$ARCHIVE - Synonym for V_$ARCHIVE
V$ARCHIVED_LOG - Synonym for V_$ARCHIVED_LOG
V$ARCHIVE_DEST - Synonym for V_$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS - Synonym for V_$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP - Synonym for V_$ARCHIVE_GAP
V$ARCHIVE_PROCESSES - Synonym for V_$ARCHIVE_PROCESSES
V$ASM_ALIAS - Synonym for V_$ASM_ALIAS
V$ASM_CLIENT - Synonym for V_$ASM_CLIENT
V$ASM_DISK - Synonym for V_$ASM_DISK
V$ASM_DISKGROUP - Synonym for V_$ASM_DISKGROUP
V$ASM_DISKGROUP_STAT - Synonym for V_$ASM_DISKGROUP_STAT
V$ASM_DISK_STAT - Synonym for V_$ASM_DISK_STAT
V$ASM_FILE - Synonym for V_$ASM_FILE
V$ASM_OPERATION - Synonym for V_$ASM_OPERATION
V$ASM_TEMPLATE - Synonym for V_$ASM_TEMPLATE
V$AW_AGGREGATE_OP - Synonym for V_$AW_AGGREGATE_OP
V$AW_ALLOCATE_OP - Synonym for V_$AW_ALLOCATE_OP
V$AW_CALC - Synonym for V_$AW_CALC
V$AW_LONGOPS - Synonym for V_$AW_LONGOPS
V$AW_OLAP - Synonym for V_$AW_OLAP
V$AW_SESSION_INFO - Synonym for V_$AW_SESSION_INFO
V$BACKUP - Synonym for V_$BACKUP
V$BACKUP_ARCHIVELOG_DETAILS - Synonym for V_$BACKUP_ARCHIVELOG_DETAILS
V$BACKUP_ARCHIVELOG_SUMMARY - Synonym for V_$BACKUP_ARCHIVELOG_SUMMARY
V$BACKUP_ASYNC_IO - Synonym for V_$BACKUP_ASYNC_IO
V$BACKUP_CONTROLFILE_DETAILS - Synonym for V_$BACKUP_CONTROLFILE_DETAILS
V$BACKUP_CONTROLFILE_SUMMARY - Synonym for V_$BACKUP_CONTROLFILE_SUMMARY
V$BACKUP_COPY_DETAILS - Synonym for V_$BACKUP_COPY_DETAILS
V$BACKUP_COPY_SUMMARY - Synonym for V_$BACKUP_COPY_SUMMARY
V$BACKUP_CORRUPTION - Synonym for V_$BACKUP_CORRUPTION
V$BACKUP_DATAFILE - Synonym for V_$BACKUP_DATAFILE
V$BACKUP_DATAFILE_DETAILS - Synonym for V_$BACKUP_DATAFILE_DETAILS
V$BACKUP_DATAFILE_SUMMARY - Synonym for V_$BACKUP_DATAFILE_SUMMARY
V$BACKUP_DEVICE - Synonym for V_$BACKUP_DEVICE
V$BACKUP_FILES - Synonym for V_$BACKUP_FILES
V$BACKUP_PIECE - Synonym for V_$BACKUP_PIECE
V$BACKUP_PIECE_DETAILS - Synonym for V_$BACKUP_PIECE_DETAILS
V$BACKUP_REDOLOG - Synonym for V_$BACKUP_REDOLOG
V$BACKUP_SET - Synonym for V_$BACKUP_SET
V$BACKUP_SET_DETAILS - Synonym for V_$BACKUP_SET_DETAILS
V$BACKUP_SET_SUMMARY - Synonym for V_$BACKUP_SET_SUMMARY
V$BACKUP_SPFILE - Synonym for V_$BACKUP_SPFILE
V$BACKUP_SPFILE_DETAILS - Synonym for V_$BACKUP_SPFILE_DETAILS
V$BACKUP_SPFILE_SUMMARY - Synonym for V_$BACKUP_SPFILE_SUMMARY
V$BACKUP_SYNC_IO - Synonym for V_$BACKUP_SYNC_IO
V$BGPROCESS - Synonym for V_$BGPROCESS
V$BH - Synonym for V_$BH
V$BLOCKING_QUIESCE - Synonym for V_$BLOCKING_QUIESCE
V$BLOCK_CHANGE_TRACKING - Synonym for V_$BLOCK_CHANGE_TRACKING
V$BSP - Synonym for V_$BSP
V$BUFFERED_PUBLISHERS - Synonym for V_$BUFFERED_PUBLISHERS
V$BUFFERED_QUEUES - Synonym for V_$BUFFERED_QUEUES
V$BUFFERED_SUBSCRIBERS - Synonym for V_$BUFFERED_SUBSCRIBERS
V$BUFFER_POOL - Synonym for V_$BUFFER_POOL
V$BUFFER_POOL_STATISTICS - Synonym for V_$BUFFER_POOL_STATISTICS
V$CIRCUIT - Synonym for V_$CIRCUIT
V$CLASS_CACHE_TRANSFER - Synonym for V_$CLASS_CACHE_TRANSFER
V$CLASS_PING - Synonym for V_$CLASS_PING
V$CLIENT_STATS - Synonym for V_$CLIENT_STATS
V$CLUSTER_INTERCONNECTS - Synonym for V_$CLUSTER_INTERCONNECTS
V$CONFIGURED_INTERCONNECTS - Synonym for V_$CONFIGURED_INTERCONNECTS
V$CONTEXT - Synonym for V_$CONTEXT
V$CONTROLFILE - Synonym for V_$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION - Synonym for V_$CONTROLFILE_RECORD_SECTION
V$COPY_CORRUPTION - Synonym for V_$COPY_CORRUPTION
V$CR_BLOCK_SERVER - Synonym for V_$CR_BLOCK_SERVER
V$CURRENT_BLOCK_SERVER - Synonym for V_$CURRENT_BLOCK_SERVER
V$DATABASE - Synonym for V_$DATABASE
V$DATABASE_BLOCK_CORRUPTION - Synonym for V_$DATABASE_BLOCK_CORRUPTION
V$DATABASE_INCARNATION - Synonym for V_$DATABASE_INCARNATION
V$DATAFILE - Synonym for V_$DATAFILE
V$DATAFILE_COPY - Synonym for V_$DATAFILE_COPY
V$DATAFILE_HEADER - Synonym for V_$DATAFILE_HEADER
V$DATAGUARD_CONFIG - Synonym for V_$DATAGUARD_CONFIG
V$DATAGUARD_STATS - Synonym for V_$DATAGUARD_STATS
V$DATAGUARD_STATUS - Synonym for V_$DATAGUARD_STATUS
V$DATAPUMP_JOB - Synonym for V_$DATAPUMP_JOB
V$DATAPUMP_SESSION - Synonym for V_$DATAPUMP_SESSION
V$DBFILE - Synonym for V_$DBFILE
V$DBLINK - Synonym for V_$DBLINK
V$DB_CACHE_ADVICE - Synonym for V_$DB_CACHE_ADVICE
V$DB_OBJECT_CACHE - Synonym for V_$DB_OBJECT_CACHE
V$DB_PIPES - Synonym for V_$DB_PIPES
V$DB_TRANSPORTABLE_PLATFORM - Synonym for V_$DB_TRANSPORTABLE_PLATFORM
V$DELETED_OBJECT - Synonym for V_$DELETED_OBJECT
V$DISPATCHER - Synonym for V_$DISPATCHER
V$DISPATCHER_CONFIG - Synonym for V_$DISPATCHER_CONFIG
V$DISPATCHER_RATE - Synonym for V_$DISPATCHER_RATE
V$DLM_ALL_LOCKS - Synonym for V_$DLM_ALL_LOCKS
V$DLM_CONVERT_LOCAL - Synonym for V_$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE - Synonym for V_$DLM_CONVERT_REMOTE
V$DLM_LATCH - Synonym for V_$DLM_LATCH
V$DLM_LOCKS - Synonym for V_$DLM_LOCKS
V$DLM_MISC - Synonym for V_$DLM_MISC
V$DLM_RESS - Synonym for V_$DLM_RESS
V$DLM_TRAFFIC_CONTROLLER - Synonym for V_$DLM_TRAFFIC_CONTROLLER
V$ENABLEDPRIVS - Synonym for V_$ENABLEDPRIVS
V$ENQUEUE_LOCK - Synonym for V_$ENQUEUE_LOCK
V$ENQUEUE_STAT - Synonym for V_$ENQUEUE_STAT
V$ENQUEUE_STATISTICS - Synonym for V_$ENQUEUE_STATISTICS
V$EVENTMETRIC - Synonym for V_$EVENTMETRIC
V$EVENT_HISTOGRAM - Synonym for V_$EVENT_HISTOGRAM
V$EVENT_NAME - Synonym for V_$EVENT_NAME
V$EXECUTION - Synonym for V_$EXECUTION
V$FAST_START_SERVERS - Synonym for V_$FAST_START_SERVERS
V$FAST_START_TRANSACTIONS - Synonym for V_$FAST_START_TRANSACTIONS
V$FILEMETRIC - Synonym for V_$FILEMETRIC
V$FILEMETRIC_HISTORY - Synonym for V_$FILEMETRIC_HISTORY
V$FILESPACE_USAGE - Synonym for V_$FILESPACE_USAGE
V$FILESTAT - Synonym for V_$FILESTAT
V$FILE_CACHE_TRANSFER - Synonym for V_$FILE_CACHE_TRANSFER
V$FILE_HISTOGRAM - Synonym for V_$FILE_HISTOGRAM
V$FILE_PING - Synonym for V_$FILE_PING
V$FIXED_TABLE - Synonym for V_$FIXED_TABLE
V$FIXED_VIEW_DEFINITION - Synonym for V_$FIXED_VIEW_DEFINITION
V$FLASHBACK_DATABASE_LOG - Synonym for V_$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_LOGFILE - Synonym for V_$FLASHBACK_DATABASE_LOGFILE
V$FLASHBACK_DATABASE_STAT - Synonym for V_$FLASHBACK_DATABASE_STAT
V$FLASH_RECOVERY_AREA_USAGE - Synonym for V_$FLASH_RECOVERY_AREA_USAGE
V$GCSHVMASTER_INFO - Synonym for V_$GCSHVMASTER_INFO
V$GCSPFMASTER_INFO - Synonym for V_$GCSPFMASTER_INFO
V$GC_ELEMENT - Synonym for V_$GC_ELEMENT
V$GC_ELEMENTS_WITH_COLLISIONS - Synonym for V_$GC_ELEMENTS_W_COLLISIONS
V$GES_BLOCKING_ENQUEUE - Synonym for V_$GES_BLOCKING_ENQUEUE
V$GES_ENQUEUE - Synonym for V_$GES_ENQUEUE
V$GLOBALCONTEXT - Synonym for V_$GLOBALCONTEXT
V$GLOBAL_BLOCKED_LOCKS - Synonym for V_$GLOBAL_BLOCKED_LOCKS
V$GLOBAL_TRANSACTION - Synonym for V_$GLOBAL_TRANSACTION
V$HS_AGENT - Synonym for V_$HS_AGENT
V$HS_PARAMETER - Synonym for V_$HS_PARAMETER
V$HS_SESSION - Synonym for V_$HS_SESSION
V$HVMASTER_INFO - Synonym for V_$HVMASTER_INFO
V$INDEXED_FIXED_COLUMN - Synonym for V_$INDEXED_FIXED_COLUMN
V$INSTANCE - Synonym for V_$INSTANCE
V$INSTANCE_CACHE_TRANSFER - Synonym for V_$INSTANCE_CACHE_TRANSFER
V$INSTANCE_LOG_GROUP - Synonym for V_$INSTANCE_LOG_GROUP
V$INSTANCE_RECOVERY - Synonym for V_$INSTANCE_RECOVERY
V$JAVAPOOL - Synonym for V_$JAVAPOOL
V$JAVA_LIBRARY_CACHE_MEMORY - Synonym for V_$JAVA_LIBRARY_CACHE_MEMORY
V$JAVA_POOL_ADVICE - Synonym for V_$JAVA_POOL_ADVICE
V$LATCH - Synonym for V_$LATCH
V$LATCHHOLDER - Synonym for V_$LATCHHOLDER
V$LATCHNAME - Synonym for V_$LATCHNAME
V$LATCH_CHILDREN - Synonym for V_$LATCH_CHILDREN
V$LATCH_MISSES - Synonym for V_$LATCH_MISSES
V$LATCH_PARENT - Synonym for V_$LATCH_PARENT
V$LIBRARYCACHE - Synonym for V_$LIBRARYCACHE
V$LIBRARY_CACHE_MEMORY - Synonym for V_$LIBRARY_CACHE_MEMORY
V$LICENSE - Synonym for V_$LICENSE
V$LOADISTAT - Synonym for V_$LOADISTAT
V$LOADPSTAT - Synonym for V_$LOADPSTAT
V$LOCK - Synonym for V_$LOCK
V$LOCKED_OBJECT - Synonym for V_$LOCKED_OBJECT
V$LOCKS_WITH_COLLISIONS - Synonym for V_$LOCKS_WITH_COLLISIONS
V$LOCK_ACTIVITY - Synonym for V_$LOCK_ACTIVITY
V$LOCK_ELEMENT - Synonym for V_$LOCK_ELEMENT
V$LOCK_TYPE - Synonym for V_$LOCK_TYPE
V$LOG - Synonym for V_$LOG
V$LOGFILE - Synonym for V_$LOGFILE
V$LOGHIST - Synonym for V_$LOGHIST
V$LOGMNR_CALLBACK - Synonym for V_$LOGMNR_CALLBACK
V$LOGMNR_CONTENTS - Synonym for V_$LOGMNR_CONTENTS
V$LOGMNR_DICTIONARY - Synonym for V_$LOGMNR_DICTIONARY
V$LOGMNR_DICTIONARY_LOAD - Synonym for V_$LOGMNR_DICTIONARY_LOAD
V$LOGMNR_LATCH - Synonym for V_$LOGMNR_LATCH
V$LOGMNR_LOGFILE - Synonym for V_$LOGMNR_LOGFILE
V$LOGMNR_LOGS - Synonym for V_$LOGMNR_LOGS
V$LOGMNR_PARAMETERS - Synonym for V_$LOGMNR_PARAMETERS
V$LOGMNR_PROCESS - Synonym for V_$LOGMNR_PROCESS
V$LOGMNR_REGION - Synonym for V_$LOGMNR_REGION
V$LOGMNR_SESSION - Synonym for V_$LOGMNR_SESSION
V$LOGMNR_STATS - Synonym for V_$LOGMNR_STATS
V$LOGMNR_TRANSACTION - Synonym for V_$LOGMNR_TRANSACTION
V$LOGSTDBY - Synonym for V_$LOGSTDBY
V$LOGSTDBY_PROCESS - Synonym for V_$LOGSTDBY_PROCESS
V$LOGSTDBY_PROGRESS - Synonym for V_$LOGSTDBY_PROGRESS
V$LOGSTDBY_STATE - Synonym for V_$LOGSTDBY_STATE
V$LOGSTDBY_STATS - Synonym for V_$LOGSTDBY_STATS
V$LOGSTDBY_TRANSACTION - Synonym for V_$LOGSTDBY_TRANSACTION
V$LOG_HISTORY - Synonym for V_$LOG_HISTORY
V$MANAGED_STANDBY - Synonym for V_$MANAGED_STANDBY
V$MAP_COMP_LIST - Synonym for V_$MAP_COMP_LIST
V$MAP_ELEMENT - Synonym for V_$MAP_ELEMENT
V$MAP_EXT_ELEMENT - Synonym for V_$MAP_EXT_ELEMENT
V$MAP_FILE - Synonym for V_$MAP_FILE
V$MAP_FILE_EXTENT - Synonym for V_$MAP_FILE_EXTENT
V$MAP_FILE_IO_STACK - Synonym for V_$MAP_FILE_IO_STACK
V$MAP_LIBRARY - Synonym for V_$MAP_LIBRARY
V$MAP_SUBELEMENT - Synonym for V_$MAP_SUBELEMENT
V$MAX_ACTIVE_SESS_TARGET_MTH - Synonym for V_$MAX_ACTIVE_SESS_TARGET_MTH
V$METRIC - Synonym for V_$METRIC
V$METRICGROUP - Synonym for V_$METRICGROUP
V$METRICNAME - Synonym for V_$METRICNAME
V$METRIC_HISTORY - Synonym for V_$METRIC_HISTORY
V$MTTR_TARGET_ADVICE - Synonym for V_$MTTR_TARGET_ADVICE
V$MUTEX_SLEEP - Synonym for V_$MUTEX_SLEEP
V$MUTEX_SLEEP_HISTORY - Synonym for V_$MUTEX_SLEEP_HISTORY
V$MVREFRESH - Synonym for V_$MVREFRESH
V$MYSTAT - Synonym for V_$MYSTAT
V$NLS_PARAMETERS - Synonym for V_$NLS_PARAMETERS
V$NLS_VALID_VALUES - Synonym for V_$NLS_VALID_VALUES
V$OBJECT_DEPENDENCY - Synonym for V_$OBJECT_DEPENDENCY
V$OBSOLETE_PARAMETER - Synonym for V_$OBSOLETE_PARAMETER
V$OFFLINE_RANGE - Synonym for V_$OFFLINE_RANGE
V$OPEN_CURSOR - Synonym for V_$OPEN_CURSOR
V$OPTION - Synonym for V_$OPTION
V$OSSTAT - Synonym for V_$OSSTAT
V$PARALLEL_DEGREE_LIMIT_MTH - Synonym for V_$PARALLEL_DEGREE_LIMIT_MTH
V$PARAMETER - Synonym for V_$PARAMETER
V$PARAMETER2 - Synonym for V_$PARAMETER2
V$PARAMETER_VALID_VALUES - Synonym for V_$PARAMETER_VALID_VALUES
V$PGASTAT - Synonym for V_$PGASTAT
V$PGA_TARGET_ADVICE - Synonym for V_$PGA_TARGET_ADVICE
V$PGA_TARGET_ADVICE_HISTOGRAM - Synonym for V_$PGA_TARGET_ADVICE_HISTOGRAM
V$PQ_SESSTAT - Synonym for V_$PQ_SESSTAT
V$PQ_SLAVE - Synonym for V_$PQ_SLAVE
V$PQ_SYSSTAT - Synonym for V_$PQ_SYSSTAT
V$PQ_TQSTAT - Synonym for V_$PQ_TQSTAT
V$PROCESS - Synonym for V_$PROCESS
V$PROCESS_MEMORY - Synonym for V_$PROCESS_MEMORY
V$PROCESS_MEMORY_DETAIL - Synonym for V_$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL_PROG - Synonym for V_$PROCESS_MEMORY_DETAIL_PROG
V$PROPAGATION_RECEIVER - Synonym for V_$PROPAGATION_RECEIVER
V$PROPAGATION_SENDER - Synonym for V_$PROPAGATION_SENDER
V$PROXY_ARCHIVEDLOG - Synonym for V_$PROXY_ARCHIVEDLOG
V$PROXY_ARCHIVELOG_DETAILS - Synonym for V_$PROXY_ARCHIVELOG_DETAILS
V$PROXY_ARCHIVELOG_SUMMARY - Synonym for V_$PROXY_ARCHIVELOG_SUMMARY
V$PROXY_COPY_DETAILS - Synonym for V_$PROXY_COPY_DETAILS
V$PROXY_COPY_SUMMARY - Synonym for V_$PROXY_COPY_SUMMARY
V$PROXY_DATAFILE - Synonym for V_$PROXY_DATAFILE
V$PWFILE_USERS - Synonym for V_$PWFILE_USERS
V$PX_BUFFER_ADVICE - Synonym for V_$PX_BUFFER_ADVICE
V$PX_PROCESS - Synonym for V_$PX_PROCESS
V$PX_PROCESS_SYSSTAT - Synonym for V_$PX_PROCESS_SYSSTAT
V$PX_SESSION - Synonym for V_$PX_SESSION
V$PX_SESSTAT - Synonym for V_$PX_SESSTAT
V$QUEUE - Synonym for V_$QUEUE
V$QUEUEING_MTH - Synonym for V_$QUEUEING_MTH
V$RECOVERY_FILE_DEST - Synonym for V_$RECOVERY_FILE_DEST
V$RECOVERY_FILE_STATUS - Synonym for V_$RECOVERY_FILE_STATUS
V$RECOVERY_LOG - Synonym for V_$RECOVERY_LOG
V$RECOVERY_PROGRESS - Synonym for V_$RECOVERY_PROGRESS
V$RECOVERY_STATUS - Synonym for V_$RECOVERY_STATUS
V$RECOVER_FILE - Synonym for V_$RECOVER_FILE
V$REPLPROP - Synonym for V_$REPLPROP
V$REPLQUEUE - Synonym for V_$REPLQUEUE
V$REQDIST - Synonym for V_$REQDIST
V$RESERVED_WORDS - Synonym for V_$RESERVED_WORDS
V$RESOURCE - Synonym for V_$RESOURCE
V$RESOURCE_LIMIT - Synonym for V_$RESOURCE_LIMIT
V$RESTORE_POINT - Synonym for V_$RESTORE_POINT
V$RESUMABLE - Synonym for V_$RESUMABLE
V$RFS_THREAD - Synonym for V_$RFS_THREAD
V$RMAN_BACKUP_JOB_DETAILS - Synonym for V_$RMAN_BACKUP_JOB_DETAILS
V$RMAN_BACKUP_SUBJOB_DETAILS - Synonym for V_$RMAN_BACKUP_SUBJOB_DETAILS
V$RMAN_BACKUP_TYPE - Synonym for V_$RMAN_BACKUP_TYPE
V$RMAN_CONFIGURATION - Synonym for V_$RMAN_CONFIGURATION
V$RMAN_OUTPUT - Synonym for V_$RMAN_OUTPUT
V$RMAN_STATUS - Synonym for V_$RMAN_STATUS
V$ROLLNAME - Synonym for V_$ROLLNAME
V$ROLLSTAT - Synonym for V_$ROLLSTAT
V$ROWCACHE - Synonym for V_$ROWCACHE
V$ROWCACHE_PARENT - Synonym for V_$ROWCACHE_PARENT
V$ROWCACHE_SUBORDINATE - Synonym for V_$ROWCACHE_SUBORDINATE
V$RSRC_CONSUMER_GROUP - Synonym for V_$RSRC_CONSUMER_GROUP
V$RSRC_CONSUMER_GROUP_CPU_MTH - Synonym for V_$RSRC_CONSUMER_GROUP_CPU_MTH
V$RSRC_CONS_GROUP_HISTORY - Synonym for V_$RSRC_CONS_GROUP_HISTORY
V$RSRC_PLAN - Synonym for V_$RSRC_PLAN
V$RSRC_PLAN_CPU_MTH - Synonym for V_$RSRC_PLAN_CPU_MTH
V$RSRC_PLAN_HISTORY - Synonym for V_$RSRC_PLAN_HISTORY
V$RSRC_SESSION_INFO - Synonym for V_$RSRC_SESSION_INFO
V$RULE - Synonym for V_$RULE
V$RULE_SET - Synonym for V_$RULE_SET
V$RULE_SET_AGGREGATE_STATS - Synonym for V_$RULE_SET_AGGREGATE_STATS
V$SCHEDULER_RUNNING_JOBS - Synonym for V_$SCHEDULER_RUNNING_JOBS
V$SEGMENT_STATISTICS - Synonym for V_$SEGMENT_STATISTICS
V$SEGSTAT - Synonym for V_$SEGSTAT
V$SEGSTAT_NAME - Synonym for V_$SEGSTAT_NAME
V$SERVICEMETRIC - Synonym for V_$SERVICEMETRIC
V$SERVICEMETRIC_HISTORY - Synonym for V_$SERVICEMETRIC_HISTORY
V$SERVICES - Synonym for V_$SERVICES
V$SERVICE_EVENT - Synonym for V_$SERVICE_EVENT
V$SERVICE_STATS - Synonym for V_$SERVICE_STATS
V$SERVICE_WAIT_CLASS - Synonym for V_$SERVICE_WAIT_CLASS
V$SERV_MOD_ACT_STATS - Synonym for V_$SERV_MOD_ACT_STATS
V$SESSION - Synonym for V_$SESSION
V$SESSION_CONNECT_INFO - Synonym for V_$SESSION_CONNECT_INFO
V$SESSION_CURSOR_CACHE - Synonym for V_$SESSION_CURSOR_CACHE
V$SESSION_EVENT - Synonym for V_$SESSION_EVENT
V$SESSION_LONGOPS - Synonym for V_$SESSION_LONGOPS
V$SESSION_OBJECT_CACHE - Synonym for V_$SESSION_OBJECT_CACHE
V$SESSION_WAIT - Synonym for V_$SESSION_WAIT
V$SESSION_WAIT_CLASS - Synonym for V_$SESSION_WAIT_CLASS
V$SESSION_WAIT_HISTORY - Synonym for V_$SESSION_WAIT_HISTORY
V$SESSMETRIC - Synonym for V_$SESSMETRIC
V$SESSTAT - Synonym for V_$SESSTAT
V$SESS_IO - Synonym for V_$SESS_IO
V$SESS_TIME_MODEL - Synonym for V_$SESS_TIME_MODEL
V$SES_OPTIMIZER_ENV - Synonym for V_$SES_OPTIMIZER_ENV
V$SGA - Synonym for V_$SGA
V$SGAINFO - Synonym for V_$SGAINFO
V$SGASTAT - Synonym for V_$SGASTAT
V$SGA_CURRENT_RESIZE_OPS - Synonym for V_$SGA_CURRENT_RESIZE_OPS
V$SGA_DYNAMIC_COMPONENTS - Synonym for V_$SGA_DYNAMIC_COMPONENTS
V$SGA_DYNAMIC_FREE_MEMORY - Synonym for V_$SGA_DYNAMIC_FREE_MEMORY
V$SGA_RESIZE_OPS - Synonym for V_$SGA_RESIZE_OPS
V$SGA_TARGET_ADVICE - Synonym for V_$SGA_TARGET_ADVICE
V$SHARED_POOL_ADVICE - Synonym for V_$SHARED_POOL_ADVICE
V$SHARED_POOL_RESERVED - Synonym for V_$SHARED_POOL_RESERVED
V$SHARED_SERVER - Synonym for V_$SHARED_SERVER
V$SHARED_SERVER_MONITOR - Synonym for V_$SHARED_SERVER_MONITOR
V$SORT_SEGMENT - Synonym for V_$SORT_SEGMENT
V$SORT_USAGE - Synonym for V_$SORT_USAGE
V$SPPARAMETER - Synonym for V_$SPPARAMETER
V$SQL - Synonym for V_$SQL
V$SQLAREA - Synonym for V_$SQLAREA
V$SQLAREA_PLAN_HASH - Synonym for V_$SQLAREA_PLAN_HASH
V$SQLSTATS - Synonym for V_$SQLSTATS
V$SQLTEXT - Synonym for V_$SQLTEXT
V$SQLTEXT_WITH_NEWLINES - Synonym for V_$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_CAPTURE - Synonym for V_$SQL_BIND_CAPTURE
V$SQL_BIND_DATA - Synonym for V_$SQL_BIND_DATA
V$SQL_BIND_METADATA - Synonym for V_$SQL_BIND_METADATA
V$SQL_CURSOR - Synonym for V_$SQL_CURSOR
V$SQL_JOIN_FILTER - Synonym for V_$SQL_JOIN_FILTER
V$SQL_OPTIMIZER_ENV - Synonym for V_$SQL_OPTIMIZER_ENV
V$SQL_PLAN - Synonym for V_$SQL_PLAN
V$SQL_PLAN_STATISTICS - Synonym for V_$SQL_PLAN_STATISTICS
V$SQL_PLAN_STATISTICS_ALL - Synonym for V_$SQL_PLAN_STATISTICS_ALL
V$SQL_REDIRECTION - Synonym for V_$SQL_REDIRECTION
V$SQL_SHARED_CURSOR - Synonym for V_$SQL_SHARED_CURSOR
V$SQL_SHARED_MEMORY - Synonym for V_$SQL_SHARED_MEMORY
V$SQL_WORKAREA - Synonym for V_$SQL_WORKAREA
V$SQL_WORKAREA_ACTIVE - Synonym for V_$SQL_WORKAREA_ACTIVE
V$SQL_WORKAREA_HISTOGRAM - Synonym for V_$SQL_WORKAREA_HISTOGRAM
V$STANDBY_APPLY_SNAPSHOT - Synonym for V_$STANDBY_APPLY_SNAPSHOT
V$STANDBY_LOG - Synonym for V_$STANDBY_LOG
V$STATISTICS_LEVEL - Synonym for V_$STATISTICS_LEVEL
V$STATNAME - Synonym for V_$STATNAME
V$STREAMS_APPLY_COORDINATOR - Synonym for V_$STREAMS_APPLY_COORDINATOR
V$STREAMS_APPLY_READER - Synonym for V_$STREAMS_APPLY_READER
V$STREAMS_APPLY_SERVER - Synonym for V_$STREAMS_APPLY_SERVER
V$STREAMS_CAPTURE - Synonym for V_$STREAMS_CAPTURE
V$STREAMS_POOL_ADVICE - Synonym for V_$STREAMS_POOL_ADVICE
V$STREAMS_TRANSACTION - Synonym for V_$STREAMS_TRANSACTION
V$SUBCACHE - Synonym for V_$SUBCACHE
V$SYSAUX_OCCUPANTS - Synonym for V_$SYSAUX_OCCUPANTS
V$SYSMETRIC - Synonym for V_$SYSMETRIC
V$SYSMETRIC_HISTORY - Synonym for V_$SYSMETRIC_HISTORY
V$SYSMETRIC_SUMMARY - Synonym for V_$SYSMETRIC_SUMMARY
V$SYSSTAT - Synonym for V_$SYSSTAT
V$SYSTEM_CURSOR_CACHE - Synonym for V_$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT - Synonym for V_$SYSTEM_EVENT
V$SYSTEM_PARAMETER - Synonym for V_$SYSTEM_PARAMETER
V$SYSTEM_PARAMETER2 - Synonym for V_$SYSTEM_PARAMETER2
V$SYSTEM_WAIT_CLASS - Synonym for V_$SYSTEM_WAIT_CLASS
V$SYS_OPTIMIZER_ENV - Synonym for V_$SYS_OPTIMIZER_ENV
V$SYS_TIME_MODEL - Synonym for V_$SYS_TIME_MODEL
V$TABLESPACE - Synonym for V_$TABLESPACE
V$TEMPFILE - Synonym for V_$TEMPFILE
V$TEMPORARY_LOBS - Synonym for V_$TEMPORARY_LOBS
V$TEMPSEG_USAGE - Synonym for V_$SORT_USAGE
V$TEMPSTAT - Synonym for V_$TEMPSTAT
V$TEMP_CACHE_TRANSFER - Synonym for V_$TEMP_CACHE_TRANSFER
V$TEMP_EXTENT_MAP - Synonym for V_$TEMP_EXTENT_MAP
V$TEMP_EXTENT_POOL - Synonym for V_$TEMP_EXTENT_POOL
V$TEMP_HISTOGRAM - Synonym for V_$TEMP_HISTOGRAM
V$TEMP_PING - Synonym for V_$TEMP_PING
V$TEMP_SPACE_HEADER - Synonym for V_$TEMP_SPACE_HEADER
V$THREAD - Synonym for V_$THREAD
V$THRESHOLD_TYPES - Synonym for V_$THRESHOLD_TYPES
V$TIMER - Synonym for V_$TIMER
V$TIMEZONE_FILE - Synonym for V_$TIMEZONE_FILE
V$TIMEZONE_NAMES - Synonym for V_$TIMEZONE_NAMES
V$TRANSACTION - Synonym for V_$TRANSACTION
V$TRANSACTION_ENQUEUE - Synonym for V_$TRANSACTION_ENQUEUE
V$TRANSPORTABLE_PLATFORM - Synonym for V_$TRANSPORTABLE_PLATFORM
V$TSM_SESSIONS - Synonym for V_$TSM_SESSIONS
V$TYPE_SIZE - Synonym for V_$TYPE_SIZE
V$UNDOSTAT - Synonym for V_$UNDOSTAT
V$UNUSABLE_BACKUPFILE_DETAILS - Synonym for V_$UNUSABLE_BACKUPFILE_DETAILS
V$VERSION - Synonym for V_$VERSION
V$VPD_POLICY - Synonym for V_$VPD_POLICY
V$WAITCLASSMETRIC - Synonym for V_$WAITCLASSMETRIC
V$WAITCLASSMETRIC_HISTORY - Synonym for V_$WAITCLASSMETRIC_HISTORY
V$WAITSTAT - Synonym for V_$WAITSTAT
V$WALLET - Synonym for V_$WALLET
V$XML_AUDIT_TRAIL - Synonym for V_$XML_AUDIT_TRAIL
V$_LOCK - Synonym for V_$_LOCK

398 rows selected.

SQL> SPOOL OFF;

Oracle Dictionary - User Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'USER_%' ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
USER_ADVISOR_ACTIONS
USER_ADVISOR_DIRECTIVES
USER_ADVISOR_FINDINGS
USER_ADVISOR_JOURNAL
USER_ADVISOR_LOG
USER_ADVISOR_OBJECTS
USER_ADVISOR_PARAMETERS
USER_ADVISOR_RATIONALE
USER_ADVISOR_RECOMMENDATIONS
USER_ADVISOR_SQLA_REC_SUM
USER_ADVISOR_SQLA_WK_MAP
USER_ADVISOR_SQLA_WK_STMTS
USER_ADVISOR_SQLW_COLVOL
USER_ADVISOR_SQLW_JOURNAL
USER_ADVISOR_SQLW_PARAMETERS
USER_ADVISOR_SQLW_STMTS
USER_ADVISOR_SQLW_SUM
USER_ADVISOR_SQLW_TABLES
USER_ADVISOR_SQLW_TABVOL
USER_ADVISOR_SQLW_TEMPLATES
USER_ADVISOR_TASKS
USER_ADVISOR_TEMPLATES
USER_ALL_TABLES - Description of all object and relational tables owned by the user's
USER_AQ_AGENT_PRIVS -
USER_ARGUMENTS - Arguments in object accessible to the user
USER_ASSOCIATIONS - All assocations defined by the user
USER_ATTRIBUTE_TRANSFORMATIONS -
USER_AUDIT_OBJECT - Audit trail records for statements concerning objects, specifically: table, cluster, view, index, se
- quence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace,
- role, user
USER_AUDIT_POLICIES - All fine grained auditing policies for objects in user schema
USER_AUDIT_POLICY_COLUMNS - Users fine grained auditing policy columns in the database
USER_AUDIT_SESSION - All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT - Audit trail records concerning grant, revoke, audit, noaudit and alter system
USER_AUDIT_TRAIL - Audit trail entries relevant to the user
USER_AWS - Analytic Workspaces owned by the user
USER_AW_OBJ - Objects in Analytic Workspaces owned by the user
USER_AW_PROP - Object properties in Analytic Workspaces owned by the user
USER_AW_PS - Pagespaces in Analytic Workspaces owned by the user
USER_BASE_TABLE_MVIEWS - All materialized views with log(s) owned by the user in the database
USER_CATALOG - Tables, Views, Synonyms and Sequences owned by the user
USER_CHANGE_NOTIFICATION_REGS - change notification registrations for current user
USER_CLUSTERS - Descriptions of user's own clusters
USER_CLUSTER_HASH_EXPRESSIONS - Hash functions for the user's hash clusters
USER_CLU_COLUMNS - Mapping of table columns to cluster columns
USER_COLL_TYPES - Description of the user's own named collection types
USER_COL_COMMENTS - Comments on columns of user's tables and views
USER_COL_PRIVS - Grants on columns for which the user is the owner, grantor or grantee
USER_COL_PRIVS_MADE - All grants on columns of objects owned by the user
USER_COL_PRIVS_RECD - Grants on columns for which the user is the grantee
USER_CONSTRAINTS - Constraint definitions on user's own tables
USER_CONS_COLUMNS - Information about accessible columns in constraint definitions
USER_CONS_OBJ_COLUMNS - List of types an object column or attribute is constrained to in the tables owned by the user
USER_DATAPUMP_JOBS - Datapump jobs for current user
USER_DB_LINKS - Database links owned by the user
USER_DEPENDENCIES - Dependencies to and from a users objects
USER_DIMENSIONS - Description of the dimension objects accessible to the DBA
USER_DIM_ATTRIBUTES - Representation of the relationship between a dimension level and a functionally dependent column
USER_DIM_CHILD_OF - Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
USER_DIM_HIERARCHIES - Representation of a dimension hierarchy
USER_DIM_JOIN_KEY - Representation of a join between two dimension tables.
USER_DIM_LEVELS - Description of dimension levels visible to DBA
USER_DIM_LEVEL_KEY - Representations of columns of a dimension level
USER_ENCRYPTED_COLUMNS - Encryption information on columns of tables owned by the user
USER_EPG_DAD_AUTHORIZATION - DADs authorized to use the user's privileges
USER_ERRORS - Current errors on stored objects owned by the user
USER_EVALUATION_CONTEXTS - rule evaluation contexts owned by user
USER_EVALUATION_CONTEXT_TABLES - tables in user rule evaluation contexts
USER_EVALUATION_CONTEXT_VARS - variables in user rule evaluation contexts
USER_EXTENTS - Extents comprising segments owned by the user
USER_EXTERNAL_LOCATIONS - Description of the user's external tables locations
USER_EXTERNAL_TABLES - Description of the user's own external tables
USER_FILE_GROUPS - Details about file groups
USER_FILE_GROUP_EXPORT_INFO - Details about export information of file group versions
USER_FILE_GROUP_FILES - Details about file group files
USER_FILE_GROUP_TABLES - Details about the tables in the file group repository
USER_FILE_GROUP_TABLESPACES - Details about the transportable tablespaces in the file group repository
USER_FILE_GROUP_VERSIONS - Details about file group versions
USER_FREE_SPACE - Free extents in tablespaces accessible to the user
USER_HISTOGRAMS - Synonym for USER_TAB_HISTOGRAMS
USER_INDEXES - Description of the user's own indexes
USER_INDEXTYPES - All user indextypes
USER_INDEXTYPE_ARRAYTYPES - All array types specified by the indextype
USER_INDEXTYPE_COMMENTS - Comments for user-defined indextypes
USER_INDEXTYPE_OPERATORS - All user indextype operators
USER_IND_COLUMNS - COLUMNs comprising user's INDEXes and INDEXes on user's TABLES
USER_IND_EXPRESSIONS - Functional index expressions in user's indexes and indexes on user's tables
USER_IND_PARTITIONS -
USER_IND_STATISTICS - Optimizer statistics for user's own indexes
USER_IND_SUBPARTITIONS -
USER_INTERNAL_TRIGGERS - Description of the internal triggers on the user's own tables
USER_JAVA_ARGUMENTS - argument information of stored java class owned by the user
USER_JAVA_CLASSES - class level information of stored java class owned by the user
USER_JAVA_DERIVATIONS - this view maps java source objects and their derived java class objects and java resource objects for the java class owned by user
USER_JAVA_FIELDS - field information of stored java class owned by the user
USER_JAVA_IMPLEMENTS - interfaces implemented by the stored java class owned by user
USER_JAVA_INNERS - list of inner classes refered by the stored java class owned by user
USER_JAVA_LAYOUTS - class layout information about stored java class owned by the user
USER_JAVA_METHODS - method information of stored java class owned by the user
USER_JAVA_NCOMPS - ncomp related information of java classes owned by user
USER_JAVA_POLICY - java security Permissions for current user
USER_JAVA_RESOLVERS - resolver of java class owned by user
USER_JAVA_THROWS - list of exceptions thrown from a method of a class owned by user
USER_JOBS - All jobs owned by this user
USER_JOIN_IND_COLUMNS - Join Index columns comprising the join conditions
USER_LIBRARIES - Description of the user's own libraries
USER_LOBS - Description of the user's own LOBs contained in the user's own tables
USER_LOB_PARTITIONS -
USER_LOB_SUBPARTITIONS -
USER_LOB_TEMPLATES -
USER_LOG_GROUPS - Log group definitions on user's own tables
USER_LOG_GROUP_COLUMNS - Information about columns in log group definitions
USER_METHOD_PARAMS - Description of method parameters of the user's own types
USER_METHOD_RESULTS - Description of method results of the user's own types
USER_MVIEWS - All materialized views in the database
USER_MVIEW_AGGREGATES - Description of the materialized view aggregates created by the user
USER_MVIEW_ANALYSIS - Description of the materialized views created by the user
USER_MVIEW_COMMENTS - Comments on materialized views owned by the user
USER_MVIEW_DETAIL_RELATIONS - Description of the materialized view detail tables of the materialized views created by the user
USER_MVIEW_JOINS - Description of a join between two columns in the WHERE clause of a materialized view created by the user
USER_MVIEW_KEYS - Description of the columns that appear in the GROUP BY list of a materialized view created by the user
USER_MVIEW_LOGS - All materialized view logs owned by the user
USER_MVIEW_REFRESH_TIMES - Materialized views and their last refresh times for each master table that the user can look at
USER_NESTED_TABLES - Description of nested tables contained in the user's own tables
USER_NESTED_TABLE_COLS - Columns of nested tables
USER_OBJECTS - Objects owned by the user
USER_OBJECT_SIZE - Sizes, in bytes, of various pl/sql objects
USER_OBJECT_TABLES - Description of the user's own object tables
USER_OBJ_AUDIT_OPTS - Auditing options for user's own tables and views with atleast one option set
USER_OBJ_COLATTRS - Description of object columns and attributes contained in tables owned by the user
USER_OPANCILLARY - All ancillary opertors defined by user
USER_OPARGUMENTS - All operator arguments of operators defined by user
USER_OPBINDINGS - All binding functions or methods on operators defined by the user
USER_OPERATORS - All user operators
USER_OPERATOR_COMMENTS - Comments for user-defined operators
USER_OUTLINES - Stored outlines owned by the user
USER_OUTLINE_HINTS - Hints stored in outlines owned by the user
USER_PARTIAL_DROP_TABS - User tables with unused columns
USER_PART_COL_STATISTICS -
USER_PART_HISTOGRAMS -
USER_PART_INDEXES -
USER_PART_KEY_COLUMNS -
USER_PART_LOBS -
USER_PART_TABLES -
USER_PASSWORD_LIMITS - Display password limits of the user
USER_PENDING_CONV_TABLES - All user's tables which are not upgraded to the latest type version
USER_PLSQL_OBJECT_SETTINGS - Compiler settings of stored objects owned by the user
USER_POLICIES - All row level security policies for synonyms, tables, or views owned by the user
USER_POLICY_CONTEXTS - All policy driving context defined for synonyms, tables, or views in current schema
USER_POLICY_GROUPS - All policy groups defined for any synonym, table, or view
USER_PROCEDURES - Description of the users own procedures
USER_PROXIES - Description of connections the user is allowed to proxy
USER_PUBLISHED_COLUMNS - Source columns available for Change Data Capture
USER_QUEUES - All queues owned by the user
USER_QUEUE_PUBLISHERS -
USER_QUEUE_SCHEDULES -
USER_QUEUE_SUBSCRIBERS - queue subscribers under a user'schema
USER_QUEUE_TABLES - All queue tables created by the user
USER_RECYCLEBIN - User view of his recyclebin
USER_REFRESH - All the refresh groups
USER_REFRESH_CHILDREN - All the objects in refresh groups, where the user owns the refresh group
USER_REFS - Description of the user's own REF columns contained in the user's own tables
USER_REGISTERED_MVIEWS - Remote materialized views of local tables currently using logs owned by the user
USER_REGISTERED_SNAPSHOTS - Remote snapshots of local tables currently using logs owned by the user
USER_REGISTRY -
USER_REPAUDIT_ATTRIBUTE - Information about attributes automatically maintained for replication
USER_REPAUDIT_COLUMN - Information about columns in all shadow tables for user's replicated tables
USER_REPCAT -
USER_REPCATLOG - Information about the current user's asynchronous administration requests
USER_REPCOLUMN - Replicated columns for the current user's table in ascending order
USER_REPCOLUMN_GROUP - All column groups of user's replicated tables
USER_REPCONFLICT -
USER_REPDDL - Arguments that do not fit in a single repcat log record
USER_REPFLAVORS - Flavors current user created for replicated object groups
USER_REPFLAVOR_COLUMNS - Replicated columns from current user's tables in flavors
USER_REPFLAVOR_OBJECTS - Replicated user objects in flavors
USER_REPGENERATED - Objects generated for the current user to support replication
USER_REPGENOBJECTS - Objects generated for the current user to support replication
USER_REPGROUP - Replication information about the current user
USER_REPGROUPED_COLUMN - Columns in the all column groups of user's replicated tables
USER_REPGROUP_PRIVILEGES - Information about users who are registered for object group privileges
USER_REPKEY_COLUMNS - Primary columns for a table using column-level replication
USER_REPOBJECT - Replication information about the current user's objects
USER_REPPARAMETER_COLUMN - All columns used for resolving conflicts in user's replicated tables
USER_REPPRIORITY - Values and their corresponding priorities in user's priority groups
USER_REPPRIORITY_GROUP - Information about user's priority groups
USER_REPPROP - Propagation information about the current user's objects
USER_REPRESOLUTION - Description of all conflict resolutions for user's replicated tables
USER_REPRESOLUTION_METHOD - All conflict resolution methods accessible to the user
USER_REPRESOLUTION_STATISTICS - Statistics for conflict resolutions for user's replicated tables
USER_REPRESOL_STATS_CONTROL - Information about statistics collection for conflict resolutions for user's replicated tables
USER_REPSCHEMA - N-way replication information about the current user
USER_REPSITES - N-way replication information about the current user
USER_RESOURCE_LIMITS - Display resource limit of the user
USER_RESUMABLE - Resumable session information for current user
USER_REWRITE_EQUIVALENCES - Description of all rewrite equivalence owned by the user
USER_ROLE_PRIVS - Roles granted to current user
USER_RSRC_CONSUMER_GROUP_PRIVS - Switch privileges for consumer groups for the user
USER_RSRC_MANAGER_SYSTEM_PRIVS - system privileges for the resource manager for the user
USER_RULES - Rules owned by the user
USER_RULESETS - Rulesets owned by the user: maintained for backward compatibility
USER_RULE_SETS - Rule sets owned by the user
USER_RULE_SET_RULES - Rules in user rule sets
USER_SCHEDULER_CHAINS - All scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_RULES - All rules from scheduler chains owned by the current user
USER_SCHEDULER_CHAIN_STEPS - All steps of scheduler chains owned by the current user
USER_SCHEDULER_JOBS - All scheduler jobs in the database
USER_SCHEDULER_JOB_ARGS - All arguments with set values of all scheduler jobs in the database
USER_SCHEDULER_JOB_LOG - Logged information for all scheduler jobs
USER_SCHEDULER_JOB_RUN_DETAILS - The details of a job run
USER_SCHEDULER_PROGRAMS - Scheduler programs owned by the current user
USER_SCHEDULER_PROGRAM_ARGS - All arguments of all scheduler programs in the database
USER_SCHEDULER_RUNNING_CHAINS - All steps of chains being run by jobs owned by the current user
USER_SCHEDULER_SCHEDULES - Schedules belonging to the current user
USER_SECONDARY_OBJECTS - All secondary objects for domain indexes
USER_SEC_RELEVANT_COLS - Security Relevant columns of VPD policies for tables or views owned by the user
USER_SEGMENTS - Storage allocated for all database segments
USER_SEQUENCES - Description of the user's own SEQUENCEs
USER_SNAPSHOTS - Snapshots the user can look at
USER_SNAPSHOT_LOGS - All snapshot logs owned by the user
USER_SNAPSHOT_REFRESH_TIMES - Synonym for USER_MVIEW_REFRESH_TIMES
USER_SOURCE - Source of stored objects accessible to the user
USER_SOURCE_TABLES - Source tables available for Change Data Capture
USER_SQLJ_TYPES - Description of the user's own types
USER_SQLJ_TYPE_ATTRS - Description of attributes of the user's own types
USER_SQLJ_TYPE_METHODS - Description of methods of the user's own types
USER_SQLSET -
USER_SQLSET_BINDS -
USER_SQLSET_DEFINITIONS - Synonym for USER_SQLSET
USER_SQLSET_PLANS -
USER_SQLSET_REFERENCES -
USER_SQLSET_STATEMENTS -
USER_SQLTUNE_BINDS -
USER_SQLTUNE_PLANS -
USER_SQLTUNE_RATIONALE_PLAN -
USER_SQLTUNE_STATISTICS -
USER_STORED_SETTINGS - Parameter settings for objects owned by the user
USER_SUBPARTITION_TEMPLATES -
USER_SUBPART_COL_STATISTICS -
USER_SUBPART_HISTOGRAMS -
USER_SUBPART_KEY_COLUMNS -
USER_SUBSCRIBED_COLUMNS - Change Data Capture subscribed columns
USER_SUBSCRIBED_TABLES - Change Data Capture subscribed tables
USER_SUBSCRIPTIONS - Change Data Capture subscriptions
USER_SUMMARIES - Description of the summaries created by the user
USER_SYNONYMS - The user's private synonyms
USER_SYS_PRIVS - System privileges granted to current user
USER_TABLES - Description of the user's own relational tables
USER_TABLESPACES - Description of accessible tablespaces
USER_TAB_COLS - Columns of user's tables, views and clusters
USER_TAB_COLUMNS - Columns of user's tables, views and clusters
USER_TAB_COL_STATISTICS - Columns of user's tables, views and clusters
USER_TAB_COMMENTS - Comments on the tables and views owned by the user
USER_TAB_HISTOGRAMS - Histograms on columns of user's tables
USER_TAB_MODIFICATIONS - Information regarding modifications to tables
USER_TAB_PARTITIONS -
USER_TAB_PRIVS - Grants on objects for which the user is the owner, grantor or grantee
USER_TAB_PRIVS_MADE - All grants on objects owned by the user
USER_TAB_PRIVS_RECD - Grants on objects for which the user is the grantee
USER_TAB_STATISTICS - Optimizer statistics of the user's own tables
USER_TAB_STATS_HISTORY - History of table statistics modifications
USER_TAB_SUBPARTITIONS -
USER_TRANSFORMATIONS -
USER_TRIGGERS - Triggers owned by the user
USER_TRIGGER_COLS - Column usage in user's triggers
USER_TS -
USER_TS_QUOTAS - Tablespace quotas for the user
USER_TUNE_MVIEW - tune_mview catalog view owned by the user
USER_TYPES - Description of the user's own types
USER_TYPE_ATTRS - Description of attributes of the user's own types
USER_TYPE_METHODS - Description of methods of the user's own types
USER_TYPE_VERSIONS - Description of each version of the user's types
USER_UNUSED_COL_TABS - User tables with unused columns
USER_UPDATABLE_COLUMNS - Description of updatable columns
USER_USERS - Information about the current user
USER_USTATS - All statistics on tables or indexes owned by the user
USER_VARRAYS - Description of varrays contained in the user's own tables
USER_VIEWS - Description of the user's own views
USER_WARNING_SETTINGS - Warning Parameter settings for objects owned by the user
USER_WORKSPACES -
USER_XML_COLUMN_NAMES -
USER_XML_INDEXES - Description of the user's own XMLType indexes
USER_XML_SCHEMAS - Description of XML Schemas registered by the user
USER_XML_TABLES - Description of the user's own XMLType tables
USER_XML_TAB_COLS - Description of the user's own XMLType tables
USER_XML_VIEWS - Description of the user's own XMLType views
USER_XML_VIEW_COLS - Description of the user's own XMLType views

285 rows selected.

SQL> SPOOL OFF;

Oracle Dictionary - All Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'ALL_%' ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
ALL_ALL_TABLES - Description of all object and relational tables accessible to the user
ALL_APPLY - Details about each apply process that dequeues from the queue visible to the current user
ALL_APPLY_CONFLICT_COLUMNS - Details about conflict resolution on tables visible to the current user
ALL_APPLY_DML_HANDLERS - Details about the dml handler on tables visible to the current user
ALL_APPLY_ENQUEUE - Details about the apply enqueue action for user accessible rules where the destination queue exists
- and is visible to the user
ALL_APPLY_ERROR - Error transactions that were generated after dequeuing from the queue visible to the current user
ALL_APPLY_EXECUTE - Details about the apply execute action for all rules visible to the user
ALL_APPLY_KEY_COLUMNS - Alternative key columns for a STREAMS table visible to the current user
ALL_APPLY_PARAMETERS - Details about parameters of each apply process that dequeues from the queue visible to the current user
ALL_APPLY_PROGRESS - Information about the progress made by the apply process that dequeues from the queue visible to the current user
ALL_APPLY_TABLE_COLUMNS - Details about the columns of destination table object visible to the user
ALL_ARGUMENTS - Arguments in object accessible to the user
ALL_ASSOCIATIONS - All associations available to the user
ALL_AUDIT_POLICIES - All fine grained auditing policies in the database
ALL_AUDIT_POLICY_COLUMNS - All fine grained auditing policy columns in the database
ALL_AWS - Analytic Workspaces accessible to the user
ALL_AW_AC - Active Catalog Analytic Workspaces accessible to the user
ALL_AW_AC_10G -
ALL_AW_OBJ - Objects in Analytic Workspaces accessible to the user
ALL_AW_PROP - Object properties in Analytic Workspaces accessible to the user
ALL_AW_PROP_NAME - Analytic Workspace property names accessible to the user
ALL_AW_PS - Pagespaces in Analytic Workspaces accessible to the user
ALL_BASE_TABLE_MVIEWS - All materialized views with log(s) in the database that the user can see
ALL_CAPTURE - Details about each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_EXTRA_ATTRIBUTES - Extra attributes for a capture process that is visible to the current user
ALL_CAPTURE_PARAMETERS - Details about parameters for each capture process that stores the captured changes in a queue visible to the current user
ALL_CAPTURE_PREPARED_DATABASE - Is the local database prepared for instantiation?
ALL_CAPTURE_PREPARED_SCHEMAS - All user schemas at the local database that are prepared for instantiation
ALL_CAPTURE_PREPARED_TABLES - All tables visible to the current user that are prepared for instantiation
ALL_CATALOG - All tables, views, synonyms, sequences accessible to the user
ALL_CLUSTERS - Description of clusters accessible to the user
ALL_CLUSTER_HASH_EXPRESSIONS - Hash functions for all accessible clusters
ALL_COLL_TYPES - Description of named collection types accessible to the user
ALL_COL_COMMENTS - Comments on columns of accessible tables and views
ALL_COL_PRIVS - Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_COL_PRIVS_MADE - Grants on columns for which the user is owner or grantor
ALL_COL_PRIVS_RECD - Grants on columns for which the user, PUBLIC or enabled role is the grantee
ALL_CONSTRAINTS - Constraint definitions on accessible tables
ALL_CONS_COLUMNS - Information about accessible columns in constraint definitions
ALL_CONS_OBJ_COLUMNS - List of types an object column or attribute is constrained to in the tables accessible to the user
ALL_CONTEXT - Description of all active context namespaces under the current session
ALL_DB_LINKS - Database links accessible to the user
ALL_DEF_AUDIT_OPTS - Auditing options for newly created objects
ALL_DEPENDENCIES - Dependencies to and from objects accessible to the user
ALL_DEQUEUE_QUEUES - All queues accessible to the user
ALL_DIMENSIONS - Description of the dimension objects accessible to the DBA
ALL_DIM_ATTRIBUTES - Representation of the relationship between a dimension level and a functionally dependent column
ALL_DIM_CHILD_OF - Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
ALL_DIM_HIERARCHIES - Representation of a dimension hierarchy
ALL_DIM_JOIN_KEY - Representation of a join between two dimension tables.
ALL_DIM_LEVELS - Description of dimension levels visible to DBA
ALL_DIM_LEVEL_KEY - Representations of columns of a dimension level
ALL_DIRECTORIES - Description of all directories accessible to the user
ALL_ENCRYPTED_COLUMNS - Encryption information on all accessible columns
ALL_ERRORS - Current errors on stored objects that user is allowed to create
ALL_EVALUATION_CONTEXTS - rule evaluation contexts seen by user
ALL_EVALUATION_CONTEXT_TABLES - tables in all rule evaluation contexts seen by the user
ALL_EVALUATION_CONTEXT_VARS - variables in all rule evaluation contexts seen by the user
ALL_EXTERNAL_LOCATIONS - Description of the external tables locations accessible to the user
ALL_EXTERNAL_TABLES - Description of the external tables accessible to the user
ALL_FILE_GROUPS - Details about file groups
ALL_FILE_GROUP_EXPORT_INFO - Details about export information of file group versions
ALL_FILE_GROUP_FILES - Details about file group files
ALL_FILE_GROUP_TABLES - Details about the tables in the file group repository
ALL_FILE_GROUP_TABLESPACES - Details about the transportable tablespaces in the file group repository
ALL_FILE_GROUP_VERSIONS - Details about file group versions
ALL_HISTOGRAMS - Synonym for ALL_TAB_HISTOGRAMS
ALL_INDEXES - Descriptions of indexes on tables accessible to the user
ALL_INDEXTYPES - All indextypes available to the user
ALL_INDEXTYPE_ARRAYTYPES - All array types specified by the indextype
ALL_INDEXTYPE_COMMENTS - Comments for user-defined indextypes
ALL_INDEXTYPE_OPERATORS - All operators available to the user
ALL_IND_COLUMNS - COLUMNs comprising INDEXes on accessible TABLES
ALL_IND_EXPRESSIONS - FUNCTIONAL INDEX EXPRESSIONs on accessible TABLES
ALL_IND_PARTITIONS -
ALL_IND_STATISTICS - Optimizer statistics for all indexes on tables accessible to the user
ALL_IND_SUBPARTITIONS -
ALL_INTERNAL_TRIGGERS - Description of the internal triggers on the tables accessible to the user
ALL_JAVA_ARGUMENTS - argument information of stored java class accessible to the user
ALL_JAVA_CLASSES - class level information of stored java class accessible to the user
ALL_JAVA_DERIVATIONS - this view maps java source objects and their derived java class objects and java resource objects f
- or the java class accessible to user
ALL_JAVA_FIELDS - field information of stored java class accessible to user
ALL_JAVA_IMPLEMENTS - interfaces implemented by the stored java class accessible to the user
ALL_JAVA_INNERS - list of inner classes refered by the stored java class accessible to user
ALL_JAVA_LAYOUTS - class layout information about stored java class accessible to the user
ALL_JAVA_METHODS - method information of stored java class accessible to user
ALL_JAVA_NCOMPS - ncomp related information of all java classes
ALL_JAVA_RESOLVERS - resolver of java class owned by user
ALL_JAVA_THROWS - list of exceptions thrown from a method of a class accessible to user
ALL_JOBS - Synonym for USER_JOBS
ALL_JOIN_IND_COLUMNS - Join Index columns comprising the join conditions
ALL_LIBRARIES - Description of libraries accessible to the user
ALL_LOBS - Description of LOBs contained in tables accessible to the user
ALL_LOB_PARTITIONS -
ALL_LOB_SUBPARTITIONS -
ALL_LOB_TEMPLATES -
ALL_LOG_GROUPS - Log group definitions on accessible tables
ALL_LOG_GROUP_COLUMNS - Information about columns in log group definitions
ALL_METHOD_PARAMS - Description of method parameters of types accessible to the user
ALL_METHOD_RESULTS - Description of method results of types accessible to the user
ALL_MVIEWS - All materialized views in the database
ALL_MVIEW_AGGREGATES - Description of the materialized view aggregates accessible to the user
ALL_MVIEW_ANALYSIS - Description of the materialized views accessible to the user
ALL_MVIEW_COMMENTS - Comments on materialized views accessible to the user
ALL_MVIEW_DETAIL_RELATIONS - Description of the materialized view detail tables accessible to the user
ALL_MVIEW_JOINS - Description of a join between two columns in the WHERE clause of a materialized view accessible to the user
ALL_MVIEW_KEYS - Description of the columns that appear in the GROUP BY list of a materialized view accessible to the user
ALL_MVIEW_LOGS - All materialized view logs in the database that the user can see
ALL_MVIEW_REFRESH_TIMES - Materialized views and their last refresh times for each master table that the user can look at
ALL_NESTED_TABLES - Description of nested tables in tables accessible to the user
ALL_NESTED_TABLE_COLS - Columns of nested tables
ALL_OBJECTS - Objects accessible to the user
ALL_OBJECT_TABLES - Description of all object tables accessible to the user
ALL_OBJ_COLATTRS - Description of object columns and attributes contained in the tables accessible to the user
ALL_OLAP_ALTER_SESSION - Synonym for V$OLAP_ALTER_SESSION
ALL_OPANCILLARY - All ancillary operators available to the user
ALL_OPARGUMENTS - All arguments of the operators available to the user
ALL_OPBINDINGS - All binding functions for operators available to the user
ALL_OPERATORS - All operators available to the user
ALL_OPERATOR_COMMENTS - Comments for user-defined operators
ALL_OUTLINES - Synonym for USER_OUTLINES
ALL_OUTLINE_HINTS - Synonym for USER_OUTLINE_HINTS
ALL_PARTIAL_DROP_TABS - All tables with patially dropped columns accessible to the user
ALL_PART_COL_STATISTICS -
ALL_PART_HISTOGRAMS -
ALL_PART_INDEXES -
ALL_PART_KEY_COLUMNS -
ALL_PART_LOBS -
ALL_PART_TABLES -
ALL_PENDING_CONV_TABLES - All tables accessible to the user which are not upgraded to the latest type version
ALL_PLSQL_OBJECT_SETTINGS - Compiler settings of stored objects accessible to the user
ALL_POLICIES - All policies for objects if the user has system privileges or owns the objects
ALL_POLICY_CONTEXTS - All policy driving context defined for all synonyms, tables, or views accessable to the user
ALL_POLICY_GROUPS - All policy groups defined for any synonym, table or view accessable to the user
ALL_PROBE_OBJECTS -
ALL_PROCEDURES - Description of all procedures available to the user
ALL_PROPAGATION - Streams propagation seen by the user
ALL_PUBLISHED_COLUMNS - Source columns available for Change Data Capture
ALL_QUEUES - All queues accessible to the user
ALL_QUEUE_PUBLISHERS -
ALL_QUEUE_SUBSCRIBERS - All queue subscribers accessible to user
ALL_QUEUE_TABLES - All queue tables accessible to the user
ALL_REFRESH - All the refresh groups that the user can touch
ALL_REFRESH_CHILDREN - All the objects in refresh groups, where the user can touch the group
ALL_REFRESH_DEPENDENCIES - Description of the detail tables that materialized views depend on for refresh
ALL_REFS - Description of REF columns contained in tables accessible to the user
ALL_REGISTERED_MVIEWS - Remote materialized views of local tables that the user can see
ALL_REGISTERED_SNAPSHOTS - Remote snapshots of local tables that the user can see
ALL_REGISTRY_BANNERS -
ALL_REPAUDIT_ATTRIBUTE - Information about attributes automatically maintained for replication
ALL_REPAUDIT_COLUMN - Information about columns in all shadow tables for replicated tables which are accessible to the user
ALL_REPCAT -
ALL_REPCATLOG - Information about asynchronous administration requests
ALL_REPCOLUMN - Replicated top-level columns (table) sorted alphabetically in ascending order
ALL_REPCOLUMN_GROUP - All column groups of replicated tables which are accessible to the user
ALL_REPCONFLICT - All conflicts with available resolutions for user's replicated tables
ALL_REPDDL - Arguments that do not fit in a single repcat log record
ALL_REPFLAVORS - Flavors defined for replicated object groups
ALL_REPFLAVOR_COLUMNS - Replicated columns in flavors
ALL_REPFLAVOR_OBJECTS - Replicated objects in flavors
ALL_REPGENERATED - Objects generated to support replication
ALL_REPGENOBJECTS - Objects generated to support replication
ALL_REPGROUP - Information about replicated object groups
ALL_REPGROUPED_COLUMN - Columns in the all column groups of replicated tables which are accessible to the user
ALL_REPGROUP_PRIVILEGES - Information about users who are registered for object group privileges
ALL_REPKEY_COLUMNS - Primary columns for a table using column-level replication
ALL_REPOBJECT - Information about replicated objects
ALL_REPPARAMETER_COLUMN - All columns used for resolving conflicts in replicated tables which are accessible to the user
ALL_REPPRIORITY - Values and their corresponding priorities in all priority groups which are accessible to the user
ALL_REPPRIORITY_GROUP - Information about all priority groups which are accessible to the user
ALL_REPPROP - Propagation information about replicated objects
ALL_REPRESOLUTION - Description of all conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOLUTION_METHOD - All conflict resolution methods accessible to the user
ALL_REPRESOLUTION_STATISTICS - Statistics for conflict resolutions for replicated tables which are accessible to the user
ALL_REPRESOL_STATS_CONTROL - Information about statistics collection for conflict resolutions for replicated tables which are acc
- essible to the user
ALL_REPSCHEMA - N-way replication information
ALL_REPSITES - N-way replication information
ALL_REWRITE_EQUIVALENCES - Description of all rewrite equivalence accessible to the user
ALL_RULES - Rules seen by the user
ALL_RULESETS - Rulesets seen by the user: maintained for backward compatibility
ALL_RULE_SETS - Rule sets seen by the user
ALL_RULE_SET_RULES - Rules in all rule sets seen by the user
ALL_SCHEDULER_CHAINS - All scheduler chains in the database visible to current user
ALL_SCHEDULER_CHAIN_RULES - All rules from scheduler chains visible to the current user
ALL_SCHEDULER_CHAIN_STEPS - All steps of scheduler chains visible to the current user
ALL_SCHEDULER_GLOBAL_ATTRIBUTE - All scheduler global attributes
ALL_SCHEDULER_JOBS - All scheduler jobs visible to the user
ALL_SCHEDULER_JOB_ARGS - All arguments with set values of all scheduler jobs in the database
ALL_SCHEDULER_JOB_CLASSES - All scheduler classes visible to the user
ALL_SCHEDULER_JOB_LOG - Logged information for all scheduler jobs
ALL_SCHEDULER_JOB_RUN_DETAILS - The details of a job run
ALL_SCHEDULER_PROGRAMS - All scheduler programs visible to the user
ALL_SCHEDULER_PROGRAM_ARGS - All arguments of all scheduler programs visible to the user
ALL_SCHEDULER_RUNNING_CHAINS - All job steps of running job chains visible to the user
ALL_SCHEDULER_SCHEDULES - All schedules in the database
ALL_SCHEDULER_WINDOWS - All scheduler windows in the database
ALL_SCHEDULER_WINDOW_DETAILS - The details of a window
ALL_SCHEDULER_WINDOW_GROUPS - All scheduler window groups in the database
ALL_SCHEDULER_WINDOW_LOG - Logged information for all scheduler windows
ALL_SCHEDULER_WINGROUP_MEMBERS - Members of all scheduler window groups in the database
ALL_SECONDARY_OBJECTS - All secondary objects for domain indexes
ALL_SEC_RELEVANT_COLS - Security Relevant columns of all VPD policies for tables or views which the user has access
ALL_SEQUENCES - Description of SEQUENCEs accessible to the user
ALL_SERVICES -
ALL_SNAPSHOTS - Snapshots the user can access
ALL_SNAPSHOT_LOGS - All snapshot logs in the database that the user can see
ALL_SNAPSHOT_REFRESH_TIMES - Synonym for ALL_MVIEW_REFRESH_TIMES
ALL_SOURCE - Current source on stored objects that user is allowed to create
ALL_SOURCE_TABLES - Source tables available for Change Data Capture
ALL_SQLJ_TYPES - Description of types accessible to the user
ALL_SQLJ_TYPE_ATTRS - Description of attributes of types accessible to the user
ALL_SQLJ_TYPE_METHODS - Description of methods of types accessible to the user
ALL_SQLSET -
ALL_SQLSET_BINDS -
ALL_SQLSET_PLANS -
ALL_SQLSET_REFERENCES -
ALL_SQLSET_STATEMENTS -
ALL_STORED_SETTINGS - Parameter settings for objects accessible to the user
ALL_STREAMS_GLOBAL_RULES - Global rules created on the streams capture/apply/propagation process that interact with the queue v
- isible to the current user
ALL_STREAMS_MESSAGE_CONSUMERS - Streams messaging consumers visible to the current user
ALL_STREAMS_MESSAGE_RULES - Rules for Streams messaging visible to the current user
ALL_STREAMS_NEWLY_SUPPORTED - List of tables that are newly supported by Streams
ALL_STREAMS_RULES - Rules used by streams processes
ALL_STREAMS_SCHEMA_RULES - Rules created by streams administrative APIs on all user schemas
ALL_STREAMS_TABLE_RULES - Rules created by streams administrative APIs on tables visible to the current user
ALL_STREAMS_TRANSFORM_FUNCTION - Rules-based transform functions used by Streams
ALL_STREAMS_UNSUPPORTED - List of all the tables that are not supported by Streams in this release
ALL_SUBPARTITION_TEMPLATES -
ALL_SUBPART_COL_STATISTICS -
ALL_SUBPART_HISTOGRAMS -
ALL_SUBPART_KEY_COLUMNS -
ALL_SUBSCRIBED_COLUMNS - Change Data Capture subscribed columns
ALL_SUBSCRIBED_TABLES - Change Data Capture subscribed tables
ALL_SUBSCRIPTIONS - Change Data Capture subscriptions
ALL_SUMDELTA - Direct path load entries accessible to the user
ALL_SUMMARIES - Description of the summaries accessible to the user
ALL_SYNONYMS - All synonyms for base objects accessible to the user and session
ALL_TABLES - Description of relational tables accessible to the user
ALL_TAB_COLS - Columns of user's tables, views and clusters
ALL_TAB_COLUMNS - Columns of user's tables, views and clusters
ALL_TAB_COL_STATISTICS - Columns of user's tables, views and clusters
ALL_TAB_COMMENTS - Comments on tables and views accessible to the user
ALL_TAB_HISTOGRAMS - Histograms on columns of all tables visible to user
ALL_TAB_MODIFICATIONS - Information regarding modifications to tables
ALL_TAB_PARTITIONS -
ALL_TAB_PRIVS - Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee
ALL_TAB_PRIVS_MADE - User's grants and grants on user's objects
ALL_TAB_PRIVS_RECD - Grants on objects for which the user, PUBLIC or enabled role is the grantee
ALL_TAB_STATISTICS - Optimizer statistics for all tables accessible to the user
ALL_TAB_STATS_HISTORY - History of table statistics modifications
ALL_TAB_SUBPARTITIONS -
ALL_TRIGGERS - Triggers accessible to the current user
ALL_TRIGGER_COLS - Column usage in user's triggers or in triggers on user's tables
ALL_TYPES - Description of types accessible to the user
ALL_TYPE_ATTRS - Description of attributes of types accessible to the user
ALL_TYPE_METHODS - Description of methods of types accessible to the user
ALL_TYPE_VERSIONS - Description of each type version accessible to the user
ALL_UNUSED_COL_TABS - All tables with unused columns accessible to the user
ALL_UPDATABLE_COLUMNS - Description of all updatable columns
ALL_USERS - Information about all users of the database
ALL_USTATS - All statistics
ALL_VARRAYS - Description of varrays in tables accessible to the user
ALL_VIEWS - Description of views accessible to the user
ALL_WARNING_SETTINGS - Warnings ettings for objects accessible to the user
ALL_WORKSPACES -
ALL_XML_INDEXES - Description of the all XMLType indexes that the user has privileges on
ALL_XML_SCHEMAS - Description of all XML Schemas that user has privilege to reference
ALL_XML_SCHEMAS2 - Dummy version of ALL_XML_SCHEMAS that does not have an XMLTYPE column
ALL_XML_TABLES - Description of the all XMLType tables that the user has privileges on
ALL_XML_TAB_COLS - Description of the all XMLType tables that the user has privileges on
ALL_XML_VIEWS - Description of the all XMLType views that the user has privileges on
ALL_XML_VIEW_COLS - Description of the all XMLType views that the user has privileges on

272 rows selected.

SQL> SPOOL OFF;

Oracle Dictionary - DBA Views

SQL> SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA_%' ORDER BY TABLE_NAME;

TABLE_NAME COMMENTS
------------------------------ ----------------------------------------------------------------------------------------------------
DBA_2PC_NEIGHBORS - information about incoming and outgoing connections for pending transactions
DBA_2PC_PENDING - info about distributed transactions awaiting recovery
DBA_ADVISOR_ACTIONS -
DBA_ADVISOR_COMMANDS -
DBA_ADVISOR_DEFINITIONS -
DBA_ADVISOR_DEF_PARAMETERS -
DBA_ADVISOR_DIRECTIVES -
DBA_ADVISOR_FINDINGS -
DBA_ADVISOR_JOURNAL -
DBA_ADVISOR_LOG -
DBA_ADVISOR_OBJECTS -
DBA_ADVISOR_OBJECT_TYPES -
DBA_ADVISOR_PARAMETERS -
DBA_ADVISOR_PARAMETERS_PROJ -
DBA_ADVISOR_RATIONALE -
DBA_ADVISOR_RECOMMENDATIONS -
DBA_ADVISOR_SQLA_REC_SUM -
DBA_ADVISOR_SQLA_WK_MAP -
DBA_ADVISOR_SQLA_WK_STMTS -
DBA_ADVISOR_SQLW_COLVOL -
DBA_ADVISOR_SQLW_JOURNAL -
DBA_ADVISOR_SQLW_PARAMETERS -
DBA_ADVISOR_SQLW_STMTS -
DBA_ADVISOR_SQLW_SUM -
DBA_ADVISOR_SQLW_TABLES -
DBA_ADVISOR_SQLW_TABVOL -
DBA_ADVISOR_SQLW_TEMPLATES -
DBA_ADVISOR_TASKS -
DBA_ADVISOR_TEMPLATES -
DBA_ADVISOR_USAGE -
DBA_ALERT_ARGUMENTS - Message Id and arguments of outstanding alerts
DBA_ALERT_HISTORY - Description on alert history
DBA_ALL_TABLES - Description of all object and relational tables in the database
DBA_ANALYZE_OBJECTS -
DBA_APPLY - Details about the apply process
DBA_APPLY_CONFLICT_COLUMNS - Details about conflict resolution
DBA_APPLY_DML_HANDLERS - Details about the dml handler
DBA_APPLY_ENQUEUE - Details about the apply enqueue action
DBA_APPLY_ERROR - Error transactions
DBA_APPLY_EXECUTE - Details about the apply execute action
DBA_APPLY_INSTANTIATED_GLOBAL - Details about database instantiated
DBA_APPLY_INSTANTIATED_OBJECTS - Details about objects instantiated
DBA_APPLY_INSTANTIATED_SCHEMAS - Details about schemas instantiated
DBA_APPLY_KEY_COLUMNS - alternative key columns for a table for STREAMS
DBA_APPLY_OBJECT_DEPENDENCIES - Synonym for _DBA_APPLY_OBJECT_CONSTRAINTS
DBA_APPLY_PARAMETERS - All parameters for apply process
DBA_APPLY_PROGRESS - Information about the progress made by apply process
DBA_APPLY_SPILL_TXN - Streams apply spilled transactions info
DBA_APPLY_TABLE_COLUMNS - Details about the destination table columns
DBA_APPLY_VALUE_DEPENDENCIES - Synonym for _DBA_APPLY_CONSTRAINT_COLUMNS
DBA_AQ_AGENTS -
DBA_AQ_AGENT_PRIVS -
DBA_ASSOCIATIONS - All associations
DBA_ATTRIBUTE_TRANSFORMATIONS -
DBA_AUDIT_EXISTS - Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
DBA_AUDIT_OBJECT - Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence, [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
DBA_AUDIT_POLICIES - Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS - All fine grained auditing policy columns in the database
DBA_AUDIT_SESSION - All audit trail records concerning CONNECT and DISCONNECT
DBA_AUDIT_STATEMENT - Audit trail records concerning grant, revoke, audit, noaudit and alter system
DBA_AUDIT_TRAIL - All audit trail entries
DBA_AWS - Analytic Workspaces in the database
DBA_AW_OBJ - Objects in Analytic Workspaces in the database
DBA_AW_PROP - Object properties in Analytic Workspaces in the database
DBA_AW_PS - Pagespaces in Analytic Workspaces owned by the user
DBA_BASE_TABLE_MVIEWS - All materialized views with log(s) in the database
DBA_BLOCKERS -
DBA_CACHEABLE_NONTABLE_OBJECTS -
DBA_CACHEABLE_OBJECTS -
DBA_CACHEABLE_OBJECTS_BASE -
DBA_CACHEABLE_TABLES -
DBA_CACHEABLE_TABLES_BASE -
DBA_CAPTURE - Details about the capture process
DBA_CAPTURE_EXTRA_ATTRIBUTES - Extra attributes for a capture process
DBA_CAPTURE_PARAMETERS - All parameters for capture process
DBA_CAPTURE_PREPARED_DATABASE - Is the local database prepared for instantiation?
DBA_CAPTURE_PREPARED_SCHEMAS - All schemas at the local database that are prepared for instantiation
DBA_CAPTURE_PREPARED_TABLES - All tables prepared for instantiation
DBA_CATALOG - All database Tables, Views, Synonyms, Sequences
DBA_CHANGE_NOTIFICATION_REGS - Description of the registrations for change notification
DBA_CLUSTERS - Description of all clusters in the database
DBA_CLUSTER_HASH_EXPRESSIONS - Hash functions for all clusters
DBA_CLU_COLUMNS - Mapping of table columns to cluster columns
DBA_COLL_TYPES - Description of all named collection types in the database
DBA_COL_COMMENTS - Comments on columns of all tables and views
DBA_COL_PRIVS - All grants on columns in the database
DBA_COMMON_AUDIT_TRAIL - Combined Standard and Fine Grained audit trail entries
DBA_CONNECT_ROLE_GRANTEES - Information regarding which users are granted CONNECT
DBA_CONSTRAINTS - Constraint definitions on all tables
DBA_CONS_COLUMNS - Information about accessible columns in constraint definitions
DBA_CONS_OBJ_COLUMNS - List of types an object column or attribute is constrained to in all tables in the database
DBA_CONTEXT - Description of all context namespace information
DBA_CPU_USAGE_STATISTICS - Database CPU Usage Statistics
DBA_DATAPUMP_JOBS - Datapump jobs
DBA_DATAPUMP_SESSIONS - Datapump sessions attached to a job
DBA_DATA_FILES - Information about database data files
DBA_DB_LINKS - All database links in the database
DBA_DDL_LOCKS -
DBA_DEPENDENCIES - Dependencies to and from objects
DBA_DIMENSIONS - Description of the dimension objects accessible to the DBA
DBA_DIM_ATTRIBUTES - Representation of the relationship between a dimension level and a functionally dependent column
DBA_DIM_CHILD_OF - Representaion of a 1:n hierarchical relationship between a pair of levels in a dimension
DBA_DIM_HIERARCHIES - Representation of a dimension hierarchy
DBA_DIM_JOIN_KEY - Representation of a join between two dimension tables.
DBA_DIM_LEVELS - Description of dimension levels visible to DBA
DBA_DIM_LEVEL_KEY - Representations of columns of a dimension level
DBA_DIRECTORIES - Description of all directories
DBA_DML_LOCKS -
DBA_DMT_FREE_SPACE - Free extents in all dictionary managed tablespaces
DBA_DMT_USED_EXTENTS - All extents in the dictionary managed tablespaces
DBA_ENABLED_AGGREGATIONS - Information about enabled on-demand statistic aggregation
DBA_ENABLED_TRACES - Information about enabled SQL traces
DBA_ENCRYPTED_COLUMNS - Encryption information on columns in the database
DBA_EPG_DAD_AUTHORIZATION - DADs authorized to use different user's privileges
DBA_ERRORS - Current errors on all stored objects in the database
DBA_EVALUATION_CONTEXTS - rule evaluation contexts in the database
DBA_EVALUATION_CONTEXT_TABLES - tables in all rule evaluation contexts in the database
DBA_EVALUATION_CONTEXT_VARS - variables in all rule evaluation contexts in the database
DBA_EXPORT_OBJECTS - Export INCLUDE and EXCLUDE object type names
DBA_EXP_FILES - Description of export files
DBA_EXP_OBJECTS - Objects that have been incrementally exported
DBA_EXP_VERSION - Version number of the last export session
DBA_EXTENTS - Extents comprising all segments in the database
DBA_EXTERNAL_LOCATIONS - Description of the external tables locations accessible to the DBA
DBA_EXTERNAL_TABLES - Description of the external tables accessible to the DBA
DBA_FEATURE_USAGE_STATISTICS - Database Feature Usage Statistics
DBA_FGA_AUDIT_TRAIL - All fine grained audit event logs
DBA_FILE_GROUPS - Details about file groups
DBA_FILE_GROUP_EXPORT_INFO - Details about export information of file group versions
DBA_FILE_GROUP_FILES - Details about file group files
DBA_FILE_GROUP_TABLES - Details about the tables in the file group repository
DBA_FILE_GROUP_TABLESPACES - Details about the transportable tablespaces in the file group repository
DBA_FILE_GROUP_VERSIONS - Details about file group versions
DBA_FREE_SPACE - Free extents in all tablespaces
DBA_FREE_SPACE_COALESCED - Statistics on Coalesced Space in Tablespaces
DBA_GLOBAL_CONTEXT - Description of all context information accessible globally
DBA_HIGH_WATER_MARK_STATISTICS - Database High Water Mark Statistics
DBA_HISTOGRAMS - Synonym for DBA_TAB_HISTOGRAMS
DBA_HIST_ACTIVE_SESS_HISTORY - Active Session Historical Statistics Information
DBA_HIST_BASELINE - Baseline Metadata Information
DBA_HIST_BG_EVENT_SUMMARY - Summary of Background Event Historical Statistics Information
DBA_HIST_BUFFERED_QUEUES - STREAMS Buffered Queues Historical Statistics Information
DBA_HIST_BUFFERED_SUBSCRIBERS - STREAMS Buffered Queue Subscribers Historical Statistics Information
DBA_HIST_BUFFER_POOL_STAT - Buffer Pool Historical Statistics Information
DBA_HIST_COMP_IOSTAT - I/O stats aggregated on component level
DBA_HIST_CR_BLOCK_SERVER - Consistent Read Block Server Historical Statistics
DBA_HIST_CURRENT_BLOCK_SERVER - Current Block Server Historical Statistics
DBA_HIST_DATABASE_INSTANCE - Database Instance Information
DBA_HIST_DATAFILE - Names of Datafiles
DBA_HIST_DB_CACHE_ADVICE - DB Cache Advice History Information
DBA_HIST_DLM_MISC - Distributed Lock Manager Miscellaneous Historical Statistics Information
DBA_HIST_ENQUEUE_STAT - Enqueue Historical Statistics Information
DBA_HIST_EVENT_NAME - Event Names
DBA_HIST_FILEMETRIC_HISTORY - File Metrics History
DBA_HIST_FILESTATXS - Datafile Historical Statistics Information
DBA_HIST_INSTANCE_RECOVERY - Instance Recovery Historical Statistics Information
DBA_HIST_INST_CACHE_TRANSFER - Instance Cache Transfer Historical Statistics
DBA_HIST_JAVA_POOL_ADVICE - Java Pool Advice History
DBA_HIST_LATCH - Latch Historical Statistics Information
DBA_HIST_LATCH_CHILDREN - Latch Children Historical Statistics Information
DBA_HIST_LATCH_MISSES_SUMMARY - Latch Misses Summary Historical Statistics Information
DBA_HIST_LATCH_NAME - Latch Names
DBA_HIST_LATCH_PARENT - Latch Parent Historical Historical Statistics Information
DBA_HIST_LIBRARYCACHE - Library Cache Historical Statistics Information
DBA_HIST_LOG - Log Historical Statistics Information
DBA_HIST_METRIC_NAME - Segment Names
DBA_HIST_MTTR_TARGET_ADVICE - Mean-Time-To-Recover Target Advice History
DBA_HIST_OPTIMIZER_ENV - Optimizer Environment Information
DBA_HIST_OSSTAT - Operating System Historical Statistics Information
DBA_HIST_OSSTAT_NAME - Operating System Statistic Names
DBA_HIST_PARAMETER - Parameter Historical Statistics Information
DBA_HIST_PARAMETER_NAME - Parameter Names
DBA_HIST_PGASTAT - PGA Historical Statistics Information
DBA_HIST_PGA_TARGET_ADVICE - PGA Target Advice History
DBA_HIST_PROCESS_MEM_SUMMARY - Process Memory Historical Summary Information
DBA_HIST_RESOURCE_LIMIT - Resource Limit Historical Statistics Information
DBA_HIST_ROWCACHE_SUMMARY - Row Cache Historical Statistics Information Summary
DBA_HIST_RULE_SET - Rule sets historical statistics information
DBA_HIST_SEG_STAT - Historical Statistics Information
DBA_HIST_SEG_STAT_OBJ - Segment Names
DBA_HIST_SERVICE_NAME - Service Names
DBA_HIST_SERVICE_STAT - Historical Service Statistics
DBA_HIST_SERVICE_WAIT_CLASS - Historical Service Wait Class Statistics
DBA_HIST_SESSMETRIC_HISTORY - System Metrics History
DBA_HIST_SESS_TIME_STATS - CPU and I/O time for interesting (STREAMS) sessions
DBA_HIST_SGA - SGA Historical Statistics Information
DBA_HIST_SGASTAT - SGA Pool Historical Statistics Information
DBA_HIST_SGA_TARGET_ADVICE - SGA Target Advice History
DBA_HIST_SHARED_POOL_ADVICE - Shared Pool Advice History
DBA_HIST_SNAPSHOT - Snapshot Information
DBA_HIST_SNAP_ERROR - Snapshot Error Information
DBA_HIST_SQLBIND - SQL Bind Information
DBA_HIST_SQLSTAT - SQL Historical Statistics Information
DBA_HIST_SQLTEXT - SQL Text
DBA_HIST_SQL_BIND_METADATA - SQL Bind Metadata Information
DBA_HIST_SQL_PLAN - SQL Plan Information
DBA_HIST_SQL_SUMMARY - Summary of SQL Statistics
DBA_HIST_SQL_WORKAREA_HSTGRM - SQL Workarea Histogram History
DBA_HIST_STAT_NAME - Statistic Names
DBA_HIST_STREAMS_APPLY_SUM - STREAMS Apply Historical Statistics Information
DBA_HIST_STREAMS_CAPTURE - STREAMS Capture Historical Statistics Information
DBA_HIST_STREAMS_POOL_ADVICE - Streams Pool Advice History
DBA_HIST_SYSMETRIC_HISTORY - System Metrics History
DBA_HIST_SYSMETRIC_SUMMARY - System Metrics History
DBA_HIST_SYSSTAT - System Historical Statistics Information
DBA_HIST_SYSTEM_EVENT - System Event Historical Statistics Information
DBA_HIST_SYS_TIME_MODEL - System Time Model Historical Statistics Information
DBA_HIST_TABLESPACE_STAT - Tablespace Historical Statistics Information
DBA_HIST_TBSPC_SPACE_USAGE - Tablespace Usage Historical Statistics Information
DBA_HIST_TEMPFILE - Names of Temporary Datafiles
DBA_HIST_TEMPSTATXS - Temporary Datafile Historical Statistics Information
DBA_HIST_THREAD - Thread Historical Statistics Information
DBA_HIST_UNDOSTAT - Undo Historical Statistics Information
DBA_HIST_WAITCLASSMET_HISTORY - Wait Class Metric History
DBA_HIST_WAITSTAT - Wait Historical Statistics Information
DBA_HIST_WR_CONTROL - Workload Repository Control Information
DBA_IAS_CONSTRAINT_EXP -
DBA_IAS_GEN_STMTS -
DBA_IAS_GEN_STMTS_EXP -
DBA_IAS_OBJECTS -
DBA_IAS_OBJECTS_BASE -
DBA_IAS_OBJECTS_EXP -
DBA_IAS_POSTGEN_STMTS -
DBA_IAS_PREGEN_STMTS -
DBA_IAS_SITES -
DBA_IAS_TEMPLATES -
DBA_INDEXES - Description for all indexes in the database
DBA_INDEXTYPES - All indextypes
DBA_INDEXTYPE_ARRAYTYPES - All array types specified by the indextype
DBA_INDEXTYPE_COMMENTS - Comments for user-defined indextypes
DBA_INDEXTYPE_OPERATORS - All indextype operators
DBA_IND_COLUMNS - COLUMNs comprising INDEXes on all TABLEs and CLUSTERs
DBA_IND_EXPRESSIONS - FUNCTIONAL INDEX EXPRESSIONs on all TABLES and CLUSTERS
DBA_IND_PARTITIONS -
DBA_IND_STATISTICS - Optimizer statistics for all indexes in the database
DBA_IND_SUBPARTITIONS -
DBA_INTERNAL_TRIGGERS - Description of the internal triggers on all tables in the database
DBA_JAVA_ARGUMENTS - argument information of all stored java class
DBA_JAVA_CLASSES - class level information of all stored java classes
DBA_JAVA_DERIVATIONS - this view maps java source objects and their derived java class objects and java resource objects for all java classes
DBA_JAVA_FIELDS - field information of all stored java class
DBA_JAVA_IMPLEMENTS - interfaces implemented by the stored java class
DBA_JAVA_INNERS - list of inner classes refered by the stored java class
DBA_JAVA_LAYOUTS - class layout information about stored java class
DBA_JAVA_METHODS - method information of all stored java class
DBA_JAVA_NCOMPS -
DBA_JAVA_POLICY - java security Permissions for all users
DBA_JAVA_RESOLVERS - resolver of java class owned by user
DBA_JAVA_THROWS - list of exceptions thrown from a method of a class owned by user
DBA_JOBS - All jobs in the database
DBA_JOBS_RUNNING - All jobs in the database which are currently running, join v$lock and job$
DBA_JOIN_IND_COLUMNS - Join Index columns comprising the join conditions
DBA_KGLLOCK -
DBA_LIBRARIES - Description of all libraries in the database
DBA_LMT_FREE_SPACE - Free extents in all locally managed tablespaces
DBA_LMT_USED_EXTENTS - All extents in the locally managed tablespaces
DBA_LOBS - Description of LOBs contained in all tables
DBA_LOB_PARTITIONS -
DBA_LOB_SUBPARTITIONS -
DBA_LOB_TEMPLATES -
DBA_LOCK -
DBA_LOCKS - Synonym for DBA_LOCK
DBA_LOCK_INTERNAL -
DBA_LOGMNR_LOG -
DBA_LOGMNR_PURGED_LOG -
DBA_LOGMNR_SESSION -
DBA_LOGSTDBY_EVENTS - Information on why logical standby events
DBA_LOGSTDBY_HISTORY - Information on processed, active, and pending log streams
DBA_LOGSTDBY_LOG - List the information about received logs from the primary
DBA_LOGSTDBY_NOT_UNIQUE - List of all the tables with out primary or unique key not null constraints
DBA_LOGSTDBY_PARAMETERS - Miscellaneous options and settings for Logical Standby
DBA_LOGSTDBY_PROGRESS - List the SCN values describing read and apply progress
DBA_LOGSTDBY_SKIP - List the skip settings choosen
DBA_LOGSTDBY_SKIP_TRANSACTION - List the transactions to be skipped
DBA_LOGSTDBY_UNSUPPORTED - List of all the columns that are not supported by Logical Standby
DBA_LOG_GROUPS - Log group definitions on all tables
DBA_LOG_GROUP_COLUMNS - Information about columns in log group definitions
DBA_METHOD_PARAMS - Description of method parameters of all types in the database
DBA_METHOD_RESULTS - Description of method results of all types in the database
DBA_MVIEWS - All materialized views in the database
DBA_MVIEW_AGGREGATES - Description of the materialized view aggregates accessible to dba
DBA_MVIEW_ANALYSIS - Description of the materialized views accessible to dba
DBA_MVIEW_COMMENTS - Comments on all materialized views in the database
DBA_MVIEW_DETAIL_RELATIONS - Description of the materialized view detail tables accessible to dba
DBA_MVIEW_JOINS - Description of a join between two columns in the WHERE clause of a materialized view accessible to dba
DBA_MVIEW_KEYS - Description of the columns that appear in the GROUP BY list of a materialized view accessible to dba
DBA_MVIEW_LOGS - All materialized view logs in the database
DBA_MVIEW_LOG_FILTER_COLS - All filter columns (excluding PK cols) being logged in the materialized view logs
DBA_MVIEW_REFRESH_TIMES - All fast refreshable materialized views and their last refresh times for each master table
DBA_NESTED_TABLES - Description of nested tables contained in all tables
DBA_NESTED_TABLE_COLS - Columns of nested tables
DBA_OBJECTS - All objects in the database
DBA_OBJECT_SIZE - Sizes, in bytes, of various pl/sql objects
DBA_OBJECT_TABLES - Description of all object tables in the database
DBA_OBJ_AUDIT_OPTS - Auditing options for all tables and views with atleast one option set
DBA_OBJ_COLATTRS - Description of object columns and attributes contained in all tables in the database
DBA_OPANCILLARY - All ancillary operators
DBA_OPARGUMENTS - All operator arguments
DBA_OPBINDINGS - All operator binding functiosn or methods
DBA_OPERATORS - All operators
DBA_OPERATOR_COMMENTS - Comments for user-defined operators
DBA_OPTSTAT_OPERATIONS - History of statistics operations performed
DBA_OUTLINES - Stored outlines
DBA_OUTLINE_HINTS - Hints stored in outlines
DBA_OUTSTANDING_ALERTS - Description of all outstanding alerts
DBA_PARTIAL_DROP_TABS - All tables with partially dropped columns in the database
DBA_PART_COL_STATISTICS -
DBA_PART_HISTOGRAMS -
DBA_PART_INDEXES -
DBA_PART_KEY_COLUMNS -
DBA_PART_LOBS -
DBA_PART_TABLES -
DBA_PENDING_CONV_TABLES - All tables which are not upgraded to the latest type version in the database
DBA_PENDING_TRANSACTIONS - information about unresolved global transactions
DBA_PLSQL_OBJECT_SETTINGS - Compiler settings of all objects in the database
DBA_POLICIES - All row level security policies in the database
DBA_POLICY_CONTEXTS - All policy driving context defined for any synonym, table, or view in the database
DBA_POLICY_GROUPS - All policy groups defined for any synonym, table, view in the database
DBA_PRIV_AUDIT_OPTS - Describes current system privileges being audited across the system and by user
DBA_PROCEDURES - Description of all procedures
DBA_PROFILES - Display all profiles and their limits
DBA_PROPAGATION - Streams propagation in the database
DBA_PROXIES - Information about all proxy connections
DBA_PUBLISHED_COLUMNS - Source columns available for Change Data Capture
DBA_QUEUES - All database queues
DBA_QUEUE_PUBLISHERS -
DBA_QUEUE_SCHEDULES -
DBA_QUEUE_SUBSCRIBERS - queue subscribers in the database
DBA_QUEUE_TABLES - All queue tables created in the database
DBA_RCHILD - All the children in any refresh group. This view is not a join.
DBA_RECOVERABLE_SCRIPT - Details about recoverable operations
DBA_RECOVERABLE_SCRIPT_BLOCKS - Details about the recoverable script blocks
DBA_RECOVERABLE_SCRIPT_ERRORS - Details showing errors during script execution
DBA_RECOVERABLE_SCRIPT_PARAMS - Details about the recoverable operation parameters
DBA_RECYCLEBIN - Description of the Recyclebin view accessible to the user
DBA_REFRESH - All the refresh groups
DBA_REFRESH_CHILDREN - All the objects in refresh groups
DBA_REFS - Description of REF columns contained in all tables
DBA_REGISTERED_ARCHIVED_LOG - Details about the registered log files
DBA_REGISTERED_MVIEWS - Remote materialized views of local tables
DBA_REGISTERED_MVIEW_GROUPS - Materialized view repgroup registration information
DBA_REGISTERED_SNAPSHOTS - Remote snapshots of local tables
DBA_REGISTERED_SNAPSHOT_GROUPS - Snapshot repgroup registration information
DBA_REGISTRY -
DBA_REGISTRY_HIERARCHY -
DBA_REGISTRY_HISTORY -
DBA_REGISTRY_LOG -
DBA_REPAUDIT_ATTRIBUTE - Information about attributes automatically maintained for replication
DBA_REPAUDIT_COLUMN - Information about columns in all shadow tables for all replicated tables in the database
DBA_REPCAT -
DBA_REPCATLOG - Information about asynchronous administration requests
DBA_REPCAT_EXCEPTIONS - Repcat processing exceptions table.
DBA_REPCOLUMN - Replicated top-level columns (table) sorted alphabetically in ascending order
DBA_REPCOLUMN_GROUP - All column groups of replicated tables in the database
DBA_REPCONFLICT - All conflicts for which users have specified resolutions in the database
DBA_REPDDL - Arguments that do not fit in a single repcat log record
DBA_REPEXTENSIONS - Information about replication extension requests
DBA_REPFLAVORS - Flavors defined for replicated object groups
DBA_REPFLAVOR_COLUMNS - Replicated columns in flavors
DBA_REPFLAVOR_OBJECTS - Replicated objects in flavors
DBA_REPGENERATED - Objects generated to support replication
DBA_REPGENOBJECTS - Objects generated to support replication
DBA_REPGROUP - Information about all replicated object groups
DBA_REPGROUPED_COLUMN - Columns in the all column groups of replicated tables in the database
DBA_REPGROUP_PRIVILEGES - Information about users who are registered for object group privileges
DBA_REPKEY_COLUMNS - Primary columns for a table using column-level replication
DBA_REPOBJECT - Information about replicated objects
DBA_REPPARAMETER_COLUMN - All columns used for resolving conflicts in the database
DBA_REPPRIORITY - Values and their corresponding priorities in all priority groups in the database
DBA_REPPRIORITY_GROUP - Information about all priority groups in the database
DBA_REPPROP - Propagation information about replicated objects
DBA_REPRESOLUTION - Description of all conflict resolutions in the database
DBA_REPRESOLUTION_METHOD - All conflict resolution methods in the database
DBA_REPRESOLUTION_STATISTICS - Statistics for conflict resolutions for all replicated tables in the database
DBA_REPRESOL_STATS_CONTROL - Information about statistics collection for conflict resolutions for all replicated tables in the database
DBA_REPSCHEMA - N-way replication information
DBA_REPSITES - N-way replication information
DBA_REPSITES_NEW - Information about new masters for replication extension
DBA_RESOURCE_INCARNATIONS - Resource incarnations that are running or eligible for HA status notification
DBA_RESUMABLE - Resumable session information in the system
DBA_REWRITE_EQUIVALENCES - Description of rewrite equivalence accessible to DBA
DBA_RGROUP - All refresh groups. This view is not a join.
DBA_ROLES - All Roles which exist in the database
DBA_ROLE_PRIVS - Roles granted to users and roles
DBA_ROLLBACK_SEGS - Description of rollback segments
DBA_RSRC_CONSUMER_GROUPS - all the resource consumer groups
DBA_RSRC_CONSUMER_GROUP_PRIVS - Switch privileges for consumer groups
DBA_RSRC_GROUP_MAPPINGS - all the consumer group mappings
DBA_RSRC_MANAGER_SYSTEM_PRIVS - system privileges for the resource manager
DBA_RSRC_MAPPING_PRIORITY - the consumer group mapping attribute priorities
DBA_RSRC_PLANS - All the resource plans
DBA_RSRC_PLAN_DIRECTIVES - all the resource plan directives
DBA_RULES - Rules in the databse
DBA_RULESETS - Rulesets in the database: maintained for backward compatibility
DBA_RULE_SETS - Rule sets in the database
DBA_RULE_SET_RULES - Rules in all rule sets in the database
DBA_SCHEDULER_CHAINS - All scheduler chains in the database
DBA_SCHEDULER_CHAIN_RULES - All rules from scheduler chains in the database
DBA_SCHEDULER_CHAIN_STEPS - All steps of scheduler chains in the database
DBA_SCHEDULER_GLOBAL_ATTRIBUTE - All scheduler global attributes
DBA_SCHEDULER_JOBS - All scheduler jobs in the database
DBA_SCHEDULER_JOB_ARGS - All arguments with set values of all scheduler jobs in the database
DBA_SCHEDULER_JOB_CLASSES - All scheduler classes in the database
DBA_SCHEDULER_JOB_LOG - Logged information for all scheduler jobs
DBA_SCHEDULER_JOB_RUN_DETAILS - The details of a job run
DBA_SCHEDULER_PROGRAMS - All scheduler programs in the database
DBA_SCHEDULER_PROGRAM_ARGS - All arguments of all scheduler programs in the database
DBA_SCHEDULER_RUNNING_CHAINS - All steps of all running chains in the database
DBA_SCHEDULER_SCHEDULES - All schedules in the database
DBA_SCHEDULER_WINDOWS - All scheduler windows in the database
DBA_SCHEDULER_WINDOW_DETAILS - The details of a window
DBA_SCHEDULER_WINDOW_GROUPS - All scheduler window groups in the database
DBA_SCHEDULER_WINDOW_LOG - Logged information for all scheduler windows
DBA_SCHEDULER_WINGROUP_MEMBERS - Members of all scheduler window groups in the database
DBA_SECONDARY_OBJECTS - All secondary objects for domain indexes
DBA_SEC_RELEVANT_COLS - Security Relevant columns of all VPD policies in the database
DBA_SEGMENTS - Storage allocated for all database segments
DBA_SEGMENTS_OLD - Storage allocated for all database segments
DBA_SEQUENCES - Description of all SEQUENCEs in the database
DBA_SERVER_REGISTRY -
DBA_SNAPSHOTS - All snapshots in the database
DBA_SNAPSHOT_LOGS - All snapshot logs in the database
DBA_SNAPSHOT_LOG_FILTER_COLS - Synonym for DBA_MVIEW_LOG_FILTER_COLS
DBA_SNAPSHOT_REFRESH_TIMES - Synonym for DBA_MVIEW_REFRESH_TIMES
DBA_SOURCE - Source of all stored objects in the database
DBA_SOURCE_TABLES - Source tables available for Change Data Capture
DBA_SQLJ_TYPES - Description of all types in the database
DBA_SQLJ_TYPE_ATTRS - Description of attributes of all types in the database
DBA_SQLJ_TYPE_METHODS - Description of methods of all types in the database
DBA_SQLSET -
DBA_SQLSET_BINDS -
DBA_SQLSET_DEFINITIONS - Synonym for DBA_SQLSET
DBA_SQLSET_PLANS -
DBA_SQLSET_REFERENCES -
DBA_SQLSET_STATEMENTS -
DBA_SQLTUNE_BINDS -
DBA_SQLTUNE_PLANS -
DBA_SQLTUNE_RATIONALE_PLAN -
DBA_SQLTUNE_STATISTICS -
DBA_STMT_AUDIT_OPTS - Describes current system auditing options across the system and by user
DBA_STORED_SETTINGS - Parameter settings for all objects
DBA_STREAMS_ADD_COLUMN - Add column transformations
DBA_STREAMS_ADMINISTRATOR - Users granted the privileges to be a streams administrator
DBA_STREAMS_DELETE_COLUMN - Delete column transformations
DBA_STREAMS_GLOBAL_RULES - Global rules created by streams administrative APIs
DBA_STREAMS_MESSAGE_CONSUMERS - Streams messaging consumers
DBA_STREAMS_MESSAGE_RULES - Rules for Streams messaging
DBA_STREAMS_NEWLY_SUPPORTED - List of tables that are newly supported by Streams
DBA_STREAMS_RENAME_COLUMN - Rename column transformations
DBA_STREAMS_RENAME_SCHEMA - Rename schema transformations
DBA_STREAMS_RENAME_TABLE - Rename table transformations
DBA_STREAMS_RULES - Rules used by Streams processes
DBA_STREAMS_SCHEMA_RULES - Schema rules created by streams administrative APIs
DBA_STREAMS_TABLE_RULES - Table rules created by streams administrative APIs
DBA_STREAMS_TRANSFORMATIONS - Transformations defined on rules
DBA_STREAMS_TRANSFORM_FUNCTION - Rules-based transform functions used by Streams
DBA_STREAMS_UNSUPPORTED - List of all the tables that are not supported by Streams in this release
DBA_SUBPARTITION_TEMPLATES -
DBA_SUBPART_COL_STATISTICS -
DBA_SUBPART_HISTOGRAMS -
DBA_SUBPART_KEY_COLUMNS -
DBA_SUBSCRIBED_COLUMNS - Change Data Capture subscribed columns
DBA_SUBSCRIBED_TABLES - Change Data Capture subscribed tables
DBA_SUBSCRIPTIONS - Change Data Capture subscriptions
DBA_SUMMARIES - Description of the summaries accessible to dba
DBA_SYNONYMS - All synonyms in the database
DBA_SYS_PRIVS - System privileges granted to users and roles
DBA_TABLES - Description of all relational tables in the database
DBA_TABLESPACES - Description of all tablespaces
DBA_TABLESPACE_GROUPS - Description of all tablespace groups
DBA_TABLESPACE_USAGE_METRICS - Description of all tablespace space usage metrics
DBA_TAB_COLS - Columns of user's tables, views and clusters
DBA_TAB_COLUMNS - Columns of user's tables, views and clusters
DBA_TAB_COL_STATISTICS - Columns of user's tables, views and clusters
DBA_TAB_COMMENTS - Comments on all tables and views in the database
DBA_TAB_HISTOGRAMS - Histograms on columns of all tables
DBA_TAB_MODIFICATIONS - Information regarding modifications to tables
DBA_TAB_PARTITIONS -
DBA_TAB_PRIVS - All grants on objects in the database
DBA_TAB_STATISTICS - Optimizer statistics for all tables in the database
DBA_TAB_STATS_HISTORY - History of table statistics modifications
DBA_TAB_SUBPARTITIONS -
DBA_TEMPLATE_REFGROUPS - Table for maintaining refresh group information for template.
DBA_TEMPLATE_TARGETS - Internal table for tracking potential target databases for templates.
DBA_TEMP_FILES - Information about database temp files
DBA_THRESHOLDS - Desription of all thresholds
DBA_TRANSFORMATIONS -
DBA_TRIGGERS - All triggers in the database
DBA_TRIGGER_COLS - Column usage in all triggers
DBA_TSM_DESTINATION - Transparent session migration source session statistics
DBA_TSM_HISTORY - Transparent session migration statistics
DBA_TSM_SOURCE - Transparent session migration source session statistics
DBA_TS_QUOTAS - Tablespace quotas for all users
DBA_TUNE_MVIEW - Catalog View to show the result after executing TUNE_MVIEW() API
DBA_TYPES - Description of all types in the database
DBA_TYPE_ATTRS - Description of attributes of all types in the database
DBA_TYPE_METHODS - Description of methods of all types in the database
DBA_TYPE_VERSIONS - Description of each type version in the database
DBA_UNDO_EXTENTS - Extents comprising all segments in the system managed undo tablespaces
DBA_UNUSED_COL_TABS - All tables with unused columns in the database
DBA_UPDATABLE_COLUMNS - Description of dba updatable columns
DBA_USERS - Information about all users of the database
DBA_USTATS - All statistics collected on either tables or indexes
DBA_VARRAYS - Description of varrays in tables accessible to the user
DBA_VIEWS - Description of all views in the database
DBA_WAITERS -
DBA_WARNING_SETTINGS - warning settings for all objects
DBA_WORKSPACES -
DBA_WORKSPACE_SESSIONS -
DBA_XML_INDEXES - Description of all XML indexes in the database
DBA_XML_SCHEMAS - Description of all the XML Schemas registered
DBA_XML_TABLES - Description of all XML tables in the database
DBA_XML_TAB_COLS - Description of all XML tables in the database
DBA_XML_VIEWS - Description of all XML views in the database
DBA_XML_VIEW_COLS - Description of all XML views in the database

515 rows selected.

SQL> SPOOL OFF;

Latest Posts