Hi Richard,

Thanks for your reply.

We are using Solaris 10 u6 and ZFS version 10.

Regards,

Javi

Richard Elling wrote:
On Sep 24, 2009, at 10:30 AM, Javier Conde wrote:

Hello,

Given the following configuration:

* Server with 12 SPARCVII CPUs and 96 GB of RAM
* ZFS used as file system for Oracle data
* Oracle 10.2.0.4 with 1.7TB of data and indexes
* 1800 concurrents users with PeopleSoft Financial
* 20000 PeopleSoft transactions per day
* HDS USP1100 with LUNs stripped on 6 parity groups (450xRAID7+1), total 48 disks
* 2x 4Gbps FC with MPxIO

Which is the best Oracle SGA size to avoid cache duplication between Oracle and ZFS?

Is it better to have a "small SGA + big ZFS ARC" or "large SGA + small ZFS ARC"?

Who does a better cache for overall performance?

In general, it is better to cache closer to the consumer (application).

You don't mention what version of Solaris or ZFS you are using.
For later versions, the primarycache property allows you to control the
ARC usage on a per-dataset basis.
-- richard


_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss

Reply via email to