Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Parallel Query Option
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_at_thehartford.com
Received on Mon Mar 03 1997 - 00:00:00 CST