Oracle with Large Memory

From: <BrianH_at_dice.com>
Date: Thu, 18 Jan 2001 09:44:49 -0600

Does anyone know how to allow Oracle to take more than a 2.8G SGA in 5.1?

Here are the appropriate lines in in /etc/sysconfigtab.

generic:
        memberid = 0
                new_vers_high = 1445655480385976064
                new_vers_low = 51480

vm:
        swapdevice=/dev/disk/dsk0c
        vm-swap-eager=0

proc:
        max_proc_per_user=2048
        max_threads_per_user=4086

        max_per_proc_stack_size=7516192768
        max_per_proc_data_size=7516192768
        max_per_proc_address_space=7516192768
        per-proc-stack-size=7516192768
        per-proc-data-size=7516192768
        per-proc-address-space=7516192768
ipc:
        shm_max=2139095040


These were enough to allow you to go up to 7G in 4.0X, but not in 5.1.

Ideas?

--Brian
Received on Thu Jan 18 2001 - 15:46:11 NZDT

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:41 NZDT