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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Latch Free Problem - Need Help

Re: Latch Free Problem - Need Help

From: Sandy Druar <sdruar_at_eckerd.com>
Date: Wed, 30 Aug 2000 15:42:48 -0400
Message-Id: <10604.115913@fatcity.com> 





Diana,



I tried using a hint to force the index to be used, but
it changed the explain plan from hash join to 3 nested loops
with the index.  We are still getting Latch Free.



I will try using the between.



Any ideas will be more than helpful.



Thanks,


Sandy Druar


Oracle DBA


sdruar_at_eckerd.com
Received on Wed Aug 30 2000 - 14:42:48 CDT












Original text of this message













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