Hi, Definitely large SGA, small arc. In fact, it's best to disable the ARC altogether for the Oracle filesystems.
Blocks in the db_cache (oracle cache) can be used "as is" while cached data from ARC needs significant CPU processing before it's inserted back into the db_cache. Not to mention that block in db_cache can remain dirty for longer periods, saving disk writes. But definetelly: - separate redo disk (preferably dedicated disk/pool) - your ZFS filesystem needs to match the oracle block size (8Kb default) With your configuration, and assuming nothing else (but oracle database server) on the system, a db_cache size in the 70 GiB range would be perfectly acceptable. Don't forget to set pga_aggregate_target to something reasonable too, like 20 GiB. Christo Kutrovsky Senior DBA The Pythian Group I Blog at: www.pythian.com/news -- This message posted from opensolaris.org _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
