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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jul 30 2007 - 18:20:19 CDT
