Hi to all ;
Kernal values formula for oracle 10g database on OEL4
I asked many DBAs regarding this question. Few persons saying right,
MAny peoples saying it's wrong. Given formula is right or not
There are two main components
Shared memory : SHMMAX , this should be more than the size of your memory structures.
e
PHP Code:
g. SHMMAX = (SGA+PGA)Instance size of all the database + 30% of the instance size.
eg. If i have 3 databases and sizes are
For DB1 SGA=3G , PGA=2G
For DB2 SGA=1G , PGA=3G
For DB3 SGA=1G , PGA=1G
So , SHMMAX will be (3+2+1+3+1+1)= 11G + 30%(11G)=round(11G+3.3)= 15G.
Semaphores : As a DBA we don't know how many users will be accessing one database concurrently.
we need to get the approximate value from client. This can be calculated using
PHP Code:
Semaphores = (processes of all DB ie.processes parameter from DB)*2 +10*no.of databases
eg. If i have 3 databases with processes parameter
For DB1 = 800 , DB2=1200,DB3=500
(800+1200+500)*2+10*3 = 2500+30=2530