Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Lot's of latch waits

Lot's of latch waits

From: Michael Kline <maklinesr_at_home.com>
Date: Thu, 30 Nov 2000 14:51:11 -0500
Message-Id: <10696.123350@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0007_01C05ADC.FB177F60
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: 7bit



I think this system is simply overloaded, but is there much that can be done
to eliminate latch waits? This is on VMS. This is the first system I've ever
seen this on. I might pick up a latch once in a while, but this is almost
every day.



cpus and cpu_count are 4.



Oracle7 Server Release 7.3.3.6.0 - Production Release






Statistics taken:




11/20/00 -- 09:22:06


      Wait Statistics for the Instance
 SID Event                          P1TEXT                          P1
P2TEXT                             P2
---- ------------------------------ -------------------- ------------- -----


-------------------- -----------

  46 latch free                     address              #############
number                             39
  57 latch free                     address              #############
number                             39
 103 latch free                     address              #############
number                             39
 247 latch free                     address              #############
number                             11
 254 latch free                     address              #############
number                             32
 144 latch free                     address              #############
number                             32
 132 latch free                     address              #############
number                             39
 257 latch free                     address              #############
number                             32
 315 latch free                     address              #############
number                             11
 311 latch free                     address              #############
number                             39
 193 enqueue                        name|mode             1415,053,318 id1
1310800
 245 enqueue                        name|mode             1415,053,318 id1
1310800
  48 db file sequential read        file#                           11
block#                         112244
 119 db file sequential read        file#                           34
block#                        1850142
 306 db file sequential read        file#                           11
block#                         216820
 146 db file scattered read         file#                           39
block#                          49657
 314 SQL*Net message to client      driver id             2154,229,760
#bytes                              1
============================================================================
================================




Statistics taken:




11/21/00 -- 13:46:04


      Wait Statistics for the Instance
 SID Event                          P1TEXT                          P1
P2TEXT                             P2
---- ------------------------------ -------------------- ------------- -----


-------------------- -----------

  52 latch free                     address              #############
number                             38
 202 latch free                     address              #############
number                             11
 203 latch free                     address              #############
number                             11
 309 latch free                     address              #############
number                             11
 314 latch free                     address              #############
number                             38
  24 db file sequential read        file#                            4
block#                          59466
 279 db file sequential read        file#                           30
block#                         570004
  80 db file sequential read        file#                           14
block#                         219889
 188 db file sequential read        file#                           35
block#                         136628
 100 db file sequential read        file#                           16
block#                         257032
============================================================================
================================




Statistics taken:




11/27/00 -- 17:29:41


      Wait Statistics for the Instance
 SID Event                          P1TEXT                          P1
P2TEXT                             P2
---- ------------------------------ -------------------- ------------- -----


-------------------- -----------

 142 latch free                     address              #############
number                             38
 166 latch free                     address              #############
number                             39
 277 latch free                     address              #############
number                             38
  89 db file sequential read        file#                            5
block#                         362678
 216 db file sequential read        file#                           16
block#                          27397
 291 db file sequential read        file#                           40
block#                           8728
 281 db file sequential read        file#                           40
block#                         423000
 213 db file sequential read        file#                           16
block#                          13737
   2 asynchronous I/O completion in                                  0
0
      sfdone
============================================================================
================================




Statistics taken:




11/28/00 -- 09:23:50


      Wait Statistics for the Instance
 SID Event                          P1TEXT                          P1
P2TEXT                             P2
---- ------------------------------ -------------------- ------------- -----


-------------------- -----------

  63 latch free                     address              #############
number                             11
 130 latch free                     address              #############
number                             38
 137 latch free                     address              #############
number                             38
  13 db file sequential read        file#                           11
block#                         124534
  97 db file sequential read        file#                           39
block#                         166802
  93 db file sequential read        file#                            5
block#                         309722
 261 db file sequential read        file#                           23
block#                          26977
 224 db file sequential read        file#                           22
block#                          31859
 153 db file sequential read        file#                            4
block#                          57700
 107 db file sequential read        file#                           11
block#                         206868
  29 db file sequential read        file#                           29
block#                         441001
  19 db file sequential read        file#                            4
block#                          57615
  48 db file scattered read         file#                           40
block#                         346250
 211 db file scattered read         file#                           38
