SUMMARY: Kernel Paramaters Recomendation for Oracle

From: Chris Bryant (cbryant@dollar.com)
Date: Wed Jun 19 2002 - 08:35:18 EDT


Thanks to Charles Ballowe, Lee Brewer, alan@nabeth.cxo.cpqcorp.net, Geoff
Allen, E. Richard Glazier for their responses. It seem that the reason
those params are set to physical memory is to not to place artifical
constraints on the database. If my understaning is correct, oracle will try
to allocate as much memory as possible and setting these values to physical
memory will allow for that.

Thanks again,

Chris Bryant
Unix Administrator
Dollar Rent A Car
(918) 669-3213

-----Original Message-----
From: Chris Bryant [mailto:cbryant@dollar.com]
Sent: Tuesday, June 18, 2002 2:01 PM
To: Tru64 Unix (E-mail)
Subject: Kernel Paramaters Recomendation for Oracle

Admin,

        This one came from my manager so here goes. It seems that oracle's
recommendation for per_proc_data_size, max_per_proc_data_size,
max_per_proc_address_space, and per_proc_address_space to be set equal to
the amount of physical memory. What I am needing to find out is why it is
recommended to be so high? I will summarize.

Thanks,

Chris Bryant
Unix Administrator
Dollar Rent A Car
(918) 669-3213



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:44 EDT