7 lines
416 B
SQL
7 lines
416 B
SQL
select to_char(sysdate,'dd-mm-yyyy hh24:mi') from dual;
|
|
set timing on
|
|
execute DBMS_STATS.GATHER_SCHEMA_STATS(OWNNAME => 'DBCGO',estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, CASCADE => TRUE, DEGREE => 4);
|
|
execute DBMS_STATS.GATHER_TABLE_STATS(OWNNAME => 'DBCGO', TABNAME =>'DBCGO_PP_MV00', METHOD_OPT => 'FOR COLUMNS pp_num SIZE 100', DEGREE => 4);
|
|
select to_char(sysdate,'dd-mm-yyyy hh24:mi') from dual;
|
|
exit;
|