Re: Mateus Morato

Use Oracle utility statspack as a starting point. Search google for "statspack" and "oracle".

tahiti.oracle.com - for Oracle manual -> performance

Anurag

"Mateus" <mateus_at_cadsoft.com.br> wrote in message news:6785c818.0306101111.3d20d161_at_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 Wed Jun 11 2003 - 01:43:59 CDT