其中一个节点CPU,内存特别高，请指教
尊敬的各位我的环境是2台AIX+oracle 11g rac,现在有一台服务器（节点2）负载异常高，维持2天了还是这样，我们尝试把所有中间件重启，还是没有效果。生产数据库不敢随意重启，望指教，谢谢了！
给出3xwuxzuj1dy7k，fyh5gcu6fznp7的执行计划，并且给出相应的ash 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.
非常感谢各位的热心帮助
我在日志里发现了一些类似如下错误
<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 '
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 : [] [] [] [] [] []
</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. 的 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.
页:
[1]