Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9.2.0.4 experiences
James Williams wrote:
>On Wed, 03 Sep 2003 22:40:50 -0600, Ron Reidy <r_reidy_at_comcast.net>
>wrote:
>
>Well I ran stats pack and 10046 traces.
>
>On Solaris 2.8 I have 5 instances on a server. 4 instances where okay
>and had optimizer_mode=choose. 1 instance had
>optimizer_mode=first_rows.
>
>Query runs fine with optimizer_mode=choose but not with
>optimizer_mode=goal. Obviously something with the optimizer changed
>between 9.2.0.4 and 9.2.0.3
>
>dbms_stats are current.
>
>I am currently evaluating 10046 before and after traces and
>statspack.
>
>When I get back to work I will post before and after as with a quick
>scan both exection plans look the same except for the results!!!!
>
>
>
>>I have no problems with my testing using 9.2.0.4.0. What do you mean
>>"hangs"? What is going on in the instance (statspack reports, 10046
>>tracing, etc.)?
>>
>>James Williams wrote:
>>
>>
>>>I have installed 9.2.0.4 on some test machines. I seem to have some
>>>intermittent process hangs since. Anyone experienced such?
>>>
>>>Still in analysis.
>>>
>>>
>>--
>>Ron Reidy
>>Oracle DBA
>>
>>
>>
I just upgraded my W2K SP6 machine from 9.2.0.2 to 9.2.0.4.
Nothing appears to have changed that would mirror your experience.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sat Sep 06 2003 - 23:22:04 CDT