Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 10046 trace: 'latch free' then 'db file seq. read' waits

Re: 10046 trace: 'latch free' then 'db file seq. read' waits

From: Spendius <spendius_at_muchomail.com>
Date: 15 Jun 2006 23:43:52 -0700
Message-ID: <1150440232.542262.12050@c74g2000cwc.googlegroups.com> 





joel garry a écrit:

>




> Conversely, maybe you have the same number of very hot blocks that are

> the last few that the scan needs, and everybody is fighting to get them

> to see the data in their own consistent way?




That's what I guess too of course, but


o I'd like to be able to verify it,


o and answer this question: why are these last records to be displayed
  *always* located in these assumingly hot blocks ?



Thanks.
Received on Fri Jun 16 2006 - 01:43:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US