oracle在aix与linux上的差异,请教 AIX 与 Linux 中，怎样分析Oracle的内存占用？

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

列出如下脚本对应输出：

ps vg|grep ora|awk '{sum=sum+$7-$10} END {print sum/1024}'

svmon -G

svmon -U oracle

svmon -U grid

svmon -Put 10 列出内存前10 的进程

svmon -Sut 10 列出前10的内存segment

svmon -P $(ps -elf | egrep " ora_smon_${ORACLE_SID} " | grep -v egrep | awk '{print $4}') | grep shmat

svmon -O unit=MB

ls -al $ORACLE_HOME/bin/oracle >> /tmp/support.txt

whoami >> /tmp/support.txt

ulimit -a >> /tmp/support.txt

svmon -O unit=MB >> /tmp/support.txt

/usr/sbin/lsps -a >> /tmp/support.txt

/usr/sbin/lsattr -HE -l sys0 -a realmem >> /tmp/support.txt

ipcs -m >> /tmp/support.txt

select name, value/1024/1024 as Mbytes from v$pgastat

where name in ('maximum PGA allocated','aggregate PGA target parameter','aggregate PGA auto target');

select sum(value)/1024/1024 as Mbytes from v$sga;

select current_size/1024/1024 Mbytes from V$SGA_DYNAMIC_FREE_MEMORY;

ipcs -mb