必须记住的数据库字典视图dict

日常工作中经常会查看一些数据字典视图，但是也经常会记不住，只能记住个前缀，那么dict你必须的记住了，它可以帮助你找到你想要的视图。必须要记住dict~~

SQL> desc dict; Name                      Null?    Type ----------------------------------------- -------- ---------------------------- TABLE_NAME                     VARCHAR2(128) COMMENTS                       VARCHAR2(4000)SQL> desc dict; Name                      Null?    Type ----------------------------------------- -------- ---------------------------- TABLE_NAME                     VARCHAR2(128) COMMENTS                       VARCHAR2(4000)SQL> col table_name for a50SQL> col comments for a50SQL> set lines 120SQL> select table_name from dict where table_name like 'DBA_HIST%';TABLE_NAME--------------------------------------------------DBA_HIST_ACTIVE_SESS_HISTORYDBA_HIST_APPLY_SUMMARYDBA_HIST_ASH_SNAPSHOTDBA_HIST_ASM_BAD_DISKDBA_HIST_ASM_DISKGROUPDBA_HIST_ASM_DISKGROUP_STATDBA_HIST_BASELINEDBA_HIST_BASELINE_DETAILSDBA_HIST_BASELINE_METADATADBA_HIST_BASELINE_TEMPLATEDBA_HIST_BG_EVENT_SUMMARYTABLE_NAME--------------------------------------------------DBA_HIST_BUFFERED_QUEUESDBA_HIST_BUFFERED_SUBSCRIBERSDBA_HIST_BUFFER_POOL_STATDBA_HIST_CAPTUREDBA_HIST_CELL_CONFIGDBA_HIST_CELL_CONFIG_DETAILDBA_HIST_CELL_DBDBA_HIST_CELL_DISKTYPEDBA_HIST_CELL_DISK_NAMEDBA_HIST_CELL_DISK_SUMMARYDBA_HIST_CELL_GLOBALTABLE_NAME--------------------------------------------------DBA_HIST_CELL_GLOBAL_SUMMARYDBA_HIST_CELL_IOREASONDBA_HIST_CELL_IOREASON_NAMEDBA_HIST_CELL_METRIC_DESCDBA_HIST_CELL_NAMEDBA_HIST_CELL_OPEN_ALERTSDBA_HIST_CHANNEL_WAITSDBA_HIST_CLUSTER_INTERCONDBA_HIST_COLORED_SQLDBA_HIST_COMP_IOSTATDBA_HIST_CON_SYSMETRIC_HISTTABLE_NAME--------------------------------------------------DBA_HIST_CON_SYSMETRIC_SUMMDBA_HIST_CON_SYSSTATDBA_HIST_CON_SYSTEM_EVENTDBA_HIST_CON_SYS_TIME_MODELDBA_HIST_CR_BLOCK_SERVERDBA_HIST_CURRENT_BLOCK_SERVERDBA_HIST_DATABASE_INSTANCEDBA_HIST_DATAFILEDBA_HIST_DB_CACHE_ADVICEDBA_HIST_DISPATCHERDBA_HIST_DLM_MISCTABLE_NAME--------------------------------------------------DBA_HIST_DYN_REMASTER_STATSDBA_HIST_ENQUEUE_STATDBA_HIST_EVENT_HISTOGRAMDBA_HIST_EVENT_NAMEDBA_HIST_FILEMETRIC_HISTORYDBA_HIST_FILESTATXSDBA_HIST_IC_CLIENT_STATSDBA_HIST_IC_DEVICE_STATSDBA_HIST_IM_SEG_STATDBA_HIST_IM_SEG_STAT_OBJDBA_HIST_INSTANCE_RECOVERYTABLE_NAME--------------------------------------------------DBA_HIST_INST_CACHE_TRANSFERDBA_HIST_INTERCONNECT_PINGSDBA_HIST_IOSTAT_DETAILDBA_HIST_IOSTAT_FILETYPEDBA_HIST_IOSTAT_FILETYPE_NAMEDBA_HIST_IOSTAT_FUNCTIONDBA_HIST_IOSTAT_FUNCTION_NAMEDBA_HIST_JAVA_POOL_ADVICEDBA_HIST_LATCHDBA_HIST_LATCH_CHILDRENDBA_HIST_LATCH_MISSES_SUMMARYTABLE_NAME--------------------------------------------------DBA_HIST_LATCH_NAMEDBA_HIST_LATCH_PARENTDBA_HIST_LIBRARYCACHEDBA_HIST_LMS_STATSDBA_HIST_LOGDBA_HIST_MEMORY_RESIZE_OPSDBA_HIST_MEMORY_TARGET_ADVICEDBA_HIST_MEM_DYNAMIC_COMPDBA_HIST_METRIC_NAMEDBA_HIST_MTTR_TARGET_ADVICEDBA_HIST_MUTEX_SLEEPTABLE_NAME--------------------------------------------------DBA_HIST_MVPARAMETERDBA_HIST_OPTIMIZER_ENVDBA_HIST_OSSTATDBA_HIST_OSSTAT_NAMEDBA_HIST_PARAMETERDBA_HIST_PARAMETER_NAMEDBA_HIST_PDB_INSTANCEDBA_HIST_PDB_IN_SNAPDBA_HIST_PERSISTENT_QMN_CACHEDBA_HIST_PERSISTENT_QUEUESDBA_HIST_PERSISTENT_SUBSTABLE_NAME--------------------------------------------------DBA_HIST_PGASTATDBA_HIST_PGA_TARGET_ADVICEDBA_HIST_PLAN_OPERATION_NAMEDBA_HIST_PLAN_OPTION_NAMEDBA_HIST_PROCESS_MEM_SUMMARYDBA_HIST_RECOVERY_PROGRESSDBA_HIST_REPLICATION_TBL_STATSDBA_HIST_REPLICATION_TXN_STATSDBA_HIST_REPORTSDBA_HIST_REPORTS_CONTROLDBA_HIST_REPORTS_DETAILSTABLE_NAME--------------------------------------------------DBA_HIST_REPORTS_TIMEBANDSDBA_HIST_RESOURCE_LIMITDBA_HIST_ROWCACHE_SUMMARYDBA_HIST_RSRC_CONSUMER_GROUPDBA_HIST_RSRC_METRICDBA_HIST_RSRC_PDB_METRICDBA_HIST_RSRC_PLANDBA_HIST_RULE_SETDBA_HIST_SEG_STATDBA_HIST_SEG_STAT_OBJDBA_HIST_SERVICE_NAMETABLE_NAME--------------------------------------------------DBA_HIST_SERVICE_STATDBA_HIST_SERVICE_WAIT_CLASSDBA_HIST_SESSMETRIC_HISTORYDBA_HIST_SESS_SGA_STATSDBA_HIST_SESS_TIME_STATSDBA_HIST_SGADBA_HIST_SGASTATDBA_HIST_SGA_TARGET_ADVICEDBA_HIST_SHARED_POOL_ADVICEDBA_HIST_SHARED_SERVER_SUMMARYDBA_HIST_SNAPSHOTTABLE_NAME--------------------------------------------------DBA_HIST_SNAP_ERRORDBA_HIST_SQLBINDDBA_HIST_SQLCOMMAND_NAMEDBA_HIST_SQLSTATDBA_HIST_SQLTEXTDBA_HIST_SQL_BIND_METADATADBA_HIST_SQL_PLANDBA_HIST_SQL_SUMMARYDBA_HIST_SQL_WORKAREA_HSTGRMDBA_HIST_STAT_NAMEDBA_HIST_STREAMS_APPLY_SUMTABLE_NAME--------------------------------------------------DBA_HIST_STREAMS_CAPTUREDBA_HIST_STREAMS_POOL_ADVICEDBA_HIST_SYSMETRIC_HISTORYDBA_HIST_SYSMETRIC_SUMMARYDBA_HIST_SYSSTATDBA_HIST_SYSTEM_EVENTDBA_HIST_SYS_TIME_MODELDBA_HIST_TABLESPACEDBA_HIST_TABLESPACE_STATDBA_HIST_TBSPC_SPACE_USAGEDBA_HIST_TEMPFILETABLE_NAME--------------------------------------------------DBA_HIST_TEMPSTATXSDBA_HIST_THREADDBA_HIST_TOPLEVELCALL_NAMEDBA_HIST_UNDOSTATDBA_HIST_WAITCLASSMET_HISTORYDBA_HIST_WAITSTATDBA_HIST_WR_CONTROLDBA_HIST_WR_SETTINGSDBA_HISTOGRAMS152 rows selected.SQL>