2g内存,win2003机子只跑oracle和一些必要软件,请大伙看下我配置,还有什么可再优化,另db_keep_cache_size需怎么设置,谢谢
aq_tm_processes = 1
background_dump_dest = E:\OraHome90\admin\aaa\bdump
compatible = 9.2.0.0.0
control_files = ('f:\OraHome90\oradata\stsale\CONTROL01.CTL', 'f:\OraHome90\oradata\aaa\CONTROL02.CTL', 'f:\OraHome90\oradata\aaa\CONTROL03.CTL')
core_dump_dest = f:\OraHome90\admin\aaa\cdump
db_block_size = 8192
db_cache_size = 754974720
db_domain = ''
db_file_multiblock_read_count = 16
db_name = aaa
db_writer_processes = 2
dispatchers = '(PROTOCOL=TCP) (SERVICE=aaaXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = aaa
java_pool_size = 33554432
job_queue_processes = 10
large_pool_size = 8388608
log_archive_dest_1 = 'LOCATION=f:\OraHome90\RDBMS'
open_cursors = 300
pga_aggregate_target = 104857600
processes = 150
query_rewrite_enabled = FALSE
remote_login_passwordfile = EXCLUSIVE
sga_max_size = 1360078244
shared_pool_size = 50331648
sort_area_size = 524288
star_transformation_enabled = FALSE
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = f:\OraHome90\admin\aaa\udump
aq_tm_processes = 1
background_dump_dest = E:\OraHome90\admin\aaa\bdump
compatible = 9.2.0.0.0
control_files = ('f:\OraHome90\oradata\stsale\CONTROL01.CTL', 'f:\OraHome90\oradata\aaa\CONTROL02.CTL', 'f:\OraHome90\oradata\aaa\CONTROL03.CTL')
core_dump_dest = f:\OraHome90\admin\aaa\cdump
db_block_size = 8192
db_cache_size = 754974720
db_domain = ''
db_file_multiblock_read_count = 16
db_name = aaa
db_writer_processes = 2
dispatchers = '(PROTOCOL=TCP) (SERVICE=aaaXDB)'
fast_start_mttr_target = 300
hash_join_enabled = TRUE
instance_name = aaa
java_pool_size = 33554432
job_queue_processes = 10
large_pool_size = 8388608
log_archive_dest_1 = 'LOCATION=f:\OraHome90\RDBMS'
open_cursors = 300
pga_aggregate_target = 104857600
processes = 150
query_rewrite_enabled = FALSE
remote_login_passwordfile = EXCLUSIVE
sga_max_size = 1360078244
shared_pool_size = 50331648
sort_area_size = 524288
star_transformation_enabled = FALSE
timed_statistics = TRUE
undo_management = AUTO
undo_retention = 10800
undo_tablespace = UNDOTBS1
user_dump_dest = f:\OraHome90\admin\aaa\udump
解决方案 »
- 请问谁有Oracle 和Java的数据类型对应表
- 求助!!win7安装oracle 10g成功后出现问题!!!
- oracle数据库备份方式的选择
- 有没有Oracle for OleDb的独立驱动?
- 一个sql语句怎么写?
- 请问有谁知道,如何能读出oracle中所有用户的SQl语句是什么啊!!
- 如何在安装程序中,实现修改系统的环境变量为oracle客户端的安装目录????
- 请教系统自动创建的数据库有何用处,这是8I和9I的不同,请大家都看看,谢谢
- 请问:schema和object之间的关系.
- 存储过程分页
- 有人能教教我装ODI11g吗?
- 如何禁止其他用户通过powerbuiler查询oracle下的某个表
sga_max_size = 1360078244會不會大了點。關注~