Mysql,Oracle数据库连接数

Mysql

D:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 183
Server version: 5.1.58-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 licenseType &＃39;help;&＃39; or &＃39;\h&＃39; for help. Type &＃39;\c&＃39; to clear the current input statement.
-- 使用xuexi数据库
mysql> use xuexi
Database changed
-- 查看字符集
mysql> SHOW VARIABLES LIKE &＃39;character_set%&＃39;;
-- 控制台汉字乱码&＃xff0c;将编码改为gbk&＃xff0c;控制台就可以显示中文了
mysql> set character_set_results&＃61;&＃39;gbk&＃39;;
-- 查看连接数
mysql> SHOW PROCESSLIST;--100条
mysql> show full processlist;
-- 服务器的状态信息
mysql> show status;

Oracle

SQL> conn / as sysdba
Connected.
-- 连接数
SQL> select count(*) from v$session;
-- 并发连接数
SQL> Select count(*) from v$session where status&＃61;&＃39;ACTIVE&＃39;;
--最大连接
SQL> show parameter processes;
-- 修改processes和sessions值
SQL> alter system set processes&＃61;300 scope&＃61;spfile;
SQL> alter system set sessions&＃61;300 scope&＃61;spfile;