Sometimes Oracle9i Database startup process uses 1GB Mem

Hi,
I am running Oracle9i on RedHat Linux 7.2. I successfully installed Enterprise edition and created a brand new database. Everything is fine and working normally. but, sometimes when I startup my database the server process is going on graping the Mem upto 1GB. ( which is my total RAM ) and its going on using the swap area also. which making my server to slowdown. after waiting for 3 to 4 min. I am forced to kill the Process.

Why its happening? Is their any changes need to be done at Kernel?

Can any 1 help me????

ThanX in Advance...........


akal.:p

show us the init parameter file.

HI,
set SGA_MAX_SIZE = integer [K | M | G] in your init.ora file.

Cheers.

when u start your database . min it will 300 to 450 m ram in win200 server. u said that u have 1 gb ram . if oracle server is using the swap. better u check your init.ora

how do you check a process is using 1GB ram in linux???

ps ug|more may be :D which shows the % of memory used.

ps doesnt show real memory used though

I have been searching how to see real memory used in unix/linux and so far I only know in Solaris you can see with pmap but others no luck

Hi Pando

In linux you can use the tool free

free
total used free shared buffers cached
Mem: 255384 202360 53024 0 83628 61376
-/+ buffers/cache: 57356 198028
Swap: 529192 47908 481284

regards
Hrishy

hrishy I mean memory used per process not the free memory available in the whole box

hi Pando

sorry lol...heheh

regards
Hrishy