Re: obvious bugs with 10.2.0.2 and aix5L

"Ben" <balvey_at_comcast.net> wrote in message news:1185834194.543350.252940_at_q75g2000hsh.googlegroups.com...
> On Jul 30, 6:01 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Ben wrote:
>> > anyone aware of any obvious bugs that myself and oracle and two other
>> > consultants might be over looking that could cause high cpu usage with
>> > oracle ent ed, 10.2.0.2 on aix5l systems?
>>
>> Gee why don't you list all of the bugs that, collectively, all of you
>> are aware of and we'll fill in the gaps.
>>
>> Sorry to say it but your request, while I understand the point of your
>> question, is not going to bear ripe fruit.
>>
>> If Oracle's helping they can use AWR and ASH to identify the sessions
>> and workload. From that you can track down what about those specific
>> items can be altered.
>>
>> dbms_xplan.display_cursor and dbms_xplan.display_awr are your friends.
>> Get to know them but be sure you can do so legally.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org
>
> The main issue is that our execution plans have stayed the same but
> now all of the sudden our server doesn't have the resources ( mainly
> CPU ) to handle our load. bugs that I have found related to poor
> performance but not necissarily related to our individual issue.
> 5692368, Bug#5545550 Bug#5582396, 4745313, 5055175
>

Hi Ben

We're on 10.2.0.3 on AIX 5.3 and have hit some rather odd bugs that have the net result of excessive CPU consumption. Basically execution plans when explained seem perfectly reasonable but when you trace the session themselves have totally different and highly inefficient plans instead. The problem appears to be related to statements executed through PL/SQL packages that reference partitioned objects.

Our bandaid fix at the moment is to create stored outlines based on the native explain plans. Currently in discussion with Oracle Support regarding getting the issue addressed.

Cheers

Richard Received on Tue Jul 31 2007 - 08:22:51 CDT