java_pool_size和shared_pool_size问题,急!!在线等!!!谢谢~
dlgy 2005-04-22 04:09:01 我的数据库sid:ddragon
initddragon.ora的配置如下:
db_name=ora9204
db_files = 80 # SMALL
db_file_multiblock_read_count = 8 # SMALL
db_block_buffers = 100 # SMALL
shared_pool_size = 220242800 # SMALL
java_pool_size = 220242800
log_checkpoint_interval = 10000
processes = 50 # SMALL
parallel_max_servers = 5 # SMALL
log_buffer = 32768 # SMALL
max_dump_file_size = 10240 # limit trace file size to 5 Meg each
log_checkpoint_interval = 10000
processes = 50 # SMALL
parallel_max_servers = 5 # SMALL
可是我在>SQL 下:
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 83886080
SQL> show parameter java_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
java_pool_size big integer 83886080
SQL> show parameter show parameter shared_pool_size
为什么会这样呢?对shared_pool_size和java_pool_size的设置没有生效,我从新启动了oracle阿
另:系统为AS3.0 数据库为oracle9.2.0.4
而且我查看select * from v$parameter,确实都是83886080,如何才能正确修改shared_pool_size和java_pool_size阿???
各位大虾不吝赐教阿!!拜谢了~~