Re: Maxing CPU

Wayne S. March wrote:
>
> To All,
>
>
> Now when 10 or so users run reports I sometimes notice that Oracle is
> running all
> four cpus at 100%..Any Ideas
>
> Wayne

Wayne,
from my experience as a data warehouse expert, it looks like the optimizer ignored some (all) indexes (if there are any). Use tkprof to analyze the situation (if you can enable sql trace in your reports).

Happy computing
Kai
--
Unix, WinNT and MS-DOS. The Good, The Bad and The Ugly.

Kai Poitschke       MailTo:kai.poitschke[at]computer.org
Sülzburgstr. 17     Phone : +49 (0) 221 / 42 21 07
D-50937 Köln        Fax   : +49 (0) 221 / 9 41 61 44