sqlplus连oracle，速度非常慢！为什么？

Question

应该是你的网络性能的问题吧.
看看select * from V$system_event order by TIME_WAITED;等待是啥.

Answer 1

这是我刚刚执行的结果，是什么意思呢？还请您给解释一下SQL> select * from V$system_event order by TIME_WAITED;EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
local write wait
          1              0           0            0              4349recovery read
          2              0           0            0                 8instance state change
          2              0           0            0                84
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
SQL*Net break/reset to client
         18              0           0            0              2529LGWR wait for redo copy
        151              0           0            0              1582latch free
          6              5           1            0              6293
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
library cache load lock
          2              0           1            0              9523reliable message
          1              0           8            8             84879process startup
          1              0          11           11            113766
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
db file parallel read
          1              0          14           14            142713direct path write (lob)
         18              0          14            1            135360SQL*Net more data from client
        781              0          14            0            142325
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
SQL*Net message to client
     106791              0          20            0            203083db file single write
         12              0          32            3            321294log file single write
          7              0          45            6            453695
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
SQL*Net more data to client
      10788              0          46            0            456516checkpoint completed
          1              0          57           57            574718log file sequential read
         10              0          61            6            612978
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
log file parallel write
      10054              0          74            0            737242buffer busy waits
        135              0          97            1            970171sort segment request
          1              1          99           99            985782
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
refresh controlfile command
          1              0         105          105           1048862direct path read
        325              0         153            0           1532805direct path write
        295              0         191            1           1907209
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
control file heartbeat
          1              1         399          399           3987385control file sequential read
       1950              0        1258            1          12582146rdbms ipc reply
         33              5        1487           45          14865579
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
db file sequential read
      15227              0        4824            0          48235176db file scattered read
      42457              0       13749            0         137489603log file sync
       2925              0       27314            9         273139818
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
db file parallel write
       2416              0       48574           20         485742872enqueue
       2067           2061      618896          299        6188964477control file parallel write
      28058              0      650548           23        6505476385
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
smon timer
        319            298     8516062        26696        8.5161E+10wakeup time manager
       3015           3015     8692132         2883        8.6921E+10dispatcher timer
       1506           1506     8957935         5948        8.9579E+10
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
virtual circuit status
       3012           3012     8991790         2985        8.9918E+10pmon timer
      30126          30121     9032068          300        9.0321E+10SQL*Net message from client
     106782              0     9154737           86        9.1547E+10
EVENT
--------------------------------------------------------------------------------
TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO
----------- -------------- ----------- ------------ -----------------
rdbms ipc message
     118364         109154    41679602          352        4.1680E+11
40 rows selected.SQL>

Answer 2

用PLSQL Developer这个软件试试，应该好些。

Answer 3

try：
修改sqlnet.ora
注释掉SQLNET.AUTHENTICATION_SERVICES= (NTS)记得以前很多这个问题，怎么一段时间没来，还是问这个啊

Answer 4

呵呵，搞定了，本来客户端就没这一句
SQLNET.AUTHENTICATION_SERVICES= (NTS)不过启发了思维，把
NAMES.DIRECTORY_PATH=
里面的TNSNAMES移动到了第一个就可以了。

Answer 5

liuyi8903(tony) 
应该是你的网络性能的问题吧.  
看看select  *  from  V$system_event  order  by  TIME_WAITED;等待是啥. 帮忙解释一下这个语句的输出好吗？谢谢！

Answer 6

把你的listener.log里面的内容清一清再说吧.liuyi8903(tony) 
应该是你的网络性能的问题吧.  
看看select  *  from  V$system_event  order  by  TIME_WAITED;等待是啥. 帮忙解释一下这个语句的输出好吗？谢谢！
系统事件的等待时间