ORA-00600 [925]

今天做一個測試又遇到一個bug：
SQL> alter session set sort_area_size=2000000000;

alter session set sort_area_size=2000000000

ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00600: internal error code, arguments: [925], [hash_area_size], [-294967296], [], [], [], [], []

我的平臺是：
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production

TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

搜了metalink，除了確認是一個bug外，沒有太多有用的資訊。

這個bug在9i很多平臺下都可能會遇到，bug觸發的臨界點是1024m：
SQL> select 1024*1024*1024 from dual;

1024*1024*1024
--------------
1073741824

SQL> alter session set sort_area_size=1073741824;

alter session set sort_area_size=1073741824

ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00600: internal error code, arguments: [925], [hash_area_size], [-2147483648], [], [], [], [], []

SQL> alter session set sort_area_size=1073741823;

Session altered

不過，這個bug在10g已經得以修正：

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> alter session set sort_area_size=2000000000;

Session altered.