Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: swap/memory ratio

Re: swap/memory ratio

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Fri, 25 Nov 2005 00:08:35 GMT
Message-ID: <Xns9718A4529A204SunnySD@70.168.83.30>


DA Morgan <damorgan_at_psoug.org> wrote in news:1132852125.439465_at_yasure:

> Papa Piquillo wrote:

>> I am trying to estimate the amount of swap/memory i have to use in my
>> hp-ux box running several oracle instances.
>> I think that this issue is very related to the number of concurrent
>> users and the activity of them in the database.
>> Having in count the size of the sga's and the value of the
>> pga_agregate_target i can estimate how much virtual memory i am going
>> to need.
>> If virtual memory = ram + swap --> which is lowest amount of ram i have
>>
>> to use in a way that paging doesn't afect the performance.
> 
> I think your question is impossible to answer based on what
> you've written.
> 
> No operating system name or version
> No Oracle edition or version
> 
> Go to http://docs.oracle.com and read the installation docs.

Any answer will also be application s/w dependent & how well the s/w has been tuned for Oracle (or not as with many packaged ERP applications). Received on Thu Nov 24 2005 - 18:08:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US