block#                         263594
 305 db file scattered read         file#                           15
block#                           3084
 266 db file scattered read         file#                           39
block#                           7864
   2 asynchronous I/O completion in                                  0
0
      sfdone
============================================================================
================================




Statistics taken:




11/30/00 -- 10:07:01


      Wait Statistics for the Instance
 SID Event                          P1TEXT                          P1
P2TEXT                             P2
---- ------------------------------ -------------------- ------------- -----


-------------------- -----------

  37 latch free                     address              #############
number                             39
  50 latch free                     address              #############
number                             38
  95 latch free                     address              #############
number                             39
 104 latch free                     address              #############
number                             39
 141 latch free                     address              #############
number                             32
 169 latch free                     address              #############
number                             11
 179 latch free                     address              #############
number                             39
 298 latch free                     address              #############
number                             39
 306 latch free                     address              #############
number                             39
 203 latch free                     address              #############
number                             11
 177 latch free                     address              #############
number                             38
 191 db file sequential read        file#                           16
block#                          22534
 234 db file sequential read        file#                           16
block#                         257909
 247 db file sequential read        file#                           30
block#                          95257
============================================================================
================================






ThinkSpark  - Michael Alan Kline, Sr.


Technical Consultant -  Richmond, Virginia Office
13308 Thornridge Court; Midlothian, VA 23112, USA.
W:    804-744-1545


Michael.Kline_at_ThinkSpark.com


Pager: 877-705-1155


Alpha pager: www.metrocall.com/Page.html
ICQ: 1009605, 975313    PhoneFree: 1057439




------=_NextPart_000_0007_01C05ADC.FB177F60
Content-Type: application/ms-tnef;


        name="winmail.dat"


Content-Transfer-Encoding: base64


Content-Disposition: attachment;


        filename="winmail.dat"



eJ8+IgsTAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCwAeAA4AMwAAAAQARQEB
A5AGAPgOAAAnAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAFQAAAExvdCdzIG9mIGxhdGNoIHdhaXRzAAAAAAIBcQABAAAAFgAAAAHAWwbju9W+fUnuwkgQ
qW3uz5LJdQEAAAIBHQwBAAAAGAAAAFNNVFA6TUFLTElORVNSQEhPTUUuQ09NAAsAAQ4AAAAAQAAG
DgBq4NwGW8ABAgEKDgEAAAAYAAAAAAAAAKrUkjtCtb4RkuLy1rTP4+3CgAAACwAfDgEAAAADAAYQ
I6TUMgMABxBBEwAAHgAIEAEAAABlAAAASVRISU5LVEhJU1NZU1RFTUlTU0lNUExZT1ZFUkxPQURF
RCxCVVRJU1RIRVJFTVVDSFRIQVRDQU5CRURPTkVUT0VMSU1JTkFURUxBVENIV0FJVFM/VEhJU0lT
T05WTVNUSElTSQAAAAACAQkQAQAAAJkKAACVCgAADSwAAExaRnX+3qszAwAKAHJjcGcxMjUWMgD4
C2BuDhAwMzNPAfcCpAPjAgBjaArAc/BldDAgBxMCgwBQBFXxAgBwcnESERDnCFUHst8Cgw5QEG8H
bQKDMxIoEy9NFDN9CoAIyCA7CW8wtRofZQ4wNQKACoF2CJCkd2sLgGQ0DGBjAFCDCwMLtSBJIHRo
C4AGax6iBCBzeXN0ZRxtIB8yB3ALUHkgbxZ2BJAJAGEBAGQsIDxidQVAHzEesASQZSCqbR2AaB6h
YQVAYwORGmIh4GQCICHgdG8gfGVsB3ALgCJwIeALYHTFIiF3C3B0cz8V0B8i0x8xAiAgVgXgLiT3
IaE4IGZpERAFQB9lSSf/IIAjgCCBH1AJ4R8EAiAl4NMekCPAZ2gFQHAN4B7wsHVwIGEkJQIgYyHg
ywuAKgF3HsBsZSEUHxM/HzEHQARgJvEn4iBQZGG8eS4KogqECoAN8HUsQdcdQCKQLkBfBaB1AjAq
AM0h0TQl4C16T3IA0CtgljcGUifyUiOQZWERIJAgNy4zMhE2LhFQKC0gUANgZB2AdGk/JYExhS16
NE8KkBICczF+NgYAAZAzIB+ADeAhgWHqawnwOi10LTfPON853ZEtdDExLwHQLzAygQEyoDA5OjIy
OjDqNi16ID1DVyShNkoCEHsFwCaCSQCAAZAqoTzlU/BJRCBFIIAvMUCvQTbAUDFURVhUQT9Buf0y
sDJCb0NPDlA3dzvBR49/SElHb0kfSU9K7zqZPUA0fzYwJDQDUAngRZ89QiDQZBcaMAQRT3sjUdog
bnVPBtAUAVMfU9kzOTzmNf8w8E6fT69Qv1HPUt9T71T2/w9BVa9Wv1fPWN9Z72IPVOf8MjRVn13P
Xt9f72D/aR/nXIAdo2OCNTRj72T/Zg+3Zx9oL3BPM0a1XIA0av//bA9tH24vbz93X3FZcWByL/9z
P3RPdV92b36PYyhVj4FPH3tPfF99b4WPcUkzMTX/gG+Bf4KPg5+Er4zPakeHUP9EUIefiK+Jv4rP
i9+Fz1wX9jlcsAnwcQpQClCT/5a1WyPgB4B8BGKNHDSHYCxQMDUzLIdQOB/AZM9EUJovjViHUDA4

