On Jul 30, 6: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.
>
> 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..._at_x.washington.edu (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
Received on Mon Jul 30 2007 - 17:23:14 CDT
