Re: obvious bugs with 10.2.0.2 and aix5L
- From: Noons <wizofoz2k@xxxxxxxxxxxx>
- Date: Wed, 01 Aug 2007 04:17:44 -0700
On Jul 31, 7:32 am, Ben <bal...@xxxxxxxxxxx> 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?
there is a pre-requisite set of patches for aix 5L (5.3)
and one patch for Oracle 10.2.0.2 which you *must* install.
Assuming that has been done, there are a number
of additional patches and settings that sometimes
help in stabilizing queries gone mad.
But that is very much dependent on what features
you are using:
Is this a case of heaps of SQL gone crazy or just
a few?
Views within views within views?
Very complex subqueries with lots
of (select max(blah)...)?
There are some known problems in these areas
with 10.2.0.2.
Have a look at some of the docs in Metalick
on tuning for 10.2.0.2 and Oracle Apps: it
also applies to some of the other third party
(well, JDE is not 3rd party anymore...) apps.
I'm not in the office at the moment so I can't
check actual numbers but I may be able to pull
in some additional info tomorrow AEST.
.
- Follow-Ups:
- Re: obvious bugs with 10.2.0.2 and aix5L
- From: Ben
- Re: obvious bugs with 10.2.0.2 and aix5L
- Prev by Date: Re: deleted undotbs01.dbf...
- Next by Date: Re: Upgrading from solaris 9 to solaris 10. Oracle issues????
- Previous by thread: Re: obvious bugs with 10.2.0.2 and aix5L
- Next by thread: Re: obvious bugs with 10.2.0.2 and aix5L
- Index(es):
Relevant Pages
|
