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
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org