AnySQL.net

    随着DBA技术水平的整体提高, 对于AUL/MyDUL这一类软件的使用需求越来越少了, 我于9号在网上发布了一个CGI, 通过网上可以在线早请许可证了. 下面是这一周多一点的时间以来free帐号(密码:200610)的使用情况, 用了5次, 不算多.

DAY=20061013 IP=58.212.85.189 CODE=5IFW-1D8F-UB4U-MT6J-K89C
DAY=20061013 IP=66.211.156.98 CODE=OC0Y-USYX-PP5C-YAGD-O6AN
DAY=20061014 IP=200.6.100.10 CODE=AU3I-KV2S-KQKM-30VS-TV46
DAY=20061014 IP=69.140.195.22 CODE=F901-OX9H-RTAN-NMTT-RDON
DAY=20061014 IP=69.140.195.22 CODE=GLHF-22F5-TR7F-0KL1-NQS5
DAY=20061014 IP=65.113.143.60 CODE=9WBJ-9Q1A-74W1-UK7C-PO88
DAY=20061014 IP=65.113.143.60 CODE=UJ42-URTU-ZEPK-16NZ-2M7L

    在CGI发布之前, 我给过别人两次的正式许可证, 这样总共是七次了. 不过不知道真正地解决问题的有几次, 没有人问我如何使用AUL/MyDUL, 也没有人给我反馈信息. free帐号现在还有5次的免费机会, 不知道会不会被用完.

    我对于TCP/IP协议一无所知, 不过有些选项对于rsync传文件的速度会有一定的影响, 设置合适的值可以优化性能, 下面的几行是我从rsync的源代码中grep出来的, 以供参考.

struct
{
  char *name;
  int level;
  int option;
  int value;
  int opttype;
}
socket_options[] = {
  {"SO_KEEPALIVE",  SOL_SOCKET,  SO_KEEPALIVE, 0, OPT_BOOL},
  {"SO_REUSEADDR",  SOL_SOCKET,  SO_REUSEADDR, 0, OPT_BOOL},
  {"SO_BROADCAST",  SOL_SOCKET,  SO_BROADCAST, 0, OPT_BOOL},
  {"TCP_NODELAY",   IPPROTO_TCP, TCP_NODELAY,  0, OPT_BOOL},
  {"SO_SNDBUF",     SOL_SOCKET,  SO_SNDBUF,    0, OPT_INT},
  {"SO_RCVBUF",     SOL_SOCKET,  SO_RCVBUF,    0, OPT_INT},
  {"SO_SNDLOWAT",   SOL_SOCKET,  SO_SNDLOWAT,  0, OPT_INT},
  {"SO_RCVLOWAT",   SOL_SOCKET,  SO_RCVLOWAT,  0, OPT_INT},
  {"SO_SNDTIMEO",   SOL_SOCKET,  SO_SNDTIMEO,  0, OPT_INT},
  {"SO_RCVTIMEO",   SOL_SOCKET,  SO_RCVTIMEO,  0, OPT_INT},
  {NULL,0,0,0,0}};

    但愿对大家有用.

    对在线销售的AUL许可证的计数方法作了一点改变, 在新的方法中不将IP地址列入考虑, 当不同日期的访问仍计数, 在同一天内五次访问将会计数一次. 但要注意, 不要对页面进行刷新, 重复的访问也会计算次数的.

    下面是到今天为止, 10月份免费的请求情况, 同时我们也来计数一下:

USER     NAME = free

// count = 1
DAY=20061013 IP=58.212.85.189 CODE=5IFW-1D8F-UB4U-MT6J-K89C
DAY=20061013 IP=66.211.156.98 CODE=OC0Y-USYX-PP5C-YAGD-O6AN

//count = 2
DAY=20061014 IP=200.6.100.10 CODE=AU3I-KV2S-KQKM-30VS-TV46
DAY=20061014 IP=65.113.143.60 CODE=9WBJ-9Q1A-74W1-UK7C-PO88
DAY=20061014 IP=65.113.143.60 CODE=UJ42-URTU-ZEPK-16NZ-2M7L
DAY=20061014 IP=69.140.195.22 CODE=F901-OX9H-RTAN-NMTT-RDON
DAY=20061014 IP=69.140.195.22 CODE=GLHF-22F5-TR7F-0KL1-NQS5

