liunx脚本获取oracle统计数
#----脚本链接数据库----------------------
#数据库地址
db_ip=192.168.0.2
db_port=1521
db_sid=qxt
db_username=test_user
db_password=123321
db_oracle_name="${db_username}/${db_password}@${db_ip}:${db_port}/${db_sid}"
loc2=`sqlplus -s ${db_oracle_name} << !
set pages 0
set feed off
set heading off
set feedback off
set verify off
set linesize 1000;
select count(1) from t_mt_20200404;
exit
!`
echo "统计结果:"$loc2