Speed if file is Compressed
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Speed if file is Compressed

  1. #1
    Join Date
    Apr 2003
    Location
    Hyderabad
    Posts
    40

    Speed if file is Compressed

    I am Using ORCALE 8i on Windows2k Server.
    If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
    Ok
    Thanking U

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

    Re: Speed if file is Compressed

    Originally posted by bk_raavi
    I am Using ORCALE 8i on Windows2k Server.
    If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
    Ok
    Thanking U
    you wanna zip files up - and you think oracle will work after that or am i missing something here

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You are talking about OS compression I guess. Oracle bypasses the OS data access methods - I'd be amazed if it worked.

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Not zip files up, but compress the directory, I assume... or at least, I hope.

    If so, then I have done that on a test box with no performance side-effects... but I wouldn't dream of doing it on a live server. If your company values their data, I would tell them to buy more disk. Its cheap nowadays y'know.

  5. #5
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    See Metalink Note:228082.1
    Last edited by marist89; 12-15-2004 at 12:37 PM.

  6. #6
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Ah, just noticed the version he's using, i.e., 8i

    So you need to upgrade to 9ir2 to use this.

  7. #7
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    For everyone else replying

    check out the SCOPE & APPLICATION section.....

    Tut tut.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: Speed if file is Compressed

    Originally posted by bk_raavi
    I am Using ORCALE 8i on Windows2k Server.
    If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
    Ok
    Thanking U
    Benchmark it
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: Speed if file is Compressed

    Originally posted by bk_raavi
    If i Compress the datafile/s to save the harddisk space,it will effects on the speed of oracle operations ?
    Which so ever might be the compression algorithm, its obvious that the decompression process would take its time as against retrival of data without compression.

    Abhay.
    funky...

    "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"

  10. #10
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Obvious perhaps, but not noticable on my test server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width