Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Strange behaviour when using parallel
Hi Joe,
Each of the processes in a parallel operation can be assigned to a different RBS. That's fine (advantages) as it reduces the load on just one poor RBS handling everything.
I'm not sure what you mean by it should only use the temp tablespace. The index is being created in the indx tablespace, this is where I would expect the new object to be created. The new index begins life as a temp segment but in this case indx tablespace is it's womb.
There should be no additional I/O per se with performing this in parallel (just I/O being performed in a hopefully parallel manner).
Cheers
Richard
"Joe Bayer" <u705413818_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.1023999497.1448730468@[64.94.198.252]...
> Thank for those who helped me to solved puzzal.
>
> I have another question,
> Here is my create index statement
>
> create index sensor_data
> on sensor_data_2000 (data_id,sensor_id)
> local
> storage (initial 200m next 200m pctincrease 0)
> tablespace indx
> nologging
> parallel (degree 2)
>
> To my surprise, I found that there are two sessions which is using
> rollback segment, is it something strange?
>
> I thought create index only use temp tablespace. Is it because of
> the parallel? Will it slow down because of the extra I/O?
>
> Thanks for your help.
>
>
>
>
>
>
>
>
> --
> Sent by joebayerii from hotmail included in com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Mon Jun 17 2002 - 05:48:04 CDT