# 44508
ocp_oracle
来自: 云南
|
|
To: 板主
希望能后能与oracle大师交流经验!
From: ocp_oracle 2009.11.04 21:39
|
|
|
|
# 44504
华
来自: 沈阳
|
|
To: eygle老师
本人有两个问题:
1、
*.db_cache_size=1.5G
*.large_pool_size=1G
*.shared_pool_size=2.5G
一个weblogic 200个连接,共1200左右个数据库连接
max_shared_servers该设置多少啊?
现在的参数max_shared_servers=200,但查询的结果 servers_highwater=200
已经不够了。
2、最近alert_.log中存在大量ORA-00600怎么回事,怎么判断是什么问题?
Fri Oct 30 16:33:06 2009
Errors in file /opt/app/oracle/admin/db1/bdump/db1_s010_19456.trc:
ORA-00600: internal error code, arguments: [17281], [600], [0x000000000], [], [], [], [], []
ORA-00600: internal error code, arguments: [12209], [69], [], [], [], [], [], []
Fri Oct 30 16:33:51 2009
found dead shared server 'S005', pid = (15, 102)
found dead shared server 'S010', pid = (22, 7)
From: 华 2009.10.30 02:22
|
|
|
|
To: 华
12209 cursor number is found to be invalid
17281 Error closing all cursors for an instantiation
感觉你可能遇到Bug了。
From: eygle 2009.10.30 23:38
|
|
|
|
|