机器配置 处理器 intel(R)xeon(R) E5405 @2.00 GH2 4个cpu
内存 4g。 ,分给ORACLE SGA 1129M,PGA 359M。windows 2003 Server 系统,数据库oracle92。TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12540: TNS:超出内部极限限制
TNS-12560: TNS: 协议适配器错误
TNS-00510: 超出内部极限限制
32-bit Windows Error: 8: Exec format error请问是什么原因导致的呢?
内存 4g。 ,分给ORACLE SGA 1129M,PGA 359M。windows 2003 Server 系统,数据库oracle92。TNS-12500: TNS:监听器未能启动专用的服务器进程
TNS-12540: TNS:超出内部极限限制
TNS-12560: TNS: 协议适配器错误
TNS-00510: 超出内部极限限制
32-bit Windows Error: 8: Exec format error请问是什么原因导致的呢?
SGA分配oracle总内存的60%~80%,约2.1G,
PGA分配oracle总内存的20%~40%,约900M,
然后根据具体情况再调整。
sessions = 665
timed_statistics = TRUE
shared_pool_size = 243269632
sga_max_size = 1217471568
large_pool_size = 150994944
java_pool_size = 41943040
control_files = D:\oracle\oradata\jcyy\CONTROL01.CTL, D:\oracle\oradata\jcyy\CONTROL02.CTL, D:\oracle\oradata\jcyy\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 729808896
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 32
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = jcyy
dispatchers = (PROTOCOL=TCP) (SERVICE=jcyyXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
hash_area_size = 1048576
background_dump_dest = D:\oracle\admin\jcyy\bdump
user_dump_dest = D:\oracle\admin\jcyy\udump
core_dump_dest = D:\oracle\admin\jcyy\cdump
sort_area_size = 1048576
db_name = jcyy
open_cursors = 300
star_transformation_enabled= TRUE
query_rewrite_enabled = TRUE
pga_aggregate_target = 398458880
aq_tm_processes = 1