oracle常规用法

显示数据库名：show parameterdb_name

查询并发数：Select count(*) from v$session where status='ACTIVE' ;

查询在线用户：select username,osuser from v$session;
查询某个用户在线连接数：select sid,username,osuser,status,SQL_ID from v$session  where osuser='lm'
杀掉在线用户步骤:
1.select sid,serial# from v$session where username='user_name';
2.kill掉
  alter system kill session 'sid,serial'; 

SQL> show parameter processes  #最大连接

SQL> alter system set processes = value scope = spfile;重启数据库  #修改连接

查询

select SQL_TEXT FROM v$sqltext a where (a.HASH_VALUE, a.ADDRESS) IN (SELECT decode(sql_hash_value, 0, prev_hash_value, sql_hash_value), decode(sql_hash_value, 0, prev_sql_addr, sql_address) FROM v$session b where b.sid =&sid )