Shakespeare wrote:
> "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?)
That is what some of us do on consulting gigs: CREATE AND REPLACE. <g>
--
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 Wed Aug 01 2007 - 08:31:45 CDT
