dbms_stats.import_system_stats : dbms_stats « System Packages « Oracle PL / SQL

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

dbms_stats.import_system_stats

    


SQL> alter system flush shared_pool;
SQL>
SQL> alter session set optimizer_index_cost_adj=100;
SQL>
SQL> alter session set optimizer_index_caching=0;
SQL>
SQL> begin
  2     dbms_stats.import_system_stats( stattab => 'SYSTEM_STATS', statid => 'OLTP', statown => user );
  3  end;
  4  /

   
    
    
    
  

Related examples in the same category