Shulou(Shulou.com)06/01 Report--

Daily work will often check some data dictionary view, but also often can not remember, can only remember a prefix, then dict you must remember, it can help you find the view you want. You have to remember 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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.