Le 28 sept. 09 à 17:58, Glenn Fawcett a écrit :
Been there, done that, got the tee shirt A larger SGA will
*always* be more efficient at servicing Oracle requests for blocks.
You avoid going through all the IO code of Oracle and it simply
reduces to a hash.
Sounds like good advice
Been there, done that, got the tee shirt A larger SGA will *always*
be more efficient at servicing Oracle requests for blocks. You avoid
going through all the IO code of Oracle and it simply reduces to a hash.
http://blogs.sun.com/glennf/entry/where_do_you_cache_oracle
al...@sun wrote:
Hi all,
There is no generic response for:
Is it better to have a "small SGA + big ZFS ARC" or "large SGA + small
ZFS ARC"?
We can awser:
Have a large enough SGA do get good cache hit ratio (higher than 90 %
for OLTP).
Have some GB ZFS arc (Not less than 500M, usually more than 16GB is not
us
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 t
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 PeopleSof
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
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
* 2 Peo
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
* 2 PeopleSoft transactions per day
* HDS USP1100 with LUN
