Skip to content

[20140505]delete histogram.txt

昨天看了https://jonathanlewis.wordpress.com/2014/05/01/delete-histogram/
介绍删除直方图的方法,这样比较快捷.

SCOTT@test> @ver
BANNER
——————————————————————————–
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

SCOTT@test> create table t as select rownum id1 , mod(rownum,100)+1 id2, ‘test’ name from dual connect by level execute dbms_stats.gather_table_stats(user,’t’,cascade=>true,method_opt=>’for all columns size 1,for columns id1 size 254 ,for columns id2 size 254′);
PL/SQL procedure successfully completed.

SCOTT@test> SCOTT@test> select column_name,num_distinct,histogram from dba_tab_columns where owner=user and table_name=’T’;
COLUMN_NAME NUM_DISTINCT HISTOGRAM
——————– ———— —————
ID1 10000 HEIGHT BALANCED
ID2 100 FREQUENCY
NAME 1 NONE

SCOTT@test> execute dbms_stats.set_column_stats(ownname=>user,tabname=>’T’,colname=> ‘id1′,distcnt=>NULL);
PL/SQL procedure successfully completed.

SCOTT@test> select column_name,num_distinct,histogram from dba_tab_columns where owner=user and table_name=’T’;
COLUMN_NAME NUM_DISTINCT HISTOGRAM
——————– ———— —————
ID1 10000 NONE
ID2 100 FREQUENCY
NAME 1 NONE

SCOTT@test> select * from dba_tab_histograms where owner=user and table_name=’T’ and column_name=’ID1′;
OWNER TABLE_NAME COLUMN_NAME ENDPOINT_NUMBER ENDPOINT_VALUE ENDPOINT_A
—— ———- ——————– ————— ————– ———-
SCOTT T ID1 0 1
SCOTT T ID1 1 10000

[20140207]putty也有linux版本.txt

[20140207]putty也有linux版本.txt

今天无意中发现putty也有linux版本。下载地址如下:

http://pkgs.repoforge.org/putty/

下载对应的版本就可以使用了。

Hello world!

Welcome to WordPress.com. After you read this, you should delete and write your own post, with a new title above. Or hit Add New on the left (of the admin dashboard) to start a fresh post.

Here are some suggestions for your first post.

  1. You can find new ideas for what to blog about by reading the Daily Post.
  2. Add PressThis to your browser. It creates a new blog post for you about any interesting  page you read on the web.
  3. Make some changes to this page, and then hit preview on the right. You can always preview any post or edit it before you share it to the world.
关注

每发布一篇新博文的同时向您的邮箱发送备份。