O6BjR/+HcJXflu+X/5kPmh+bL5w28y+QoPBkYiaxK2AoIZ0R+wIwBzEgGjAg0KHmpEKSsP+mX41Z
ISAJACmwpk+NWTww/3IAXCaVkKQPpR+mL5Q8chDjqD+NHDg1MHHwhtc8YL+rL6w/rU+nP69vt1sy
NiD+OAwBcZayOSKgAkAhwS6gP7OKtD+uL6sQtn++jTQ5DjaAQIbnchBTUUwqxwfABUAHgXNhZyND


MMD3CJBAhpDAaSfyoRC3nWrgQiw8MDksNzYRUCO8YnkfkJENtU8tdD3Hb//If8mPyp/Lr8y/zRMt
dDZffzdv0J/RrzqdO1A7pHkQOv9OYDxQqnU87z3/Pw9AH9lP/0I/2X9EX92PRn/fr0xv4I//4g/j
7+NvVQd5P4+vkL+Rz9eS3+vvVNA4Y0Yw5q/nv//oz+nf6u/zD2o5XK/13+/f//Dv8f/6H43KPAD0
//YP9x//+C/5PwFfjelyH/0f/i//P/8ATwhv7QhjobJPs1+7j769c72PD341OU5gPHVjoDd/qx8L
XwxvlC3EkA6PD603/zug1JYWgJwQEX8SjxOfn33jFZ+3fzk4OFwXHuAYn38Zrxq/lDyc0BzPoh4Q
sDL/7SajEBiPIL8hzwGdNjAj7/+3jReRcWbNHy6/L88w3zHvfzL/zc/O38/vNz84TzroN/3Txjc8
IDwQoFDUv9XP1t//1+8/P9oPQV/cL0N/3k/jf/9Gr0XfR49Hv0lfTYuxcQM//wRPBV8Gbwd/Uk/t
FyrQKuB/TR9OL08/UE9RX1JvYzc3/4BfVS9WP1dPWF9gfwmJHvB/Jt8n7yj/D60q/1meJgA2/jft
JyrRYn9jj2SfKh9mv/23nDeVAL/WxEChMGmfaq/fa7++2xWPdb8YYDcmFyYQv3Cfca9yv3PPdN++
vTIVcP+cKKLwd89433nvbL98D6IeT2/Av9a4QV0wc3k98Gggcm9ub3XFAEkv4k/BsG9tcLnAf9CG
gP+hAIewh/+JDsSQii+LP4nx8Ttqc2ZkhoA+FTNvjw//kB+RL5I/k080HzUvNj+Xj/uYn9MYONPF
+/A6oNRAsVD/Ow88Hz0vPj+fj0Bfoa9Cf/+jz0SfSc+m/6Yvp9+oD6mv/eW8NvTvXE9dX15vX3+y
j//7SCXQxJCtb65/r4+wn7Gv/2ePJieFILR/tY+2n7evuL//wN8JmH7Pf9+A77LPgw/FzvkKMDUz
F+dv4MK/w8/E3/dZvcbfgf82GHClhcmRwq+/yt/L72WPzg8Unm/gMtBG/2igd7/R/9MPHd2tQNUv
Hc7+Nm/gb/cKP9kP2h8dzkzw/9xPzO4fgBCATGbJAN8/4E//4V8Nj+N/Fr4XoSY3yc/nX+/ob8Xf
6o8d3TDQENAQCbf/Yl/uf++PHd3N7+lvOuA6IP8ChiaQ9I/1n/av6X/4z+ufVdfwNZu2NB+pY7uw
dP3AAGX9IPz6/a/+z3vf5G//EKAs8H442AkDfwSPDK9hc/cG/91fI7A5F+YVcNUACg+/Cx8ML7L7

