QUICK!!check if running out of memory in database

[chrissy]

hello all

what is a script to use really quickly where i can check if the database is running out of virtual memory?

[Halo]

The thumb rule is to have an SGA size that is not more than half of the available RAM on the server.

[chrissy]

but how do i check the amount of memory being used? if it's getting maxed out a lot

[pando]

the memory being used is the SGA you specify, add PGA
check v$sgastat, v$sysstat

[shwa]

What platform are you on? On most unixes, vmstat or top will give you a good idea of what virtual memory resources are being used & how much swapping is occuring. I'm not sure how to get such info on NT/2000 (other than what's available in task manager).

[Kishore]

If u are using unix sar command should give you detailes about the resource usage. And vmstat should give me memory usage