Oracle Whitepaper: Configuring Oracle® Solaris ZFS for an Oracle Database: Tuning zfs_arc_max
edited Sep 28, 2010 6:49PM in Oracle Solaris File Systems and Disk Management (MOSC) 2 commentsAnswered
Hello,
We would like a valid formula to reduce the zfs arc cache on Solaris database platforms.
Platform : Oracle Solaris on SPARC (64-bit) ver 10.
Database version : 11.2.0.1
The Oracle Whitepaper: Configuring Oracle Solaris ZFS for an Oracle Database (Page 9) states:
http://developers.sun.com/solaris/docs/wp-oraclezfsconfig-0510_ds_ac2.pdf
"10. Allocate sufficient memory and swap resources.
You can reduce Oracle Solaris ZFS memory consumption by tuning the zfs_arc_max parameter to a low value,
but we still recommend provisioning enough memory to cache metadata for the actively used portion of the database, which is estimated at 1.5% with an 8 KB"
Would like an (appropriate) guidance how to size the arc cache when hosting Oracle databases.
We would like a valid formula to reduce the zfs arc cache on Solaris database platforms.
Platform : Oracle Solaris on SPARC (64-bit) ver 10.
Database version : 11.2.0.1
The Oracle Whitepaper: Configuring Oracle Solaris ZFS for an Oracle Database (Page 9) states:
http://developers.sun.com/solaris/docs/wp-oraclezfsconfig-0510_ds_ac2.pdf
"10. Allocate sufficient memory and swap resources.
You can reduce Oracle Solaris ZFS memory consumption by tuning the zfs_arc_max parameter to a low value,
but we still recommend provisioning enough memory to cache metadata for the actively used portion of the database, which is estimated at 1.5% with an 8 KB"
Would like an (appropriate) guidance how to size the arc cache when hosting Oracle databases.
0