1Q8WL9cBOMkm/2igaXkRvxLPGu/Nrx0PHWP9aMA2ySeF74b/IU+LfyJf/yR/jE+NXyevKL8pzyrf
K+//LP+Uz5XfMC8xP6wPOcG0UPk6FjA67VA0QDr/nF+db/+efzjPoJ8676K/PQ+k36Xv/0A/P29B
H0KfQu+sTbt/R4//vZ++r7+/S89aadTwtG9Hr99Iv0nPSt9S/2GZORUgTd+/Tu9P/1EPUh9TL+Wn


MP/A/1T/Vg9XH1gvWT9aT+Wn+sC/XA9dH14vXz9gT2hvM9BG/4Lg+6BjP2RPZV9mb2d/FB/9s8c3
aj9rT2xfbW9uf3af/0z4+JAOAHF/co9zn3Svdb//ds/lprRQgvB4n3mver97z/d8333vd9cwrU+A
r4G/gs//g9+L/3CaRp+Hz4jfie+K//uTH7rJOdgP/L8aT88eHF//Dx8JIMkX3BDfL5YPlx+YL7eZ
P+JdAeA51yDeljTtb/+dL54/1j6gT6huVMCiQSb/f6rPq9+s763/rw8tXzT1XJRjZjSQZiXAZnPf
EZogNKViseAfQFRoISDUa1M1EWuycGKyAyNhRUKwTS7gaGFlpGBBk43wIQBLbCEgZSw2ADxyLrHm
NKWzELQkVGUtjiBuLuCkUUMf0HN1Tmw3cTiwQrAgUrTBbYUf0GS10FZpcmchIPGkQCBPZqOAN6G1
ksKBBxdRszE20G5yaWRnQ6OwuDB1cnQ7tKFk16eANwCkQG65kUHcATNg4jK10FVTQbYQtZKx4Y01
sDqoYtAgNC03+rD+LRUQyPC3Ar4zsbA+0Lhw1bSmLrWDQLNILiBxsnCfsbK4cB/gJtG6s1Bhu+D6
cr7AOOyQv0AQ8L+AFRBfAiWxobIBhrC1MHC04CDLNRDD03fGkC5tIMAfwBe38cEwIHEvw7IuaHSc
bWyxpL/0NzBDUb7A+frROTYQ8LXQ1zDmMLsAdzoju3Am0EaOYclCAeA0X00BtjzFU7RBNQR9NUAA
Ac3AAAAAAwAQEAAAAAADABEQAAAAAAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAD
gAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAABShQAA
1hkAAB4ACIAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguNQALAAyACCAGAAAAAADA
AAAAAAAARgAAAAAGhQAAAAAAAAMADYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAWgAgg
BgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADABeACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAA
AAMAGYAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAogAggBgAAAAAAwAAAAAAAAEYAAAAA
NoUAAAEAAAABAAAAAAAAAB4AKYAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAe
ACqACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwAygAggBgAAAAAAwAAAAAAA
AEYAAAAAgoUAAAEAAAALADSACyAGAAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAsANoALIAYAAAAA
AMAAAAAAAABGAAAAAAWIAAAAAAAAAgH4DwEAAAAQAAAAqtSSO0K1vhGS4vLWtM/j7QIB+g8BAAAA
EAAAAKrUkjtCtb4RkuLy1rTP4+0CAfsPAQAAAFAAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAUFNU
Received on Thu Nov 30 2000 - 13:51:11 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US