Re: is this an appropriate case for parallel processing?

"JustAnotherDBA" <burttemp1REMOVE_THIS_at_bellsouth.net> wrote in message news:tXDxa.4260$vo6.1882_at_fe05.atl2.webusenet.com...
>
> 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?
> >
> >
>
>
>

I dont know what the server is. I know we have Solaris 5.8 because I see it when I log in. Im a developer. I dont know the hardware. Some of our batches take 2-4 hours to do. I've tuned them to get done in 30-40 minutes or less. Id like to squeeze a little more. Might not be able to. Its not a necessity, just makes things easier. The files we have to process sometimes come in late. So we dont always have a nice cushion to do the processing.

Not really practically to stripe the tables, indices, since we using transportable tablespaces and dont want to introduce additional datafiles to move. We want to be conservative here, just to be safe. So my options are limited. So just tossing out ideas.

Thanks Received on Sun May 18 2003 - 18:19:07 CDT