Database Tuning (MOSC)

MOSC Banner

slow oracle tnsping

edited Dec 6, 2012 6:02PM in Database Tuning (MOSC) 8 commentsAnswered

各位:

     下午好!

     想寻求一下大家的帮助,我们的一个Oracle 9I数据库(OS: Windows Server 2003  DB:9.2.0.8   实时信息较多)

     运行了一段时间后,发现速度特别慢,仔细查找之下,发现tnsping 特别慢,达到了约2000ms左右,正常不超过100ms。

     我运行了一下statspack,生成报告后发现几个疑点:

     1、高速缓存命中率低

     2、db file scattered read 和db file sequential read较高

    另外,我用Toad的图形软件看了一下,也有几个疑点(第一次发帖,不知如何贴图,请指教),同样贴上,请各位大侠帮忙分析一下,谢谢了。


STATSPACK report for

DB Name         DB Id    Instance     Inst Num Release     Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
BOSSDB         598609875 bossdb              1 9.2.0.8.0   NO      BSWXBOSS2

              Snap Id     Snap Time      Sessions Curs/Sess Comment
            --------- ------------------ -------- --------- -------------------
Begin Snap:        31 19-Nov-12 08:52:00       96       2.2
  End Snap:        81 22-Nov-12 16:00:00      111       2.2
   Elapsed:            4,748.00 (mins)

Cache Sizes (end)
~~~~~~~~~~~~~~~~~
               Buffer Cache:        56M      Std Block Size:          4K
           Shared Pool Size:       152M          Log Buffer:      3,072K

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:            543,074.07            332,347.19
              Logical reads:             38,248.53             23,407.10
              Block changes:              4,412.89              2,700.57
             Physical reads:              8,863.92              5,424.49
            Physical writes:                 67.99                 41.61
                 User calls:                321.88                196.98

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center