Parallel Server and Parallel Query

First Question:

When Oracle does a parallel query operation, how does it determine how to divide up the data between the query processors? Data location, data values? What?

Second Question:

When using parallel server option, you must use raw devices. You create a logical volume on one physical disk or across many physical disks. If you create a lv across many physical disks and use this lv as the datafile when creating the tablespace, does Oracle know how many physical disks the tablespace spans? If it does, then how does it know?

I ask this question because we are using the parallel server option and are considering using parallel query on some of our SQL. If Oracle can't detect the physical disks in a tablespace, then it might not be a good idea to use parallel query because it is really important to know where your data is sitting. Does anyone have experience with this?

Second Question, part 2:

Has anyone done any Oracle striping on a raw device before? I know that this could be very expensive (disk-wise), but we may need to do it anyway. I would appreciate any comments on how you did this and any other experience you had with this.

I can receive e-mail and read this newsgroup, but I can't e-mail out from this site so I thank anyone in advance for any information they submit.

Doris Jetz
Consultant. Received on Wed Mar 05 1997 - 00:00:00 CST