Speed if file is Compressed

[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

[davey23uk]

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

[DaPi]

You are talking about OS compression I guess. Oracle bypasses the OS data access methods - I'd be amazed if it worked.

[waitecj]

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.

[Horace]

See Metalink Note:228082.1

[Horace]

Ah, just noticed the version he's using, i.e., 8i

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

[Horace]

For everyone else replying

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

Tut tut.

[slimdave]

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

[abhaysk]

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.

[waitecj]

Obvious perhaps, but not noticable on my test server.