帮忙看一份AWR

[复制链接]
查看11 | 回复9 | 2009-3-10 21:13:09 | 显示全部楼层 |阅读模式
[oracle@ ~]$ netstat -s
Ip:
809822061 total packets received
55926 with invalid addresses
0 forwarded
0 incoming packets discarded
466370724 incoming packets delivered
444574924 requests sent out
45010 fragments dropped after timeout
413215646 reassemblies required
70404407 packets reassembled ok
450201 packet reassembles failed
55591164 fragments received ok
315244982 fragments created
Icmp:
34512 ICMP messages received
5 input ICMP message failed.
ICMP input histogram:
destination unreachable: 19780
echo requests: 14686
echo replies: 46
49642 ICMP messages sent
0 ICMP messages failed
ICMP output histogram:
destination unreachable: 2612
time exceeded: 32290
echo request: 54
echo replies: 14686
IcmpMsg:
InType0: 46
InType3: 19780
InType8: 14686
OutType0: 14686
OutType3: 2612
OutType8: 54
OutType11: 32290
Tcp:
32684 active connections openings
40302 passive connection openings
45 failed connection attempts
1220 connection resets received
260 connections established
82554713 segments received
84688238 segments send out
991 segments retransmited
5 bad segments received.
240 resets sent
Udp:
382559874 packets received
5278 packets to unknown port received.
0 packet receive errors
359836050 packets sent
TcpExt:
64 invalid SYN cookies received
36429 TCP sockets finished time wait in fast timer
18 time wait sockets recycled by time stamp
1367903 delayed acks sent
428 delayed acks further delayed because of locked socket
Quick ack mode was activated 874 times
75519212 packets directly queued to recvmsg prequeue.
7538845 packets directly received from backlog
2489004686 packets directly received from prequeue
929028 packets header predicted
64341161 packets header predicted and directly queued to user
1451291 acknowledgments not containing data received
69929348 predicted acknowledgments
98 times recovered from packet loss due to SACK data
TCPDSACKUndo: 122
140 congestion windows recovered after partial ack
125 TCP data loss events
81 timeouts after SACK recovery
132 fast retransmits
19 forward retransmits
124 retransmits in slow start
564 other TCP timeouts
1 sack retransmits failed
2 times receiver scheduled too late for direct processing
874 DSACKs sent for old packets
260 DSACKs received
2 connections reset due to unexpected data
28 connections aborted due to timeout
IpExt:
InMcastPkts: 3994
OutMcastPkts: 45
InBcastPkts: 1215314
[oracle@ ~]$ more /proc/sys/net/ipv4/ipfrag_low_thresh
393216
[oracle@ ~]$ more /proc/sys/net/ipv4/ipfrag_high_thresh
524288
[oracle@~]$ more /proc/sys/net/ipv4/ipfrag_time
30
基本可以确定系统性能瓶颈为网络问题和SQL问题。
问题是:网络这块重组成功比率是多少可以接受?
如果要优化,怎么优化?
回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
完整的贴出sp/awr
回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
看看cat /etc/sysctl.conf
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
vm.nr_hugepages=1120
看看mtu是多少。
ifconfig -a


回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
看看你内联网卡是否丢包。

回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
ping -s 30000 xxx.xxxx.xxx
你好像一直在ping吗?
回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
to:iops
awr不方便全贴,我能发到你邮箱吗?

回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
to: Ifree
mtu是默认的,1500
现在无法连接到服务器,无法得到网络配置。
没有ping,内网压力比较大,有丢包
回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
没有ping
Icmp:
34512 ICMP messages received
5 input ICMP message failed.
ICMP input histogram:
destination unreachable: 19780
echo requests: 14686
echo replies: 46
49642 ICMP messages sent
0 ICMP messages failed
这些是那里来的。
回复

使用道具 举报

千问 | 2009-3-10 21:13:09 | 显示全部楼层
CPU的比重过高,看看报告其他部分,比如TIME MODEL STATISTICS
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行