0 积分	1 好友	7 主题

发消息

[RAC性能调优] 关于如果调优SQL*Net message from client的等待

1^#

发表于 2013-2-18 16:18:50 | 查看: 3013| 回复: 2

TKPROF: Release 11.2.0.2.0 - Development on Sun Feb 17 23:41:11 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Trace file: /data/logs/oracle/diag/diag/rdbms/mvf/MVF/trace/MVF_ora_11460.trc
Sort options: default

********************************************************************************
count = number of times OCI procedure was executed
cpu    = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk    = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows    = number of rows processed by the fetch or execute call
********************************************************************************

SQL ID: 45uhzhdcqzn98 Plan Hash: 272216465

SELECT dosr_object.breast_box_x0, dosr_object.breast_box_x1,
  dosr_object.breast_box_y0, dosr_object.breast_box_y1,
。。。。。
call    count    cpu elapsed    disk    query current       rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       1    0.01    0.00       0       0       0          0
Execute    1    0.00    0.00       0       0       0          0
Fetch    383    3.19    10.35    3100    13119       0       5719
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total    385    3.20    10.36    3100    13119       0       5719

Misses in library cache during parse: 0
Elapsed times include waiting on following events:
  Event waited on                            Times Max. Wait  Total Waited

Optimizer mode: ALL_ROWS
Parsing user id: 26
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max)  Row Source Operation
---------- ---------- ----------  ---------------------------------------------------
   5719    5719    5719  SORT ORDER BY (cr=13119 pr=3100 pw=0 time=10048780 us cost=13 size=159103 card=191)
   5719    5719    5719 FILTER  (cr=13119 pr=3100 pw=0 time=9032549 us)
   5719    5719    5719 NESTED LOOPS SEMI (cr=13119 pr=3100 pw=0 time=9019952 us cost=12 size=159103 card=191)
   5719    5719    5719    NESTED LOOPS  (cr=8134 pr=2405 pw=0 time=2581691 us cost=5 size=157384 card=191)
   5719    5719    5719    TABLE ACCESS BY INDEX ROWID DOSR_OBJECT (cr=1837 pr=489 pw=0 time=669011 us cost=1 size=30751 card=191)
   5719    5719    5719    INDEX RANGE SCAN DOSR_OBJECT_24 (cr=23 pr=21 pw=0 time=18718 us cost=1 size=0 card=191)(object id 10008)
   5719    5719    5719    TABLE ACCESS BY INDEX ROWID DOSR_OBJECT_DETAIL (cr=6297 pr=1916 pw=0 time=2399155 us cost=1 size=663 card=1)
   5719    5719    5719    INDEX UNIQUE SCAN DOSR_OBJECT_DETAIL_1 (cr=578 pr=51 pw=0 time=139134 us cost=1 size=0 card=1)(object id 10009)
   5719    5719    5719    TABLE ACCESS BY INDEX ROWID OSR_LOCATION (cr=4985 pr=695 pw=0 time=6520552 us cost=1 size=2391046695 card=265671855)
   5719    5719    5719    INDEX RANGE SCAN OSR_LOCATION_2 (cr=2628 pr=170 pw=0 time=1717836 us cost=1 size=0 card=1)(object id 9871)

Elapsed times include waiting on following events:
  Event waited on                            Times Max. Wait  Total Waited
  ---------------------------------------- Waited  ----------  ------------
  SQL*Net message to client                   383       0.00       0.00
  db file sequential read                   3100       0.06       7.45
  Disk file operations I/O                      12       0.00       0.00
  SQL*Net message from client                382       0.04       9.22
物理读取用了7.45s，网络上等待了9.22s
有什么办法可以减少SQL*Net message from client的等待时间呢？谢谢

分享0