oracle 查看锁表 查看当前链接数

//查看那些表被锁

select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;

//给表解锁

alter system kill session '127,3514';（值应该根据实际的做相应的修改）

//查看当前数据库连接数

 select count(*) from v$process;

//查看数据库最大连接数

 select value from v$parameter where name = 'processes';

//修改数据最大连接数（要重启数据库）

  alter system set processes = 500 scope = spfile;

//查看当前连接的用户

SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine 

from v$session a, v$sqlarea b

where a.sql_address =b.address order by cpu_time/executions desc;