PQO on Oracle 8.05 for NT4

From: Lo <lo_at_tig.com.au>
Date: Tue, 9 Feb 1999 21:07:41 +1100
Message-ID: <79p1g0$1dm$1@toto.tig.com.au>

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 - 04:07:41 CST