execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job'); : DBMS_STATS « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. DBMS_STATS
SQL>
SQL>
SQL> create table employee_job (
  2  id                             number                         not null,
  3  worker_id                      number                         not null,
  4  logical_workplace_id           number                         not null,
  5  active_date                    date          default SYSDATE  not null,
  6  inactive_date                  date )
  7  tablespace USERS pctfree 20
  8  storage (initial 10K next 10K pctincrease 0);

Table created.

SQL>
SQL> execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job');

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL> drop table employee_job;

Table dropped.








31.27.DBMS_STATS
31.27.1.execute SYS.DBMS_STATS.gather_table_stats(USER, 'employee_job');
31.27.2.Check table status with SYS.DBMS_STATS.gather_table_stats after adding index
31.27.3.Create a procedure to collect statistics on all my objects
31.27.4.dbms_stats.drop_stat_table, dbms_stats.create_stat_table,dbms_stats.delete_system_stats
31.27.5.dbms_stats.gather_schema_stats
31.27.6.dbms_stats.gather_table_stats
31.27.7.dbms_stats.import_system_stats
31.27.8.dbms_stats.objectTab
31.27.9.dbms_stats.set_table_stats( user, 'EMP', numrows => 100000 )
31.27.10.dbms_stats.set_table_stats( user, 'myTable1', numrows => 10000000, numblks => 1000000 )