Re: Re: High Redo Copy Contention

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 4 Apr 2001 15:04:32 +0100
Message-ID: <986392942.6918.0.nnrp-01.9e984b29@news.demon.co.uk>

Can you re-run that query but issue:

column immediate_gets format 999,999,999,999

before you do so, so that we can see how many immediate gets have occurred - all we can tell is that it is over 10,000,000. Also you might work out

number of logswitches x number of redo copy latches

and compare it with the number of redo copy latch gets.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Anurag Minocha wrote in message ...


>Hi,

>The numbers for the actual gets and misses are also high. Below is the

 query


>I ran to generate the numbers.

>

>Please Help.

>

>select name,       gets, misses,

>  2      immediate_gets,  immediate_misses, sleeps

>  3  from   v$latch

>  4  where  name in ('redo allocation',  'redo copy')  ;

>

>  Tablespace        GETS   MISSES IMMED GETS IMMED MISS  SLEEPS

>--------------- -------- -------- ---------- ---------- -------

>redo allocation ########    13176          0          0     814

>redo copy          27093    26585   ########      56439     442

>

>Thanks

>Anurag

>

>

>

>--

>Posted from jshemail.herold.com [63.105.8.12]

>via Mailgate.ORG Server - http://www.Mailgate.ORG

Received on Wed Apr 04 2001 - 09:04:32 CDT