在一个数据库中发现了一个异常增大的对象，经检查改对象为BITMAP索引。在数据库中执行下面的脚本，发现了一个异常增大的对象：SQL> SELECT SEGMENT_NAME, SEGMENT_TYPE, SUM(BYTES)/1024/1024/1024 G 2 FROM USER_SEGMENTS 3 GROUP BY SEGMENT_NAME, SEGMENT_TYPE 4 HAVING SUM(BYTES)/1024/1024/1024 > 15;SEGMENT_NAME SEGMENT_TYPE G------------------------------ ------------------ ----------TU_ORD_ORDER_ZJ_K_CODE INDEX 16.7539215检查该对象的详细信息：SQL> SELECT INDEX_NAME, INDEX_TYPE FROM USER_INDEXES 2 WHERE INDEX_...

在一个数据库中发现了一个异常增大的对象，经检查改对象为BITMAP索引。在数据库中执行下面的脚本，发现了一个异常增大的对象：SQL> SELECT SEGMENT_NAME, SEGMENT_TYPE, SUM(BYTES)/1024/1024/1024 G 2 FROM USER_SEGMENTS 3 GROUP BY SEGMENT_NAME, SEGMENT_TYPE 4 HAVING SUM(BYTES)/1024/1024/1024 > 15;SEGMENT_NAME SEGMENT_TYPE G------------------------------ ------------------ ----------TU_ORD_ORDER_ZJ_K_CODE INDEX 16.7539215检查该对象的详细信息：SQL> SELECT INDEX_NAME, INDEX_TYPE FROM USER_INDEXES 2 WHERE INDEX_...

• 不要设置自动回复！自动回复一点意义也没有，徒增对方的负担。而且，我恨死自动回复了，某一段时间邮箱几乎要被自动回复塞爆，只要挨个回复请发件人关掉。
• 一定要写主题。如果不清楚你的邮件主要想说什么，还是干脆不要写邮件的好。不写主题会增加被判定为垃圾邮件的可能性。
• 署名。如果和收件人没有熟到一看email地址就知道是谁，还是署个名吧。另外，配置邮箱的时候，姓名一栏也应该填点有语义的内容。
• 不要用花里胡哨的信纸。信纸什么的非常影响阅读，换了不同的邮件阅读器会发现内文变得一团糟。童心未泯者无视好了。
• 没事干别胡乱转发无聊的邮件。这种邮件在转发后暴露了很多无辜者的邮件地址，很讨厌。这种行为很招垃圾邮件的。
• 用密件抄送转发。不要轻易泄露不相关人的邮件地址，想想看垃圾邮件都是怎么来的。

写在这里，备用。

明天起，开始休一个长假

很多人问我这个假有多长，赫赫，感谢我的老板，准了我三个礼拜的假。自从我上次离开老家，已经有快两年半了，第一年老婆有孕在身，没法回，第二年小猪太小，怕受不了长途的颠簸，只有趁这个空档，把年假一块休了。

可以享受一阵子田园生活了，我们那里比较落后，日出而作，日落而息，我参加工作之前我们家连电话都没有，到现在都没有网络，所以可能有一阵子不会更新blog了

Share This

San Francisco-based blogging startup Six Apart has made a significant acquisition, we heard today from someone with knowledge of the deal. “Significant” in the sense of a possible strategic shift for the company, if not in terms of deal size. It will be announced in the next few days.

Who did they acquire? Put your best guess in the comments. First comment that is correct gets a 2 GB iPod shuffle with “I Love TechCrunch” engraved on the back.

Crunch Network: CrunchBoard because it’s time for you to find a new Job2.0

MySQL has a lot of string data types - CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it is not enough

I would also like to see type HEXCHAR which would be able to store hex strings, such as those returned as MD5() and SHA1() efficiently. With little modification it could work for UUID() as well (it adds some dashes). Currently it is quite inconvenient to deal with strings like that in MySQL. Either you store them as strings and waste space or you spend them as binary and deal with inconvenience of having not readable strings in the table OR adding UNHEX() everywhere - which also adds overhead.

Another one I would like to see is zBLOB or zTEXT (or call them BLOB COMPRESSED/ TEXT COMPRESSED) which would transparently compress the blobs when they are inserted and retrieved from the database - this would allow to avoid having COMPRESS()/UNCOMPRESS() everywhere which clobbers things or compressing/uncompressing on the client.

It would be best if last one is optimized so if BLOB is not used in any WHERE clause (HAVING, GROUP BY etc) you could actually transparently decompress it on the client and compress bad. Though this is likely to require more significant changes in MySQL so I would not expect to happen quickly. The basic support should not be that hard though.

---

Entry posted by peter | 6 comments

Add to: | | | |

The COLLABORATE 08 conference went very well this year with excellent attendance and, as usual, high quality and informative presentations.  The aspect I especially like about COLLABORATE as compared to other conferences is that it is user-driven and almost all the 500+ technical sessions were devoid of any marketing speak or selling of products.

I presented 3 sessions between IOUG and OAUG, which were all well attended with over 150 people per session.  I guess security is really starting to become ingrained at many organizations.  I was somewhat surprised at the number of organizations relatively current with CPU patches based on the informal and highly unscientific "show of hands" surveys.

The PowerPoint presentations from my 3 sessions can be downloaded here -

Oracle Applications Users Group (OAUG)

Oracle E-Business Suite Critical Patch Updates: Insight and Understanding

Independent Oracle Users Group (IOUG)

Oracle Database Critical Patch Updates: Unwrapped

Real-life Database Security Mistakes

 

hdlm 5.9是hds多路径软件最新版本的，它与以前版本有不小的改进，比如以前一个ldev，如果有4个通道，那么在os上面可以看到4个hdisk，然后这个hdisk再组成一个dlmfdrv，在5.9中只有一个hdisk，没有dlmfdrv等等。在hacmp中配置的话，也有一些改动1.Method to identify ghost disks用下面这个角本，还是没变。/usr/DynamicLinkManager/cluster/dlm_hacmp_gdisk_check2.Method to identify ghost disks要采用"SCSI3"，以前的角本已经没了。3.disk type设置为：disk/fcp/Hitachi