Карта сайта Интеллектуальная поисковая системаДобавить свою ссылку по ключевому запросуПоисковая система v3.kz поможет ускорить индексацию вашего сайта выводит в Топ |
|
For example, if the DELETE_COLUMN_STATS procedure is invoked on a column for which an association is defined, user-defined In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA. EXEC DBMS_STATS.create_stat_table... exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname, estimate_percent, block_sample, method_opt, degree, granularity, cascade, stattab, statid, options, statown Use the constant DBMS_STATS.AUTO_SAMPLE_SIZE in the ESTIMATE_PERCENT parameter. Example to take database stats Step 2: Gather the statistics with gather_system_stats. In this dbms_stats example, we compute histograms on all indexed columns Select from DBA_OPTSTAT_OPERATIONS to see the history of statistics operations performed. Oracle: DBMS_STATS Gather Statistics of Schema, Tables, Indexes. DBMS_STATS in action (Examples). Automated table monitoring and stale statistics gathering example. Code examples: EXEC DBMS_STATS.gather_schema_stats(SCOTT,DBMS_STATS.AUTO_SAMPLE_SIZE); EXEC... In the following examples the statistics for the APPSCHEMA user are collected into a new table, STATS_TABLE, which is owned by DBASCHEMA: SQL> EXEC DBMS_STATS.create_stat_table... Информация взята v3.kz |
загрузка...
|