cory_hate https://blog.hatena.ne.jp/cory_hate/ cory_hate’s diary https://cory-ora.hateblo.jp/ Oracle SET SERVEROUTPUT ON SIZE 50000 feedback off pagesize 0 trims on lines 1000 timing on time on col analyze_index new_value analyze_index format a100 select 'analyze_index' || to_char(sysdate,'_YYYYMMDDHH24MISS') || '.csv' analyze_index from dual; spool &analyze_index declare tname varchar2(100); act_s… 190 <iframe src="https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcory-ora.hateblo.jp%2Fentry%2F2015%2F01%2F22%2F163659" title="ANALYZE INDEX　Oracleデータベース 断片化 リビルドインデックス　メンテナンス - cory_hate’s diary" class="embed-card embed-blogcard" scrolling="no" frameborder="0" style="display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;"></iframe> http://ecx.images-amazon.com/images/I/51F1GVE1TQL.jpg Hatena Blog https://hatena.blog 2015-01-22 16:36:59 rich https://cory-ora.hateblo.jp/entry/2015/01/22/163659 1.0 100%