Mateus Morato

From: Mateus <mateus_at_cadsoft.com.br>
Date: 10 Jun 2003 12:11:57 -0700
Message-ID: <6785c818.0306101111.3d20d161@posting.google.com>

I am having some problems on my Oracle 8.1.7. I server is a IBM PSeries 610.
It seems to be very slow and I don't know why. I ran this sql command:

SELECT SUBSTR(name,1,25), gets, misses,

          immediate_gets, immediate_misses    FROM V$LATCH
  WHERE misses > 0 OR immediate_misses > 0     AND name LIKE 'library cach%';

and got the following result

SUBSTR(NAME,1,25) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES
------------------------- ---------- ---------- --------------

---

latch wait list 252354 15 252458  4
session allocation 932718 29 0  0
session idle bit 92899493 1599 0  0
longop free list 61190 4 0  0

messages                     2171292         12            0          
 0
enqueues                     8059446         29            0          
 0
enqueue hash chains          5241381         47            0          
 0
cache buffers lru chain     29717145        108         1376          
 0
cache buffers chains      5444472962     290448       470454          
 73
cache buffer handles         7009923         11            0          
 0
redo allocation              4901405        104            0          
 0
redo copy                        142          1      4067754          
 1463
redo writing                 1776865         96            0          
 0
loader state object freel    9245708        135            0          
 0
dml lock allocation          1510800          1            0          
 0
transaction allocation       1996664          6            0          
 0
transaction branch alloca     842625          2            0          
 0
sort extent pool              819891         15            0          
 0
undo global data             2198036          3            0          
 0
sequence cache                149842          2            0          
 0
row cache objects         1456492794     119082       256360          
 6154
user lock                      76954          8            0          
 0
shared pool                338616150      73825            0          
 0
library cache              384166092     175086       175654          
 369
virtual circuit buffers    414665610      25193            0          
 0
virtual circuit queues     319578676      17642            0          
 0
virtual circuits            78401203       4306            0          

 0

What's wrong with this server? I don't know why de misses is so high. Where can I find some info about it. Any clues???????? Received on Tue Jun 10 2003 - 14:11:57 CDT