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

Hi pando,

Yah you can see the % of memory and CPU usage using top command.

Its on linux just type

$ top -d .5
--------------------
I think it not the problem with init.ora b'coz When I startup my database everytime its not giving this problem. I dont know when?, due to what reasons.? but sometimes when my startup command hangs up just I open another session and uses "top" command. to see running processes. their I found the Oracle Sessions server process which is utilizing nearly 1GB of RAM.

type this command on linux :
$ top -d .2
( after getting the top session, just type "i" to see only running processes )

Regards,
Singh.

well TOP does not show you the real memory used, it's like PS so what you see is not correct