Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

Re: obvious bugs with 10.2.0.2 and aix5L

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 30 Jul 2007 16:20:19 -0700
Message-ID: <1185837617.185595@bubbleator.drizzle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US