|
-
 Originally Posted by abhaysk
Point 2 may be incorrect, as you will still need to do LIO + lots of CPU to compress/uncompress.
I'm in agreement with your assesment of increased CPU utilization for compress/uncompress purposes.
In regards to LIO -respectfully- I don't care about it, I care about physical I/O. Remember, we are doing exp/compress and uncompress/imp on-the-fly therefore in the first case exp is writting to an Unix pipe then compress reads from the Unix pipe and writes to disk; in the second case uncompress reads from the compressed file and writes to an Unix pipe from where imp reads.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote