You should turn on auto-tuning. The main value proposition of 10g over 9i is that you don't have to screw around with db_block_buffers etc. anymore. Just set the target SGA that you want and let the system self-tune.
OTOH I'm no Oracle expert (my knowledge is so dated, back with 8i) so my suggestion would be to contact your friendly Oracle Support person. On 2/17/07, thad <[EMAIL PROTECTED]> wrote: ..
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?
_________________________________________________ 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
