Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help With INIT.ORA
Looked into this myself in the past briefly.
Two conclusions:
Oracle will discover the dual processor automatically (and change to
cpu_count parameter when you look at show parameter in server manager).
Parallelization in this case is more or less automatic.
As you need to specify the minimum and maximum number of cpus involved, I
don't see much in trying to do this with only two cpu's. And my query paths
proved to be getting worse because the parallels intermediate results need
to be combined afterwards, which means an extra pass.
The following book
Guy Harrison Oracle High Performance Tuning published by Prentice Hall
covers parallel query in depth
Hth
Sybrand Bakker
EXE wrote:
> I am currently working with a group deploying an accounting system based
> on Oracle 8.0.4 on an NT 4.03 server with 1GB memory and two CPUs. The
> total number of users on the system will be about 200. The server will
> also need to host a test instance for pre-deployment testing of
> third-party tools and bug-fixes. The front-end will be Developer/2000
> Forms 4.5 and 5.0.
>
> Any pointers on init.ora parameters will be appreciated: Especially any
> involving parallel query or other parameters that might help boost
> performance. I wish this was on a UNIX box but alas contractors can't
> dictate everything to their liking.
>
> Thanks,
>
> Daniel A. Morgan
Received on Mon Aug 17 1998 - 12:47:51 CDT