//count = 3
DAY=20061016 IP=124.168.94.122 CODE=8KPD-95HT-7GMJ-JPGI-OFUZ
DAY=20061016 IP=222.69.61.134 CODE=SIWU-P6P8-Y4JC-MOV5-KD52

//count = 4
DAY=20061017 IP=211.96.15.27 CODE=BOG3-FT04-3XMF-FTU6-4YSE
DAY=20061017 IP=212.68.138.137 CODE=SB9J-1XZT-KHNI-RO0T-IR6L
DAY=20061017 IP=58.20.108.23 CODE=FMDO-DU90-49H6-V1W9-DRUI
DAY=20061017 IP=61.178.48.199 CODE=EBIE-WHZT-5WCF-AB44-QDW0
DAY=20061017 IP=61.178.48.199 CODE=ZVKS-AQKH-PV6Y-BTK6-KAUE

//count = 5
DAY=20061017 IP=69.71.188.90 CODE=PTPP-MHWE-AN20-LSUY-0R2K

//count = 6
DAY=20061018 IP=218.244.187.201 CODE=XCX1-TAFL-2CIP-02LX-HCOK
DAY=20061018 IP=222.91.162.118 CODE=IZJP-DCO2-GWF7-X9DT-14D1
DAY=20061018 IP=222.91.162.118 CODE=YZ4G-TV7D-MRKC-F42B-WFVX
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R

//count = 7
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=60.63.172.202 CODE=EIEF-F8SL-WY7K-PXIO-LT47

USED = 7, TOTAL=20

    现在的价格(8000元一次)真是很优惠的, 你要请人来恢复或临时联系我的话, 价格至少在1.5倍以上.

    下半个月的申请次数还是比较多的, 但我想真正使用它来恢复的次数是少的, 因为有些是从同一个IP来的; 并且很多人可能还不清楚许可证的使用方法, 因此有很多申请其实是没有实际作用的.

    来看一下吧...

