ccton

24 积分	1 好友	2 主题

发消息

应用查询慢，分析下

1^#

发表于 2011-11-4 12:06:29 | 查看: 5831| 回复: 1

应用查询很慢，求分析下
附件是 awr的结果
windows2003 64bit +11gR1
SQL> show parameter sga

NAME                               TYPE       VALUE
------------------------------------ ----------- --------------------
lock_sga                            boolean    FALSE
pre_page_sga                      boolean    FALSE
sga_max_size                      big integer 2312M
sga_target                         big integer 2304M
SQL> show parameter sga

NAME                               TYPE       VALUE
------------------------------------ ----------- --------------------
lock_sga                            boolean    FALSE
pre_page_sga                      boolean    FALSE
sga_max_size                      big integer 2312M
sga_target                         big integer 2304M
SQL>
以下是netstat 结果
求给位大佬帮分析下

C:\Documents and Settings\Administrator>netstat -no

Active Connections

  Proto  Local Address       Foreign Address       State          PID
  TCP 123.123.123.11:1045 123.123.123.10:5000 ESTABLISHED    1792
  TCP 123.123.123.11:5000 123.123.123.10:1035 ESTABLISHED    1792
  TCP 172.16.2.1:80       10.10.6.10:3074       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.10:3075       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.11:1653       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.11:1654       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.13:3527       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.13:3664       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.19:2806       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.19:2807       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.20:4886       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.20:4903       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.31:3767       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.31:3768       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.38:1781       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.38:1782       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.42:3088       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.42:3089       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.46:1202       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.46:1203       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.54:2803       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.54:2804       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.55:2194       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.55:2195       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.59:2581       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.59:2582       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.63:1040       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.63:1061       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.70:1278       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.70:1295       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.75:4089       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.79:1122       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.79:1123       ESTABLISHED    4
  TCP 172.16.2.1:80       10.10.6.89:3541       ESTABLISHED    4
  TCP 172.16.2.1:1521       10.10.6.249:4202    ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.6.250:2419    ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.6.254:1154    ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.20:1408       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.21:3418       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.44:1508       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.98:3026       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.98:3098       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.98:3109       ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.203:3858    ESTABLISHED    3624
  TCP 172.16.2.1:1521       10.10.9.203:3907    ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:1581       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:1956       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:1962       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:3808       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:4194       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:4346       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.1:4674       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:1537       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:1564       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:1962       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:1982       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:2001       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:2537       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.2:3181       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.5:2825       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.5:3084       ESTABLISHED    3624
  TCP 172.16.2.1:1521       172.16.2.5:3085       ESTABLISHED    3624
  TCP 172.16.2.1:1581       172.16.2.1:1521       ESTABLISHED    3728
  TCP 172.16.2.1:1956       172.16.2.1:1521       ESTABLISHED    1152
  TCP 172.16.2.1:1962       172.16.2.1:1521       ESTABLISHED    1152
  TCP 172.16.2.1:3389       172.16.10.2:31834    ESTABLISHED    216
  TCP 172.16.2.1:3808       172.16.2.1:1521       ESTABLISHED    3728
  TCP 172.16.2.1:4194       172.16.2.1:1521       ESTABLISHED    3728
  TCP 172.16.2.1:4346       172.16.2.1:1521       ESTABLISHED    3728
  TCP 172.16.2.1:4674       172.16.2.1:1521       ESTABLISHED    3728
  TCP 172.16.2.1:4720       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4725       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4727       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4730       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4734       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4736       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4740       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4741       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4742       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4743       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4744       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4745       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4746       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4747       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4749       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4750       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4751       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4752       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4754       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4755       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4757       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4759       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4761       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4763       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4765       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.1:4766       172.16.2.1:1521       TIME_WAIT    0
  TCP 172.16.2.6:139       172.16.2.5:1033       ESTABLISHED    4
  TCP 172.16.2.6:1047       172.16.2.5:139       ESTABLISHED    4
  TCP 172.16.2.6:1521       172.16.2.6:4933       ESTABLISHED    3624
  TCP 172.16.2.6:4767       121.14.11.177:80    SYN_SENT       2820
  TCP 172.16.2.6:4933       172.16.2.6:1521       ESTABLISHED    3480

[ 本帖最后由 ccton 于 2011-11-4 12:21 编辑 ]