DB Wiki

User Tools

Site Tools

Trace:
statistics

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
statistics [2016/05/06 15:49] – z0hpvkstatistics [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 22: Line 22:
 END; END;
 /</code> /</code>
 +
 +===== Export =====
 +<code>BEGIN
 +dbms_stats.create_stat_table(ownname => 'SCANPRD1', stattab => 'STATISTICS_TABLE');
 +END;
 +/</code>
 +
 +<code>BEGIN
 +dbms_stats.export_table_stats(ownname => 'SCANPRD1', stattab => 'STATISTICS_TABLE', tabname => 'DM_SYSOBJECT_S', statid => 'CURRENT_STATS');
 +dbms_stats.export_table_stats(ownname => 'SCANPRD1', stattab => 'STATISTICS_TABLE', tabname => 'DM_SYSOBJECT_R', statid => 'CURRENT_STATS');
 +END;
 +/</code>
 +
  
  
  
statistics.1462549794.txt.gz · Last modified: 2025/03/08 22:23 (external edit)