检查Oracle数据库的最大连接代码,Shell代码库,德仔网

代码语言

代码分类

【Shell】检查Oracle数据库的最大连接

作者:share_good / 发布于2015/6/4/ 1046

检查Oracle数据库的最大连接


	[root@hzvscmdb sql]# more check_connect_oracle.sh
	#!/bin/bash
	#functions: connect oracle server test
	#author:Tony Wang
	#modify_date: 2015-06-03.
	mkdir -p /home/tony/shell/sql/log #create the directory of log
	LOG_DIR=/home/tony/shell/sql/log #log path
	rm -rf $LOG_DIR/* #delete the expire log
	USERNAME=hr #user
	PASSWORD=pass #password
	SIDNAME=tony1521 #TNS
	icount=0
	while [ "$icount" -lt 20 ]
	do
	 {
	 count=0
	 while [ "$count" -lt 10 ]
	 do
	 LOG_FILE=$LOG_DIR/check_oracle_$icount.$count.log
	 echo `sqlplus $USERNAME/$PASSWORD@$SIDNAME << EOF
	 set echo off
	 set feedback off
	 spool $LOG_FILE
	 alter session set nls_date_format='YYYY-MM-DD:HH24:MI:SS';
	 select sysdate from dual;
	 spool off
	 set echo on
	 set feedback on
	 exit
	EOF` >> $LOG_FILE
	 let count=$count+1
	 done
	 } &
	 let icount=$icount+1
	done

试试其它关键字

　Oracle　　最大连接　

同语言下

可能有用的

share_good贡献的其它代码(12)