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: Need assistance for tuning

Re: Need assistance for tuning

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Sat, 12 Aug 2006 11:06:50 GMT
Message-Id: <pan.2006.08.10.13.46.15.174476@sbcglobal.net> 





On Thu, 10 Aug 2006 03:20:57 -0700, Giridhar wrote:



> 

> How can we find out what is the reason for this discrepancy?

> 

> Thanks.





Turn on 10046, lev. 12 and if that doesn't help, 10053, lev. 1. Event
10053 will also give everything in the environment that might influence
optimizer to chose a different path.


-- 
http://www.mgogala.com


Received on Sat Aug 12 2006 - 06:06:50 CDT












Original text of this message













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