DAY=20061017 IP=211.96.15.27 CODE=BOG3-FT04-3XMF-FTU6-4YSE
DAY=20061017 IP=212.68.138.137 CODE=SB9J-1XZT-KHNI-RO0T-IR6L
DAY=20061017 IP=58.20.108.23 CODE=FMDO-DU90-49H6-V1W9-DRUI
DAY=20061017 IP=61.178.48.199 CODE=EBIE-WHZT-5WCF-AB44-QDW0
DAY=20061017 IP=61.178.48.199 CODE=ZVKS-AQKH-PV6Y-BTK6-KAUE
DAY=20061017 IP=69.71.188.90 CODE=PTPP-MHWE-AN20-LSUY-0R2K
DAY=20061018 IP=218.244.187.201 CODE=XCX1-TAFL-2CIP-02LX-HCOK
DAY=20061018 IP=222.91.162.118 CODE=IZJP-DCO2-GWF7-X9DT-14D1
DAY=20061018 IP=222.91.162.118 CODE=YZ4G-TV7D-MRKC-F42B-WFVX
DAY=20061018 IP=222.91.162.118 CODE=ZM6K-26WC-G99N-LVNI-3L2R
DAY=20061018 IP=60.63.172.202 CODE=EIEF-F8SL-WY7K-PXIO-LT47
DAY=20061019 IP=60.63.172.202 CODE=T6RN-T50U-U3MM-PB3B-U563
DAY=20061019 IP=159.33.10.92 CODE=LUN2-LX25-LA4Z-L94R-0662
DAY=20061019 IP=221.230.7.210 CODE=RF92-NV6B-9WLC-8WCX-BZT8
DAY=20061022 IP=58.34.110.243 CODE=FLGM-J7RC-LVM6-TX2C-VWP0
DAY=20061026 IP=218.56.106.195 CODE=dm53-51b4-6aja-mrtt-ywhr
DAY=20061026 IP=192.128.134.68 CODE=H5PS-57KH-L9SS-DRFH-IKKY
DAY=20061026 IP=192.128.133.68 CODE=W5LJ-DRQP-MR1Z-RNLL-NTL8
DAY=20061026 IP=192.128.133.68 CODE=J6FD-3X6Z-HMW3-GE0Z-YC8U
DAY=20061026 IP=192.128.133.68 CODE=W0Y2-CD87-I0BZ-93MF-DT4Q
DAY=20061026 IP=192.128.133.68 CODE=5KZV-8RG5-VS33-KUZX-RQEJ
DAY=20061026 IP=192.128.133.68 CODE=D4AI-6NFY-797E-E5GW-CONS
DAY=20061026 IP=192.128.133.68 CODE=LZXM-8A82-GCQL-SL8B-I4IK
DAY=20061026 IP=192.128.133.68 CODE=Z07H-I2RD-VBXZ-8XUY-8SSQ
DAY=20061026 IP=192.128.133.68 CODE=B0YW-AXE5-YMF7-QGCS-E87G
DAY=20061026 IP=192.128.133.68 CODE=5BAO-KDWS-P0SQ-MOOM-1UHP
DAY=20061026 IP=192.128.133.68 CODE=OJYQ-HJCN-XMLR-3VDM-L0BJ
DAY=20061026 IP=192.128.133.68 CODE=2UB3-UYNE-5CCK-O2FZ-RTF0
DAY=20061026 IP=221.12.26.37 CODE=4S0E-5SSR-Q1SM-68HF-Z5MH
DAY=20061030 IP=59.176.39.227 CODE=JJDM-IOH5-3VE2-3YG2-JIZA
DAY=20061031 IP=212.72.22.98 CODE=YRVW-SAH5-PA67-B580-2Y1W
DAY=20061031 IP=212.72.22.98 CODE=YTYZ-TAOL-W19D-88HT-AVRO
DAY=20061031 IP=212.72.22.98 CODE=AMP7-TZBT-GEDQ-VA81-EY2X
DAY=20061031 IP=192.128.166.68 CODE=E0LT-3E1U-1DEG-2BRS-WX6E
DAY=20061031 IP=192.128.166.68 CODE=95BB-R2OO-RGPW-VTC5-FVPK
DAY=20061031 IP=62.231.233.121 CODE=FQ80-JKSI-DGH2-HZ5L-WXMW
DAY=20061031 IP=220.192.100.63 CODE=FQ80-JKSI-DGH2-HZ5L-WXMW
DAY=20061031 IP=218.56.32.12 CODE=5IFW-1D8F-UB4U-MT6J-K89C

    要下次免费的机会, 等到明年吧!

    Oracle已经要发布10.2.0.3的Patch了, 在Metalink上已经可以找到Bug修复列表了. 这个列表很长, 我初略地看了一下, 抄出以下面的一些我认为需要关注一下的, 从这份列表来看, 10.2.0.2是很不成熟的, Oracle会建议立马打补丁到最新的版本.

3279497	Interupted (Ctrl-C) TRUNCATE can corrupt ASSM table
4188324	Wasted space possible in ASSM segments
4323868	INDEX hints can lead to INDEX SCAN FULL
4378206	Direct load of compressed table can load duplicate rows
5212539	LOB corruption for NOCACHE LOBs (ORA-1555/ORA-22924)
5017007	MVIEW LOB content incorrect after refresh
5458753	SQL may execute in wrong schema. This bug is alerted in Note 392673.1
4963106	SQLLDR SKIP skips wrong number of records
4748597	Moving a LOB in a partitioned table fails to update IND$
4732503	Self-deadlock on TT enqueue
4699610	CKPT can self deadlock waiting for MTTR state object which it holds
5016142	SMON rollback of large transactions blocks other actions
5068048	SQL*loader hang on direct path load on multi CPU machine
4859002	PMON crash cleaning up serially_reusable PLSQL
4726645	MMON has a slow memory leak ("koh-kghu sessi")
5004782	Memory leak on repeated connect/disconnect
4968994	Poor plan using SYSDATE in predicate over dblink
4461334	Index subpartitions do not inherit index level logging attribute
5448588	Slow LGWR sync performance for large redo write sizes
4590425	RMAN exit status is 0 when validate errors
4994956	Number of configured shared pool subpools not correct
4361163	It is not possible to have > 1000 shared servers on some platforms
4908162	Suboptimal plan possible for partitioned table with many joins
5014836	INSERT as SELECT plan can differ from SELECT plan

    我没有看RAC, OLAP等这些不常用的组件的Bug, 只关注了很核心的部分.