extended run time with parallel query on.

From: <akudirka_at_my-dejanews.com>
Date: Mon, 29 Mar 1999 15:15:22 GMT
Message-ID: <7do5e2$9e7$1@nnrp1.dejanews.com>

I have several batch jobs where their run times increased by as much as 400% when I made tables eligible for query parallelism. Has any one seen that same behavior and found a solution?
Sun sparc 2000 2.5.1 with 16 processors, 5 gig rollbacks, gig memory, degree 4 - instance 2. Some of the queries are doing table scans. Avg. table size 2.5 gig. Oracle 7.3.4
Init settings = engueue resource 5000, processes 1500

Cheers.

Also send replies to amos.kudirka_at_firstdatacorp.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 29 1999 - 09:15:22 CST