収集 $ cat pre_analyze.sql set pagesize 0 set echo off set heading off set feedback off set verify off set timing off spool analyze.sql select 'spool analyze.log' from dual; select 'analyze table '||table_name||' estimate statistics;' from user_tables; select 'analyze index '||index_name||' estimate statistics;' from user_indexes; select 'spool off' from dual; select 'exit' from dual; spool off exit