南京制作网站企业,广州网站建设联系信科海珠,网站优化的作业及意义,wordpress后台制作概述今天主要分享一下两个shell脚本#xff0c;主要是为了查看所有数据库用户及其表空间#xff0c;统计某个指定用户的明细#xff0c;下面一起来看看吧~数据库连接脚本use script settdb.sh for DB login details registry#!/bin/bashtmp_username$SH_USERNAMEtmp_passwor…概述今天主要分享一下两个shell脚本主要是为了查看所有数据库用户及其表空间统计某个指定用户的明细下面一起来看看吧~数据库连接脚本use script settdb.sh for DB login details registry#!/bin/bashtmp_username$SH_USERNAMEtmp_password$SH_PASSWORDtmp_db_sid$SH_DB_SID#check $1 and $2 should be mandatory from inputif [[ -z $1 ]] || [[ -z $2 ]]; thenecho ***********************************************echo WARNING :UserName And PassWord Is Needed!echo ***********************************************exitfiif [[ -z $3 ]] [[ -z $ORACLE_SID ]];thenecho ***********************************************echo WARNING :There is Instance can be used !echo ***********************************************exitfiSH_USERNAMEecho $1|tr [a-z] [A-Z]SH_PASSWORD$2echo ***********************************************if [[ -z $3 ]]then SH_DB_SID$ORACLE_SID echo Using Default Instance :$ORACLE_SID echo .else SH_DB_SIDecho $3|tr [a-z] [A-Z]fiif [[ $SH_DB_SID $tmp_db_sid ]] [[ $SH_USERNAME $tmp_username ]] [[ $SH_PASSWORD $tmp_password ]];then echo Instance $SH_DB_SID has been connected echo *********************************************** exitfiexport SH_USERNAME$SH_USERNAMEexport SH_DB_SID$SH_DB_SIDexport SH_PASSWORD$SH_PASSWORDexport DB_CONN_STR$SH_USERNAME/$SH_PASSWORD#echo $DB_CONN_STRlistfilepwd/listdbNumecho show user | $ORACLE_HOME/bin/sqlplus -s $DB_CONN_STR$SH_DB_SID| grep -i USER | wc -lif [ $Num -gt 0 ] then ## ok - instance is up echo Instance $SH_DB_SID has been connected echo -e -- date-- --$SH_USERNAME$SH_DB_SID has been connected -- listdb echo *********************************************** echo Initalize DB login details registry OK! echo Now you can Execution script~ echo *********************************************** $SHELL else ## inst is inaccessible echo Instance: $SH_DB_SID Is Invalid Or UserName/PassWord Is Wrong echo *********************************************** exit fidel_length3tmp_txt$(sed -n $ listdb) echo ***********************************************echo ********* $SH_USERNAME$SH_DB_SID **********echo ***********************************************curr_lencat $listfile|wc -lif [ $curr_len -gt $del_length ]; thenecho There Are Below Sessions Still Alive echo ***********************************************fised $((${tmp_txt}-${del_length}1)),${tmp_txt}d $listfile | tee tmp_listfilemv tmp_listfile $listfile输出./settdb.sh 用户名 用户密码showusers.sh脚本内容如下#!/bin/bashecho 查看所有数据库用户及其默认表空间echo set pages 70 lines 99 feedback offcol DEFAULT_TABLESPACE head Default TBS for a15 trunccol TEMPORARY_TABLESPACE head TEMP TBS for a15 trunccol MB head Size (Mb) for 999,999,999col username format a30set linesize 150break on reportcompute sum of MB on reportselect USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATED,nvl(sum(seg.blocks*ts.blocksize)/1024/1024,0) MBfrom sys.ts$ ts,sys.seg$ seg,sys.user$ us,dba_users duwhere us.name () du.username and seg.user# () us.user# and ts.ts# () seg.ts#group by USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE,CREATEDorder by MB desc,username,created/ | sqlplus -s $DB_CONN_STR$SH_DB_SID输出./showusers.shshowusers.sh脚本内容如下#!/bin/bashecho 查看所有数据库用户$1具体信息NAMEecho $1|cut -d. -f1if [ -z $NAME ] then echo -e User must be provided: c; read NAMEfisqlplus -s $DB_CONN_STR$SH_DB_SID 输出./showusers.sh 用户名大家有什么需要统计的可以在下方留言后面我也会整理相关脚本感兴趣的朋友可以关注下
