oracle : 10G (10.2.0.2)
OS : windows 2003 server 32 bit
Cpu: xeon 3g(两个)
Memory: 8G
初始参数:
sga_max_size : 1048M
pga_aggregate_target : 512 M
work_area_policy : auto
db_cache_size : 768 M
shared_pool_size : 256 M
log_buffer : 7M
最近数据库隔三差五就报:
ORA-04030: 在尝试分配 123404 字节 (QERHJ hash-joi,kllcqas:kllsltba) 时进程内存不足错误
且客户端不能连接! 监听报错,
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.2.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.2.0 - Production
Time: 31-8月 -2008 04:32:19
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: 操作超时
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: