| How to deside the SGA size for fresh oracle installation? [message #295654] |
Wed, 23 January 2008 00:38  |
tannad
Messages: 43
Registered: January 2008
Location: mumbai
|
Member |
|
|
Suppose I installed the fresh Linux 7.3on the machine..
then how we decide the kernel parameter inLinux?
and how we decide the SGA size??
Suppose we have 2 GB of RAM
and dump file of datadase is 50 GB
So what is the Brake up of SGA?
How we deside the PGA_Aggregate_targate,
buffer cache,java pool large pool, db block size,redo log buffer,SGA_max _size??
can you tell mi regarding that how we decide it for fresh installation of database 
|
|
|
|
|
|
| Re: How to deside the SGA size for fresh oracle installation? [message #295676 is a reply to message #295669] |
Wed, 23 January 2008 01:23  |
tannad
Messages: 43
Registered: January 2008
Location: mumbai
|
Member |
|
|
Hi
Manjit
I want to INSTALLATION OF ORACLE 9I RELEASE 2 ON LINUX 7.3
Ram size is 2GB
So on what basis we deside the kernel parameter?
/proc/sys/kernel/shmmax
/proc/sys/kernel/shmni
shmni
/proc/sys/fs/file-max
ulimit -
means how much we keep shmmax,min,ulimit,?
and Suppose my database size is 50 Gb then how we devide the SGA parameter ?
Means for that 2GB ram how much we keep for SGA ? how much for OS?
and what is the Break up in SGA?
Regards,
Tanad
[Updated on: Wed, 23 January 2008 04:41] Report message to a moderator |
|
|
|
| Re: How to deside the SGA size for fresh oracle installation? [message #295746 is a reply to message #295654] |
Wed, 23 January 2008 04:42 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
Tannad,
1. For Kernel parameters refer installation guide of your platform version. This guide is part of your Oracle Media & also available on following link. http://tahiti.oracle.com/
for Linus related : http://tldp.org/
2. You plan to use LINUX 7.3. Please use a linux version which is optimised for server role & performance if your target database is a production one else go ahead with what ever you have. There is a linux offering (free of cost)from Oracle else you can visit to download. : http://www.oracle.com/linux.
3, For SGA & PGA keep 70%:30% ratio of RAM kept aside for oracle. For Oracle & OS keep 70%:30% of total RAM. These recommendations are for total RAM up to 2 GB or less for higher RAM reduce OS share proportionately. Later on tune as per performance requirement as your database goes full stream in production.
4. for shmmax, shmni,shmni,file-max follow recommendations in your installation Guide because their values is OS & kernel version specific.
5. For SGA advisable to Specify SGA_TARGET & let oracle manage its components until performance issues demands manual resizing.
6. some nice docs are here for you to read if desire : http://www.oracle-base.com/articles/9i/Articles9i.php
Hope this will clear. Volumes have been written on installation.My advice is read as much as you can.
Manjit Kumar [mkbhati]
[Updated on: Wed, 23 January 2008 04:44] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
