在下的数据库是windows 2003 X64 + oracle 10.2.0.3 X64,物理内存8G,以下是init文件，大家给帮忙看看那里不合理

db_cache_size=1610612736 #858993459
java_pool_size=16777216
large_pool_size=16777216
shared_pool_size=369857228
streams_pool_size=0
*.audit_file_dest='d:\im/dump/adump'
*.background_dump_dest='d:\im/dump/bdump'
*.compatible='10.2.0.1.0'
*.control_files=('D:\im\CONTROLFILE\controlfile1.CTL','D:\im\CONTROLFILE\controlfile2.CTL','D:\im\CONTROLFILE\controlfile3.CTL')
*.core_dump_dest='d:\im/dump/cdump'
*.db_block_size=8192
*.db_create_file_dest='d:'
*.db_create_online_log_dest_1='d:\im\redo'
*.db_domain=''
*.db_file_multiblock_read_count=32
*.db_name='im'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=imXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=d:\im\archive'
*.log_archive_format='ARC%T_%R%S.arc'
*.nls_territory='TAIWAN'
*.open_cursors=300
*.pga_aggregate_target=858993458 #644245094 #966367641
*.processes=3500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=2755
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
*.user_dump_dest='d:\im/dump/udump'
*.log_archive_dest_2='service=standby reopen=60'
*.log_archive_dest_state_2=enable
#_kgl_large_heap_warning_threshold=8388608
sga_max_size=2684354560
sga_target=2147483648
#resource_limit=false;

线程是共享内存得，所以只能通过限制内存使用或者是其他方式来解决！

首先尝试修改SGA_TARGET SGA_MAX_SIZE 的大小看看！

alter system set sga_target = 1000M scope=both;

alter system set SGA_MAX_SIZE= 1000M scope=both;