{"url":"https://htn20190109.hatenablog.com/entry/2019/06/29/013007","height":"190","type":"rich","categories":["DB"],"provider_url":"https://hatena.blog","title":"\u30c7\u30d5\u30a9\u30eb\u30c8\u5024\u3042\u308a\u30ab\u30e9\u30e0\u8ffd\u52a0\u6642\u306e\u6700\u9069\u5316","blog_title":"HTN20190109\u306e\u65e5\u8a18","description":"Oracle set timing on drop table tab1;create table tab1(col1 int); declarebegin for i in 1..1000000 loop insert into tab1 values(i); commit; end loop;end;/ select sum(bytes) from user_segments where segment_name = 'TAB1'; alter table tab1 add (col2 char(100) default '123123' not null); select * from \u2026","version":"1.0","author_name":"HTN20190109","published":"2019-06-29 01:30:07","provider_name":"Hatena Blog","image_url":null,"blog_url":"https://htn20190109.hatenablog.com/","width":"100%","author_url":"https://blog.hatena.ne.jp/HTN20190109/","html":""}