[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details

How to maximze unused memory under Solaris

Asked by BrettBond in Sun Solaris, Oracle ERP, Computer Memory (RAM)

Tags: Sun, Solaris, 10, Memory tuning optimization

We're running a 4 CPU Sun Server with 16GB of RAM and Solaris 10 connected to a SAN. This server is a dedicated Oracle 10g database server whose main use is local ETL processing. There is no OLTP. Our raw source data is approx 250G.

In studying our CPU and memory utilization, I noticed that our CPU use gets pegged at 100% during many ETL jobs, but our memory utilization rarely exceeds 40%.

Is there some way we can configure our Sun OS to take advantage of the 8-10G of unused memory as a generic disk cache (that may help improve our Oracle performance?)

We're also in the process of tuning our Oracle ETL code and we may configure Oracle to use more memory, but I still believe we'll have a lot of unused memory left over that we could for speeding up our server environment.

Any suggestions?

Brett
[+][-]09/23/08 07:58 AM, ID: 22550098Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01/06/09 06:22 AM, ID: 23304503Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-89 / EE_QW_2_20070628