该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
列出如下脚本对应输出:
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