Parallel Query, How to determine degree
From: <pp001868_at_interramp.com>
Date: 1996/01/21
Message-ID: <4duio0$5r1_at_usenet6.interramp.com>#1/1
Date: 1996/01/21
Message-ID: <4duio0$5r1_at_usenet6.interramp.com>#1/1
We have just migrated to an IBM SMP box and would like to try using the parallel query portion of Oracle. As usual the Oracle Docs. are not clear on how to set the degree parameter for the tables.
Our tables are quite large 70 to 80 million rows. Has any one found a formula or a rule of thumb on how to set this.
I have only heard of one, which was to keep increasing the number until it fails. That is not aceptable.
Thanks in advance.
Robert C, Obenour
CDS Received on Sun Jan 21 1996 - 00:00:00 CET