From: AMinocha@herold.com (Anurag Minocha) Newsgroups: comp.databases.oracle.server Subject: Re: Re: High Redo Copy Contention Date: Wed, 4 Apr 2001 13:35:43 +0000 (UTC) Organization: Mailgate.ORG Server - http://www.Mailgate.ORG Lines: 24 Message-ID: NNTP-Posting-Host: jshemail.herold.com Mime-Version: 1.0 Content-Type: text/plain; X-Trace: news.mailgate.org 986391343 10804 63.105.8.12 (Wed, 4 Apr 2001 09:37:19 -0400 ) X-Complaints-To: jshemail.herold.com@abuse.net abuse@mailgate.org NNTP-Posting-Date: Wed, 4 Apr 2001 13:35:43 +0000 (UTC) Mail-From: AMinocha@herold.com from jshemail.herold.com [63.105.8.12] X-URL: http://www.Mailgate.ORG 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