Re: obvious bugs with 10.2.0.2 and aix5L

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 1 Aug 2007 11:08:09 +0200
Message-ID: <46b04d71$0$245$e4fe514c@news.xs4all.nl>

"DA Morgan" <damorgan_at_psoug.org> schreef in bericht news:1185887320.652131_at_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

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

Shakespeare
(What's in a code?) Received on Wed Aug 01 2007 - 04:08:09 CDT