Re: Oracle with multiple CPUs

May I ask you just another basic question, please?

Do you have the parallel query option?
(you can verify this by issuing select * from v$option)

If not, just nothing will happen.

If you do have the parallel query option basically there are three levels of parallelism: database wide (set in init.ora)
table specific (set at table creation or by means of alter table) statement specific by using hints.
So the answer to the first question is
it depends. Do you want *all* your operations in parallel To the second question is:
apart from any NT scheduling mechanism you won't see any benefit And to the second question is: yes, of course.

Hth,

Sybrand Bakker, Oracle DBA

<gdas_at_my-deja.com> wrote in message news:8pjck2$4qh$1_at_nnrp1.deja.com...
> Hi, I apologize if these questions seem basic...
>
> We currently have an Oracle test/development database running on a
> single processor Windows NT Server. We have a new machine coming soon
> which is a dual processor NT box, but is expandable to up to 4 CPUs. I
> am hoping to move the database to this new machine and I am trying to
> assess what I will need to do in order for oracle to take advantage of
> the additional processor. I have 3 specific questions:
>
> 1. Will I need to change/set any of the init.ora parameters?
> 2. Currently none of my tables were created using any specified degree
> of parallelism. If I migrate the data to the new instance as is
> (without any degree of parallelism) and don't change the application
> code at all to send parallel hints, will I still see some benefit from
> the additional processor?
> 3. Can I use parallel hints in SQL, even if the underlying tables were
> not created with any parallel clause?
>
> Thanks in advance for any tips,
>
> Gavin
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Sep 11 2000 - 17:28:56 CDT