dbms_stats.drop_stat_table, dbms_stats.create_stat_table,dbms_stats.delete_system_stats : dbms_stats « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. dbms_stats

dbms_stats.drop_stat_table, dbms_stats.create_stat_table,dbms_stats.delete_system_stats

    

SQL> exec dbms_stats.drop_stat_table( user, 'SYSTEM_STATS' );
SQL> exec dbms_stats.create_stat_table( user, 'SYSTEM_STATS' );
SQL> exec dbms_stats.delete_system_stats;
SQL>
SQL>
SQL>








Related examples in the same category

1.dbms_stats.gather_schema_stats
2.dbms_stats.gather_table_stats
3.DBMS_STATS.GET_SYSTEM_STATS
4.dbms_stats.import_system_stats
5.dbms_stats.objectTab
6.dbms_stats.set_table_stats( user, 'EMP', numrows => 100000 )
7.dbms_stats.set_table_stats( user, 'myTable1', numrows => 10000000, numblks => 1000000 )
8.Delete all table and index statistics in your schema:
9.multiblock readtime in ms
10.Run DBMS_STATS.GATHER_SCHEMA_STATS to collect stats for all of your tables and indexes.
11.Extract system stats from your user table or data dictionary (sys.aux_Stats$).