1、AIX VG使用率
# lsvg datavg
VOLUME GROUP: datavg VG IDENTIFIER: 0008f1550000d6000000014fbad58616
VG STATE: active PP SIZE: 512 megabyte(s)
VG PERMISSION: read/write TOTAL PPs: 5594 (2864128 megabytes)
MAX LVs: 2048 FREE PPs: 3877 (1985024 megabytes)
LVs: 41 USED PPs: 1717 (879104 megabytes)
OPEN LVs: 4 QUORUM: 13 (Enabled)
TOTAL PVs: 25 VG DESCRIPTORS: 25
STALE PVs: 0 STALE PPs: 0
ACTIVE PVs: 25 AUTO ON: yes
MAX PPs per VG: 262144 MAX PVs: 1024
LTG size (Dynamic): 256 kilobyte(s) AUTO SYNC: no
HOT SPARE: no BB POLICY: relocatable
# a=$(lsvg datavg |grep -e "USED PPs" |awk '{print $5}')
# echo $a
1717
# b=$(lsvg datavg |grep -e "TOTAL PPs" |awk '{print $6}')
# echo $b
5594
# awk 'BEGIN{printf "%.2f
",('$a'/'$b')*100}'
30.69
LINUX ORACLEASM使用率
[root@hayjdb1 bin]# cat asm_used.sql
col NAME for a20
set lin 150
select NAME,TOTAL_MB,FREE_MB,STATE from v$asm_diskgroup;
exit
[root@hayjdb1 bin]# cat asm_usedmon.sh
a=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/asm_used.sql" |grep CONNECTED |awk '{print $3}')
b=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/asm_used.sql" |grep CONNECTED |awk '{print $2}')
awk 'BEGIN{printf "%.2f
",(1-'$a'/'$b')*100}'
[root@hayjdb1 bin]# su - oracle
[oracle@hayjdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 24 10:19:15 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> col NAME for a20
SQL> set lin 150
SQL> select NAME,TOTAL_MB,FREE_MB,STATE from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB STATE
-------------------- ---------- ---------- -----------
DATA 102400 51835 CONNECTED
OCR_VOTE 9216 8290 MOUNTED
[root@hayjdb1 bin]# a=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/asm_used.sql" |grep CONNECTED |awk '{print $3}')
[root@hayjdb1 bin]# echo $a
51835
[root@hayjdb1 bin]# b=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/asm_used.sql" |grep CONNECTED |awk '{print $2}')
[root@hayjdb1 bin]# echo $b
102400
[root@hayjdb1 bin]# awk 'BEGIN{printf "%.2f
",(1-'$a'/'$b')*100}'
49.38
3、oracle session使用率
a=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/sessionall.sql" |grep ^session |awk '{print $3}')
b=$(su - oracle -c "sqlplus / as sysdba @/zabbix/bin/session.sql " | sed s/[[:space:]]//g |egrep -v 'Release|Reserved|Connected|OLAP|MAIL|COUNT|-|andRealApplicationTestingoptions|Copyright|Data'|grep -v '^$')
awk 'BEGIN{printf "%.2f
",('$b'/'$a')*100}'