select count(*) from v$process;
select count(*) from v$session;
select value from v$parameter where name = 'processes';
select value from v$parameter where name = 'sessions';
--提交更改连接数
alter system set processes=350 scope=spfile;
alter system set sessions=385 scope=spfile;
--重启
shutdown
startup

/**
清空页面的查询条件
param textname形式：field1,field2,……
限制：IE下肯定没问题
*/
function clearCon(textname){
  	if(textname != "" || textname != undefined){
  		var textObj = textname.split(",");
  		for(var i=0;i<textObj.length;i++){
  			var conText = document.getElementsByName(textObj[i]);
  			if(conText!=null && conText!=undefined){
		  		for(var k=0;k<conText.length;k++){
		  			conText[k].value = "";
		  		}
		  	}
  		}
  	}
  }

function createReq(){
	var obj;
	try {
	 	obj = new XMLHttpRequest();   
	} catch (e) {
		 //假设是IE6或其更早版本   
        var XmlHttpVersions = new Array("MSXML2.XMLHTTP.6.0",   
                                        "MSXML2.XMLHTTP.5.0",   
                                        "MSXML2.XMLHTTP.4.0",   
                                        "MSXML2.XMLHTTP.3.0",   
                                        "MSXML2.XMLHTTP",   
                                        "Microsoft.XMLHTTP");   
        //顺序尝试创建每一个对象，直到成功为止   
        for(var i=0; i<XmlHttpVersions.length && !obj; i++)   
         {   
            try   
             {   
                //尝试创建XMLHTTPREQUEST对象   
                 obj = new ActiveXObject(XmlHttpVersions[i]);   
             }   
            catch(e){
            	//alert(XmlHttpVersions[i]);
            }//忽略产生的错误   
         }   
	}
	return obj;
}

@SuppressWarnings("unchecked")
public List<Map> listMap(String sql) throws HfmpException {
	List<Map> list = new ArrayList<Map>();  
	Connection conn = null;
	PreparedStatement pst = null;  
	ResultSet rs = null;
	try {
		conn = sqlConnect.getConnection();
		pst = conn.prepareStatement(sql);
		rs = pst.executeQuery();
		ResultSetMetaData rm = rs.getMetaData();
		int column = rm.getColumnCount();
		String[] coluName = new String[column];
		for(int t=1;t<=column;t++){
			coluName[t-1]=rm.getColumnName(t);
		}
		while(rs.next()){
			Map map = new HashMap();
			for(int i=0;i<coluName.length;i++){  
				map.put(coluName[i], rs.getObject(coluName[i]));  
			}
			list.add(map);
		}
	} catch (SQLException  e) {
		e.printStackTrace();
	} finally{
		sqlConnect.close(conn, pst, rs);
	}
	return list;
}