On 2/16/07, Ian Dexter R. Marquez <[EMAIL PROTECTED]> wrote:
On 2/16/07, thad <[EMAIL PROTECTED]> wrote:
> Curious question, how much paging space in Linux you appleid for
> Oracle 10G? Is it twice the ram or just equal to amount of ram?
In our production systems, we usually allot about 4GB swap (or twice
the amount of RAM, which is the minimum requirement, I think). (We use
Oracle 10G, 64-bit on SLES.)
The test system we maintain has two cpus with 8gig ram and 16 gig of
paging space ran out of pages and cant fork anymore. The only factor I
could see is that 11 instances of Oracle were running, each doing its
own test. But I have not seen this has happened in Oracle 9.2 with
same specs and paging space of 25% of the ram size. The system is
tuned to Oracle prescribed tuning for the type of file system and
errors pointed to some process to Oracle caused to max out the svmm.
Could this be a sign of improperly tuned SGA?
tad
--
sometimes truth is stranger than fiction
-bad religion-
http://www.bloglines.com/blog/mailist
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph