SELECT SID, SERIAL#, STATUS, USERNAME, SCHEMANAME, OSUSER,TERMINAL, MACHINE, PROGRAM, A.NAME FROM V$SESSION S, AUDIT_ACTIONS A WHERE S.COMMAND = A.ACTION order by username,status ;
当前数据库建立的会话情况
SQL> select sid,serial#,username,program,machine,status from v$session order by username,status;
STATUS 当前这个会话的状态,ACTIVE表示会话正在执行某些任务,INACTIVE表示当前会话没有执行任何操作;
如果DBA要手工断开某个会话,则执行:
alter system kill session 'SID,SERIAL#';
注意,上例中SID为1到7(USERNAME列为空)的会话,是Oracle的后台进程,不要对这些会话进行任何操作。
select count(*) from v$session #连接数
Select count(*) from v$session where status='ACTIVE' #并发连接数
show parameter processes #最大连接
select username,count(username) from v$session where username is not null group by username
#查看不同用户的连接数
USERNAME COUNT(USERNAME)
-------- ---------------
ADMIN 2
SDE 18
SYS 2
1:oracle中怎样查看总共有哪些用户
select * from all_users;
select USER#,name,CTIME, PTIME from user$;
select tablespace_name, count(*) chunks , max(bytes/1024/1024) max_chunk from dba_free_space group by tablespace_name;
alter tablespace 表空间名 coalesce;