Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: obvious bugs with and aix5L

Re: obvious bugs with and aix5L

From: DA Morgan <>
Date: Mon, 30 Jul 2007 16:20:19 -0700
Message-ID: <>

Ben wrote:
> On Jul 30, 6:20 pm, joel garry <> wrote:

>> On Jul 30, 3:01 pm, DA Morgan <> 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, 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
>> --
>> is bogus.
>> Bow down to your household gods:

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

Original text of this message