Re: IO Bottleneck won't go away

Mike Jones wrote:
>
> I'm currently experiencing a very annoting IO Bottle neck.
>
> While running a "create as select" I experience massive IO bottleneck.
> This is unsurprising given the size of the Tables I am Joining (1 mill rows
> * 4 tables) three tables are outerjoined to the same main table.
>
> In order to speed this up I took the recommended action of creating Indexes
> on the tables to be outer joined. However the index creation takes an age
> due to the amount of IO they cause. I've tried creating these in parallel
> to see if that helped, but the IO Bottleneck means that the overall
> performance is virtually unaffeted.
>
> All I am currently able to do is move the bottleneck around and so gain no
> perfomence improvement.
>
> any ideas??
>
> This query is running on Oracle 734

HI
can you create the new table on a tablespace that's on a physically seperate disk? Trying to read/write to the table disk always causes problems, Oracle or not.

Martin Received on Fri Oct 29 1999 - 05:19:45 CDT