Do session, memory monitoring
Windows Server 2003 SP2
Oracle 10g
/PAE /3GB
RAM 8GB
instances:6
Memory Usage of Oracle.exe for current FY goes upto 2.5 GB
1) exclude database folders from virus scan
2) decrease sga_max_size for all other instances
3)Schedule to kill sniped sessions
http://systemnetworkdatabaseadministrator.blogspot.com/2010/09/idle-session-sniped-session-kill.html
Now Memory Usage of Oracle.exe for current FY goes down 2.1 GB
-------------------------
