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?

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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jul 30, 3:01 pm, DA Morgan <damor...@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.

And of course, the irony would be if it is AWR and ASH that are the
problem. Search MMON in the bug database. Which process has the high
cpu, Ben?

jg
--
@home.com is bogus.
Bow down to your household gods: http://www.signonsandiego.com/uniont...s_1b29bmw.html

On Jul 30, 6:01 pm, DA Morgan <damor...@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...@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

On Jul 30, 6:20 pm, joel garry <joel-ga...@home.com> wrote:
> On Jul 30, 3:01 pm, DA Morgan <damor...@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.
>
> And of course, the irony would be if it is AWR and ASH that are the
> problem. Search MMON in the bug database. Which process has the high
> cpu, Ben?
>
> jg
> --
> @home.com is bogus.
> Bow down to your household gods: http://www.signonsandiego.com/uniont...s_1b29bmw.html






I should probably state that our database is pretty standard in that
we don't have RAC and we don't use partioning. Pretty much a bunch of
heap tables and b-tree indexes.

When looking at awr reports and long running processes the first thing
that always pops out is the amount of physical reads that we have
going on, sequential mainly but also scatterd. That has always been
the case though on 9.2 also. JDE code and database design is not very
efficient but our server has been able to handle it fairly well until
now.

Ben wrote:
> On Jul 30, 6:20 pm, joel garry <joel-ga...@home.com> wrote:
>> On Jul 30, 3:01 pm, DA Morgan <damor...@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.
>> And of course, the irony would be if it is AWR and ASH that are the
>> problem. Search MMON in the bug database. Which process has the high
>> cpu, Ben?
>>
>> jg
>> --
>> @home.com is bogus.
>> Bow down to your household gods: http://www.signonsandiego.com/uniont...s_1b29bmw.html
>
> I should probably state that our database is pretty standard in that
> we don't have RAC and we don't use partioning. Pretty much a bunch of
> heap tables and b-tree indexes.
>
> When looking at awr reports and long running processes the first thing
> that always pops out is the amount of physical reads that we have
> going on, sequential mainly but also scatterd. That has always been
> the case though on 9.2 also. JDE code and database design is not very
> efficient but our server has been able to handle it fairly well until
> now.

9i to 10g eh. Hints? Strip them all out and see what happens. Things
that work the same way in 10g as they did in 9i are probably not what
you want.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jul 30, 7:20 pm, DA Morgan <damor...@psoug.org> wrote:
> Ben wrote:
> > On Jul 30, 6:20 pm, joel garry <joel-ga...@home.com> wrote:
> >> On Jul 30, 3:01 pm, DA Morgan <damor...@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.
> >> And of course, the irony would be if it is AWR and ASH that are the
> >> problem. Search MMON in the bug database. Which process has the high
> >> cpu, Ben?
>
> >> jg
> >> --
> >> @home.com is bogus.
> >> Bow down to your household gods: http://www.signonsandiego.com/uniont...s_1b29bmw.html
>
> > I should probably state that our database is pretty standard in that
> > we don't have RAC and we don't use partioning. Pretty much a bunch of
> > heap tables and b-tree indexes.
>
> > When looking at awr reports and long running processes the first thing
> > that always pops out is the amount of physical reads that we have
> > going on, sequential mainly but also scatterd. That has always been
> > the case though on 9.2 also. JDE code and database design is not very
> > efficient but our server has been able to handle it fairly well until
> > now.
>
> 9i to 10g eh. Hints? Strip them all out and see what happens. Things
> that work the same way in 10g as they did in 9i are probably not what
> you want.
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -

erp doesn't have any hints that I have ever seen in the sql that is
generated. I have seen some recursive sql that have hints but that is
there by design of oracle, I'm assuming.

