From: erenner932@aol.com (ERenner932)
Subject: Parallel Query Option
Date: 1997/03/03
Message-ID: <19970303205900.PAA29610@ladder02.news.aol.com>#1/1
Organization: AOL http://www.aol.com
Newsgroups: comp.databases.oracle.server
X-Admin: news@aol.com



In creating a table using PARALLEL (DEGREE N) and setting the MINEXTENTS
to N, shouldn't this table be creating in N extents across N files, as
defined within the tablespace?
Example:
I have a tablespace set up such that each datafile is on 6 seperate
spindles.  I create a table with minextents 6 and parallel 6.  This
creates 1 extent in file A, and the other 5 in file B (vs. 1 in B, 1 in C,
1 in D, etc.).  
Why is this?  I thought the premise of parallel query was to evenly
distribute your data across spindles as a multiple of your CPU's (which I
have 6)?
This is running rdbms v7.2.2.4 and HPv9.0.4/
Thanks!
Ernst Renner
erenner@thehartford.com