Re: Re: High Redo Copy Contention

From: Anurag Minocha <AMinocha_at_herold.com>
Date: Wed, 4 Apr 2001 13:35:43 +0000 (UTC)
Message-ID: <EBBA6D3A81229C42981E3AEA79BF5A4E111264@jshemail.herold.com>

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 - 08:35:43 CDT