Thanks for the question, Deborah.
Asked: June 22, 2017 - 10:45 am UTC
Last updated: June 24, 2017 - 5:35 am UTC
Version: 12.1.0.2
Viewed 1000+ times
You Asked
Hi Tom,
I am hoping for some expert advice on the above,
We have a T5 server using SAN storage which is allocated by ZFS. We have Solaris 11 OS and Oracle Database 12c with single instances (no RAC) and we do not use ASM, our database is limited to 4 CPU cores (but 32 threads) due to licensing
Our database is a transactional database used for HR and Payroll, with around 20 users. The database is less than 50GB in total size
I have found recently that compression is enabled on the disks used by Oracle for the database (all files), will this have negative affect on the database performance?
I am trying to find out if we should remove compression from these disks or not...
Many thanks
Debs
and Connor said...
Maybe.... maybe not :-)
Two things you should consider / check
1) Check with Support to make sure that ZFS compression is fully supported/certified for database files. My understanding is that it is, but its always worth double checking with Support so at least you have that assurance.
2) (Assuming it is supported) is it anything you should be worrying about? To do this, check your AWR/statspack reports for where your application(s) are consuming the most resource. If they (or some background processes) are I/O bound, then its worth investigating further. If they are not I/O bound, then compression or otherwise, if you are happy with the current performance then just leave things as they are.
I'm a big fan of tackling problems that you *know* you have, or know that you are *going* to have....rather than looking for solutions to *possible* problems (if that makes sense).
Is this answer out of date? If it is, please let us know via a Comment