Ben wrote:
> On Jul 30, 7:20 pm, DA Morgan <damor...@psoug.org> wrote:
>> Ben wrote:
>>> On Jul 30, 6:20 pm, joel garry <joel-ga...@home.com> wrote:
>>>> On Jul 30, 3:01 pm, DA Morgan <damor...@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.
>>>> And of course, the irony would be if it is AWR and ASH that are the
>>>> problem. Search MMON in the bug database. Which process has the high
>>>> cpu, Ben?
>>>> jg
>>>> --
>>>> @home.com is bogus.
>>>> Bow down to your household gods: http://www.signonsandiego.com/uniont...s_1b29bmw.html
>>> I should probably state that our database is pretty standard in that
>>> we don't have RAC and we don't use partioning. Pretty much a bunch of
>>> heap tables and b-tree indexes.
>>> When looking at awr reports and long running processes the first thing
>>> that always pops out is the amount of physical reads that we have
>>> going on, sequential mainly but also scatterd. That has always been
>>> the case though on 9.2 also. JDE code and database design is not very
>>> efficient but our server has been able to handle it fairly well until
>>> now.
>> 9i to 10g eh. Hints? Strip them all out and see what happens. Things
>> that work the same way in 10g as they did in 9i are probably not what
>> you want.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor...@x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -
>
> erp doesn't have any hints that I have ever seen in the sql that is
> generated. I have seen some recursive sql that have hints but that is
> there by design of oracle, I'm assuming.

Then take a good look at your best friend in 10g ... DBMS_ADVANCED_REWRITE.

Your opportunity to fix other people's production code without having
access to it.

Demo at: http://www.psoug.org/reference/dbms_adv_rewrite.html
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

"Ben" <balvey@comcast.net> wrote in message
news:1185834194.543350.252940@q75g2000hsh.googlegr oups.com...
> On Jul 30, 6:01 pm, DA Morgan <damor...@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...@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

"DA Morgan" <damorgan@psoug.org> schreef in bericht
news:1185887320.652131@bubbleator.drizzle.com...
> Ben wrote:
>> On Jul 30, 7:20 pm, DA Morgan <damor...@psoug.org> wrote:
>>> Ben wrote:
>>>> On Jul 30, 6:20 pm, joel garry <joel-ga...@home.com> wrote:
>>>>> On Jul 30, 3:01 pm, DA Morgan <damor...@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.
>>>>> And of course, the irony would be if it is AWR and ASH that are the
>>>>> problem. Search MMON in the bug database. Which process has the high
>>>>> cpu, Ben?
>>>>> jg
>>>>> --
>>>>> @home.com is bogus.
>>>>> Bow down to your household gods:
>>>>> http://www.signonsandiego.com/uniont...s_1b29bmw.html
>>>> I should probably state that our database is pretty standard in that
>>>> we don't have RAC and we don't use partioning. Pretty much a bunch of
>>>> heap tables and b-tree indexes.
>>>> When looking at awr reports and long running processes the first thing
>>>> that always pops out is the amount of physical reads that we have
>>>> going on, sequential mainly but also scatterd. That has always been
>>>> the case though on 9.2 also. JDE code and database design is not very
>>>> efficient but our server has been able to handle it fairly well until
>>>> now.
>>> 9i to 10g eh. Hints? Strip them all out and see what happens. Things
>>> that work the same way in 10g as they did in 9i are probably not what
>>> you want.
>>> --
>>> Daniel A. Morgan
>>> University of Washington
>>> damor...@x.washington.edu (replace x with u to respond)
>>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>>
>>> - Show quoted text -
>>
>> erp doesn't have any hints that I have ever seen in the sql that is
>> generated. I have seen some recursive sql that have hints but that is
>> there by design of oracle, I'm assuming.
>
> Then take a good look at your best friend in 10g ...
> DBMS_ADVANCED_REWRITE.
>
> Your opportunity to fix other people's production code without having
> access to it.
>
> Demo at: http://www.psoug.org/reference/dbms_adv_rewrite.html
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

mmmm, do you know of anything like DBMS_ADVANCED_RECODE for fixing badly
coded pl/sql as well?

Shakespeare
(What's in a code?)