Well i did a test using exp with compress running in background using pipes..
the table had 6million records and was 3G big..
export (exp) + compression (using pipe) took 4.5 mins
export (exp) + cpmpression (serial task) took 6.0 mins
hardly 1.5 mins difference and that compression took about 2 mins of this total time..
PS, I should admit that i missed the gist of pipe.. your actalluy right..
i had said before
i meant LIO + CPU Time for compression is nearly equal to time required for PIO to local file system..
indeed this is the case, from above test.. the time difference seen is solely because the process is a serial one and former is virtual parallelism..
if we have the table of 20G, then there will still be a max difference of 5-10 mins (required for compression)
I mentioned in my other post that point 2 was not very significant.. as was point 3.. and indeed it is.. your point 2 would be significant if it were a table to 100-200G.. i really suspect if that is the case..
Last edited by abhaysk; 10-18-2007 at 04:50 AM.
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"