Quest 收购 Imceda

Blog 上看到的消息，Quest 刚刚收购了一家公司 Imceda.Imceda 公司一直致力于提供全方位的 SQL Server 平台的产品解决方案.

The acquisition is valued at approximately $61 million, of which 20% will be paid in shares of Quest Software Common Stock and the balance will be paid in cash. Quest currently expects that the transaction will be completed in the second quarter of 2005, subject to customary closing conditions and regulatory approvals including expiration of the applicable Hart-Scott-Rodino waiting period, and that it is estimated to be neutral to fully diluted earnings per share within the first 12 months of closing, and accretive thereafter.

长期以来，Quest一直在 SQL Server 相关的工具上少有建树．市场占有率十分微小．这次又故技重演，用杀手锏＂收购＂来获得市场的占有率．很多人都认为，Quest 是一家非常会收购的公司.

前一段时间还有人说 Quest 要被 Oracle 收购，没想到 Quest 还活得不错．

继续阅读 →

V$Session_LONGOPS

这个视图的来源大致是这样的:

SELECT inst_id, ksulosno, ksulosrn, ksulopna, ksulotna, ksulotde, ksulosfr,
ksulotot, ksulouni,
TO_DATE (ksulostm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
TO_DATE (ksulolut, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
DECODE (SIGN (ksulotot - ksulosfr),
-1, TO_NUMBER (NULL),
DECODE (ksulosfr,
0, TO_NUMBER (NULL),
ROUND (ksuloetm * ((ksulotot - ksulosfr) / ksulosfr))
)
),
ksuloetm, ksuloctx, ksulomsg, ksulounm, ksulosql, ksulosqh, ksuloqid
FROM x$ksulop;

补充信息: 一篇非常好的解释文档。有些内容我之前也不知道。

继续阅读 →

Tom 的 Expert one on one 的一个Bug

Tom 的 Expert one on one：　Oracle 的一个Bug. 第三章讲到DML所的时候 Tom 用了一个脚本：

tkyte@TKYTE816> select username,
2         v$lock.sid,
3         trunc(id1/power(2,16)) rbs,
4         bitand(id1,to_number('ffff','xxxx'))+0 slot,
5         id2 seq,
6         lmode,
7         request
8  from v$lock, v$session
9  where v$lock.type = 'TX'
10    and v$lock.sid = v$session.sid
11    and v$session.username = USER
12  /
USERNAME        SID        RBS       SLOT        SEQ      LMODE    REQUEST
-------- ---------- ---------- ---------- ---------- ---------- ----------
TKYTE             8          2         46        160          6          0

产品库上最好别直接用这个脚本，很慢很慢的.

继续阅读 →

ORA-02248

遇到一个ora-02248: invalid option for ALTER SESSION的错误．环境是
java/10g instant client连接到
Oracle 9206 数据库发生的

继续阅读 →