Monday 10 March 2014

Oracle memory - Actual usage


Oracle memory actual usage

find oracle instances --> ps -ef | grep ora_smon
svmon -P $( ps -elf | grep ora_smon_ORDID | grep -v grep | awk '{print $4}' |) | grep shmart
check for 6th and 7th field. s means 4KB blocks m=64KB L=16MB blocks
more details @
http://intermediatesql.com/aix/how-oracle-uses-memory-on-aix-part-2-sga/
To find expected usage
to get sysresv output
su - oracle
export ORACLE_SID=<ID got from ps -ef | grep ora_smon>
sysresv
ipcs -ma | grep (oracle shared memory instance ID got from sysresv command in sql prompt)

No comments:

Post a Comment