Parallel Reads from non-partitioned Oracle table??
Posted: Thu Apr 03, 2008 6:13 am
I have a large Oracle 10g table that is not partitioned at this time. It is my understanding that a read from an Oracle table is done sequentially by the Oracle Enterprise stage.
However, I read someone mention that they use multiple Oracle Enterprise stages to read, giving better performance. Is anyone familiar with this technique?? I am assuming they are doing something like having two or three Oracle Enterprise stages where each one does a separate read, for example, one has a query retrieving all data with a date before a certain date, and the other after the date, then running them through a funnel to combine them.
Would something like this increase your performance?? Does it read in parallel, or would Oracle still serve up the data sequentially?
Thanks!
However, I read someone mention that they use multiple Oracle Enterprise stages to read, giving better performance. Is anyone familiar with this technique?? I am assuming they are doing something like having two or three Oracle Enterprise stages where each one does a separate read, for example, one has a query retrieving all data with a date before a certain date, and the other after the date, then running them through a funnel to combine them.
Would something like this increase your performance?? Does it read in parallel, or would Oracle still serve up the data sequentially?
Thanks!