hello all
what is a script to use really quickly where i can check if the database is running out of virtual memory?
Printable View
hello all
what is a script to use really quickly where i can check if the database is running out of virtual memory?
The thumb rule is to have an SGA size that is not more than half of the available RAM on the server.
but how do i check the amount of memory being used? if it's getting maxed out a lot
the memory being used is the SGA you specify, add PGA
check v$sgastat, v$sysstat
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).
If u are using unix sar command should give you detailes about the resource usage. And vmstat should give me memory usage