Re: Performance Problems w/ 7.0.16.6

Tony Uliano wrote:
>
> I have run into a very strange problem, that I would very much
> appreciate some help with.
>
> I have a client that is running HP-UX 9.0 and Oracle 7.0.16.6 on
> an HP T-500. I have noticed a well above average percentage of
> system time being used versus user time. When I run large
> queries, I see the system space utilization of the CPUs shoot up,
> but I should see user space utilization increase in subsequent
> trials.
>
> Any help that someone could give me would be great. you can
> either e-mail via Compuserve "717102, 57" or my e-mail address:
> auliano_at_amconsulting.com, or call me at (804)777-9310.
>
> Thanks in advance.
>
> Regards,
> Tony Uliano
> AM Consulting, L.L.C.
> (804)777-9310

Check the temporary tablespace assignment for the user that is running the query, it may be set to system. Received on Mon Jul 22 1996 - 00:00:00 CEST