Re: obvious bugs with 10.2.0.2 and aix5L

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 31 Jul 2007 06:08:42 -0700
Message-ID: <1185887320.652131@bubbleator.drizzle.com>

Ben wrote:

> On Jul 30, 7:20 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> Ben wrote:

>>> On Jul 30, 6:20 pm, joel garry <joel-ga..._at_home.com> wrote:

>>>> On Jul 30, 3: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.
>>>> 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/uniontrib/20070729/news_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..._at_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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jul 31 2007 - 08:08:42 CDT