Re: is this an appropriate case for parallel processing?

Just how bad or poor performing is the current setup?

How old is the hardware?

Also, I have never heard of Solaris v5.8 ... did you mean 2.8 (or commonly called Solaris 8)? If so, that isn't antique.

Do you load with indexes or primary or unique keys enabled?

What kinds of steps have you taken to help the poor performance so far?

-- 

"Ryan" <rgaffuri_at_cox.net> wrote in message
news:a%cxa.18856$823.18445_at_news1.east.cox.net...


> We have an instance run in Oracle 8173 on a Solaris v5.8(yes I know its

> antiquated) with 4 CPUs using a Network Appliance hard disk array.

>

> SQLLOAD into a staging tablespace. Insert append and a create table AS.

>

> We have 5-6 tables over 100 MBs and the largest is 1GB. We have up to 73

> tables that we have to batch process in a night. We rarely run all of them

> and about 40 of them are less than 10MBs some less than 100k.

>

> I was thinking of using parallel inserts,create table as,parallel index

> building, parallel in a hash_aj we need to do. Im also going to use

DBMS_JOB


> to create indices, since talbes have multiple indices, if I run them with

> DBMS_JOB I can do all of them at the same time.

>

> how do I determine whether parallel processing will suck up too many

> resources? Cant run it and see what happens because it has to succeed. I

can


> test it on a Saturday, but Id prefer not to blow a Saturday if this is

> totally going in the wrong direction.

>

> We currently have MAX Slaves set to 5, and Threads per CPU set to 2. Not

too


> familiar with Parallel queries. Just started looking at it.

>

> Anyone have any advice on this?

>

>