Re: PQO on Oracle 8.05 for NT4

Lo,

This depends on the queries that you are executing. Have you checked the execution path? Do you have enough memory to sort, are the tablespaces spanning multiple spindles ?

I mention this because I had a similar problem, with PQO making no immediate difference, then rejigged(?) the sql and got a 10 fold improvement.

Chris.

Lo wrote:
>
> Hi,
>
> I've been monitoring queries against our data warehouse which sits on a 4
> cpu pentium pro 200 box and noticed that when pqo is in progress, the
> queries take longer to run than when a single cpu services the query. This
> happens when there are more than one user running queries. As a result I
> have had to turn degree back to 1.
>
> I've looked at the bstat/estat statistics and everything looks fine -
> minimal contention, minimal waits, high cache hit rates, adequate sorts in
> memory etc.
>
> Has anyone else had similar experiences with PQO on NT4 ?
>
> I am hoping that the 8.0.5.1.1 patch will improve things.
>
> Thanks,
> Kevin
Received on Tue Feb 09 1999 - 17:13:12 CST