AIX

--Get AIX version
oslevel
--Paging info
lsps -a --
--Actual free-able memory
svmon -G -O unit=MB
actual free-able memory=memory/size - in use/work
where n/m = row/column 
--example
svmon -G -O unit=MB
Unit: MB
--------------------------------------------------------------------------------------
               size       inuse        free         pin     virtual  available   mmode
memory     24576.00    24447.87      128.13     4156.66     6728.50   16880.25     Ded
pg space    4992.00        26.3

               work        pers        clnt       other
pin         3132.85           0           0     1023.81
in use      6728.50           0    17719.37
 

 6728 MB - actually in use

--actual use of shared memory by Oracle
f=$(ps -ef | grep pmon | grep -v grep | awk '{print $2}')
for pid in $f
do
ps -ef | grep $pid
svmon -P $pid | grep shmat | awk '{if($6 == "s" || $6 == "sm") {page_size=4} else if ($6 == "m") {page_size=64} else if ($6 == "L") {page_size=16*1024} else {page_size = -1}; sum+=$7} END {print sum*page_size/1024"MB"}'
done

Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...