Oracle 10g XE java_pool_size & streams_pool

From: <thatsang_at_gmail.com>
Date: 28 Jan 2007 23:44:01 -0800
Message-ID: <1170056641.664135.262520@a75g2000cwd.googlegroups.com>

Oracle 10g XE does not support Java nor Streams. However, Oracle insists on assigning 1 dozen MB total for them even is the corresponding *_pool_size are set to 0. Isn't this a bit stupid?

SQL> select * from v$version;

BANNER

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

SQL> select pool, name, bytes
2 from v$sgastat
3 where pool in ('java pool', 'streams pool');

POOL                     NAME                 BYTES


------------------------ --------------- ----------

java pool                free memory        4194304
streams pool             free memory        8388608

SQL> show parameter java_pool_size

NAME                                 TYPE


------------------------------------ ----------------------

VALUE

java_pool_size                       big integer

0
SQL> show parameter streams_pool_size

NAME                                 TYPE


------------------------------------ ----------------------

VALUE

streams_pool_size                    big integer

In SPFILEXE.ORA, it seems __*_pool_size are non-zero. $ strings SPFILEXE.ORA |grep '__.*'

xe.__db_cache_size=54525952
xe.__java_pool_size=4194304
xe.__large_pool_size=8388608
xe.__shared_pool_size=88080384
xe.__streams_pool_size=8388608

However, since ASMM is in use, there seems no way to set to zero? SQL> alter system set __java_pool_size=0 scope=both; alter system set __java_pool_size=0 scope=both

ERROR at line 1:
ORA-00911: invalid character Received on Mon Jan 29 2007 - 01:44:01 CST

Oracle 10g XE java_pool_size & streams_pool_size