Re: obvious bugs with 10.2.0.2 and aix5L

Ben wrote:
On Jul 30, 6:20 pm, joel garry <joel-ga...@xxxxxxxx> wrote:
On Jul 30, 3:01 pm, DA Morgan <damor...@xxxxxxxxx> 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@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: obvious bugs with 10.2.0.2 and aix5L
    ... 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 ...
    (comp.databases.oracle.server)
  • Re: obvious bugs with 10.2.0.2 and aix5L
    ... consultants might be over looking that could cause high cpu usage with ... If Oracle's helping they can use AWR and ASH to identify the sessions ... Search MMON in the bug database. ...
    (comp.databases.oracle.server)
  • Re: obvious bugs with 10.2.0.2 and aix5L
    ... consultants might be over looking that could cause high cpu usage with ... oracle ent ed, 10.2.0.2 on aix5l systems? ...
    (comp.databases.oracle.server)
  • obvious bugs with 10.2.0.2 and aix5L
    ... 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? ...
    (comp.databases.oracle.server)