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.
Received on Mon Jul 30 2007 - 18:35:30 CDT
