From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Re: High Redo Copy Contention Date: Wed, 4 Apr 2001 15:04:32 +0100 Message-ID: <986392942.6918.0.nnrp-01.9e984b29@news.demon.co.uk> References: NNTP-Posting-Host: jlcomp.demon.co.uk X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 X-Trace: news.demon.co.uk 986392942 nnrp-01:6918 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 54 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