Re: obvious bugs with 10.2.0.2 and aix5L

"Ben" <balvey@xxxxxxxxxxx> wrote in message
news:1185834194.543350.252940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Jul 30, 6: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.

dbms_xplan.display_cursor and dbms_xplan.display_awr are your friends.
Get to know them but be sure you can do so legally.
--
Daniel A. Morgan
University of Washington
damor...@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

The main issue is that our execution plans have stayed the same but
now all of the sudden our server doesn't have the resources ( mainly
CPU ) to handle our load. bugs that I have found related to poor
performance but not necissarily related to our individual issue.
5692368, Bug#5545550 Bug#5582396, 4745313, 5055175


Hi Ben

We're on 10.2.0.3 on AIX 5.3 and have hit some rather odd bugs that have the
net result of excessive CPU consumption. Basically execution plans when
explained seem perfectly reasonable but when you trace the session
themselves have totally different and highly inefficient plans instead. The
problem appears to be related to statements executed through PL/SQL packages
that reference partitioned objects.

Our bandaid fix at the moment is to create stored outlines based on the
native explain plans. Currently in discussion with Oracle Support regarding
getting the issue addressed.

Cheers

Richard



.

Relevant Pages

  • Re: Server unexpect shutdown
    ... Oracle 10.2.0.4 ... ACPI: Processor ... checking if CPU frequency changed. ... microcode: CPU0 already at revision 0x16 ...
    (comp.databases.oracle.server)
  • Re: AWR Sample Report
    ... Did you find that when it was set to TRUE Oracle was generating bad ... the introduction of CPU costing, which is enabled by default on Oracle ... Enables the enforcement of resource limits. ... although looking at an AWR report for a 31.2 second time period might ...
    (comp.databases.oracle.server)
  • Re: V$ Views
    ...  Remember, Oracle has its process id, while the OS has ... Oracle refers to a CPU TIME & ELAPSED TIME. ... ELAPSED TIME is the time the process has been running. ... The CPU statistic is reporting the actual CPU time to the nearest ...
    (comp.databases.oracle.misc)
  • Re: Comparisons Oracle 11.1.0.7 to Oracle 10.2.0.4
    ... Yes, it is true, there are normally nested loops in these execution plans. ... which are enabled by default from Oracle ... Can you provide an example of an execution plan with default settings ...
    (comp.databases.oracle.server)
  • Re: MEMORY ISSUE
    ... If your box starts swapping, I/O wait will be high as your disks are saturated with the task of swapping stuff in and out of RAM plus whatever non swap I/O you might be doing from other processes at the time. ... CPU states: cpu user nice system irq softirq iowait idle ... of the number of Oracle threads or other processes, ...
    (RedHat)