DBA notes

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

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

解决的办法是加上一个Hint:

SELECT /*+ rule */ username, v$lock.SID, TRUNC (id1 / POWER (2, 16)) rbs,
       BITAND (id1, TO_NUMBER ('ffff', 'xxxx')) + 0 slot, id2 seq, lmode,
       request
  FROM v$lock, v$session
 WHERE v$lock.TYPE = 'TX'
   AND v$lock.SID = v$session.SID
   AND v$session.username = USER
/

Posted by Fenng at 1:16 AM | Permalink | Comments (4)

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

Java 报告的错误:

WARN support.SQLErrorCodesFactory - Error while extracting database product name - falling back to empty error codes org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-00604: error occurred at recursive SQL level 1 ORA-02248: invalid option for ALTER SESSION )

ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_CURRENCY= '$' NLS_ISO_CURRENCY= 'AMERICA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_DUAL_CURRENCY = '$' NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR' END OF STMT

ALTER SESSION SET NLS_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_TERRITORY= 'CHINA' NLS_CURRENCY= '£¿ NLS_ISO_CURRENCY= 'CHINA' NLS_NUMERIC_CHARACTERS= '.,' NLS_CALENDAR= 'GREGORIAN' NLS_DATE_FORMAT= 'DD-MON-RR' NLS_DATE_LANGUAGE= 'SIMPLIFIED CHINESE' NLS_SORT= 'BINARY' TIME_ZONE= '+08:00' NLS_COMP='BINARY' NLS_DUAL_CURRENCY = '£¿ NLS_TIME_FORMAT = 'HH.MI.SSXFF AM' NLS_TIMESTAMP_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM' NLS_TIME_TZ_FORMAT = 'HH.MI.SSXFF AM TZR' NLS_TIMESTAMP_TZ_FORMAT = 'DD-MON-RR HH.MI.SSXFF AM TZR'

Posted by Fenng at 4:03 AM | Permalink | Comments (1)

Do you Blog ?!

总算通过Proxy站点看到了Tom的Blog.Tom 的Blog技术内容不太多的，但是有很多关于他自己的信息．比如，这个大师每天的时间安排，生活习惯等．.Tom也透漏了关于他的Oracle expert one on one 的很多信息，比如写作安排:

This month is unique for I've taken most of it off from Oracle to work on the second edition of Expert One on One Oracle (to be renamed as WROX went out of business and Apress lost rights to use the "Expert One on One" tagline when they bought it).

This month I've been working on Expert One on One Oracle, second edition. It is sort of eye opening. I'm taking the book from being Oracle 8i, 8.1.7 and before specific and updating to 9ir1, 9ir2 and 10gr1. So much has changed. The single chapter that was chapter 2 (Architecture) is now chapters 3, 4 and 5. In Oracle's quest to make things easier, it has become alot harder to describe! Look at files -- lots of new "file stuff" from ASM to spfiles to flashrecovery areas. Memory, unbelievable. Describing the SGA used to be easy, how PGA/UGA memory worked -- a piece of cake.
Now, are you auto PGA memory management and what about that pga_aggregrate_target which is more of a wish than a directive and add into that auto SGA management, manual SGA management and the hybrid automatic/manual mode you could put it in -- well, 12 pages blossomed out to 35 pages.
I even have some 500 user tests in there, to show how workarea_size_policy = AUTO|MANUAL scale up in their use of memory... Wonder how I got that on my single cpu laptop?.. Actually I ran that on my dell poweredge server in the basement. It was quite fun, never did a 500 user test in my basement before. Things have changed since version 1 of the book.

Posted by Fenng at 3:34 AM | Permalink | Comments (0)

加了一个晚上的班，还是进展不大．但是看到了这个令人震惊的消息．Adobe and Macromedia．

具体的交易细节如下：

Adobe Systems Incorporated (Nasdaq: ADBE) has announced a definitive agreement to acquire Macromedia (Nasdaq: MACR) in an all-stock transaction valued at approximately $3.4 billion. Under the terms of the agreement, which has been approved by both boards of directors, Macromedia stockholders will receive, at a fixed exchange ratio, 0.69 shares of Adobe common stock for every share of Macromedia common stock in a tax-free exchange. Based on Adobe’s and Macromedia’s closing prices on Friday April 15, 2005, this represents a price of $41.86 per share of Macromedia common stock. (Copy from Adobe)

Adobe 和 Macromedia 都是令人喜欢的公司．这个年代用计算机的人恐怕没有人没用过Acrobat Reader,设计过网页的人怕是也都用"网页设计三剑客"．毫无疑问，一个软件巨人诞生了．从04年到现在，并购的消息不断传来．看来，这是个并购/合并的年代．

回想起自己刚刚学习计算机的时候，买的第一本关于网页设计的书也是国内第一本关于DreamWeaver的书，那个时候 DreamWeaver 应该刚刚到2.0的版本，Bug 好多，而且还对中文支持不好，但是功能也足够强大了。虽然，对HTML的东西浅尝辄止，不过也足够令我引起回忆。

Adobe & Macromedia ，一路走好！

Posted by Fenng at 5:44 AM | Permalink | Comments (0)