18 积分	0 好友	4 主题

发消息

[Exadata常规管理] 其中一个节点CPU,内存特别高，请指教

1^#

发表于 2014-3-25 11:23:23 | 查看: 4682| 回复: 4

尊敬的各位
我的环境是2台AIX+oracle 11g rac,现在有一台服务器（节点2）负载异常高，维持2天了还是这样，我们尝试把所有中间件重启，还是没有效果。生产数据库不敢随意重启，望指教，谢谢了！

rpt_20140324.html (847.08 KB, 下载次数: 755)

log_节点2.rar (143.45 KB, 下载次数: 1196)

分享0

magic

收藏0 回复只看该作者道具举报

江南的诗

2^#

发表于 2014-3-25 21:38:22

给出3xwuxzuj1dy7k，fyh5gcu6fznp7的执行计划，并且给出相应的ash

回复只看该作者道具举报

Benson2014

3^#

发表于 2014-3-26 10:02:42

Logical reads/ Per Transaction is up to 153,203.0

The high Logical reads SQL caused by the table T_CONTRACT_PRODUCT_DETAIL and T_ORDER_DETAIL SQL statements.

Please kindly tune all the SQL statements related to above two table to reduce the logical reads
Could you kindly provide below SQL plan for investigation?
3xwuxzuj1dy7k
fyh5gcu6fznp7
1mb1kktxwht24
6r489jf6fr55v

It will be very helpfully if you can provide the some AWR when the database was health before ago.

回复只看该作者道具举报

lingksxz

4^#

发表于 2014-3-26 14:03:20

非常感谢各位的热心帮助
我在日志里发现了一些类似如下错误

<msg time='2014-03-25T09:17:24.175+08:00' org_id='oracle' comp_id='rdbms'
msg_id='471665330' type='INCIDENT_ERROR' level='1'
host_id='yjsdb2' host_addr='10.20.2.102' prob_key='ORA 3137 [12209]'
upstream_comp='' downstream_comp='' ecid=''
errid='81202' detail_path='/oracle/app/oracle/diag/rdbms/yjsdb/yjsdb2/trace/yjsdb2_ora_14286882.trc'>
<txt>Errors in file /oracle/app/oracle/diag/rdbms/yjsdb/yjsdb2/trace/yjsdb2_ora_14286882.trc (incident=81202):
ORA-03137: TTC protocol internal error : [12209] [513] [] [] [] [] [] []
</txt>
</msg>
<msg time='2014-03-25T09:17:27.294+08:00' org_id='oracle' comp_id='rdbms'
msg_id='dbgexProcessError:1176:3370026720' type='TRACE' level='16'
host_id='yjsdb2' host_addr='10.20.2.102'>
<txt>Incident details in: /oracle/app/oracle/diag/rdbms/yjsdb/yjsdb2/incident/incdir_81202/yjsdb2_ora_14286882_i81202.trc
</txt>
</msg>

<msg time='2014-03-25T09:14:06.299+08:00' org_id='oracle' comp_id='rdbms'
msg_id='dbgexProcessError:1176:3370026720' type='TRACE' level='16'
host_id='yjsdb2' host_addr='10.20.2.102'>
<txt>Incident details in: /oracle/app/oracle/diag/rdbms/yjsdb/yjsdb2/incident/incdir_79626/yjsdb2_ora_29426342_i79626.trc
</txt>
</msg>

我查了一下是不是与BUG有关呢

我的版本是11.1. 的

回复只看该作者道具举报

Benson2014

5^#

发表于 2014-3-26 16:36:17

could you provide the whole alert.log and trace file?

If you guess that is Bug, you are better to open a tar to Oracle support.

thanks.

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册