oracle基础操作

数据库连接数查询

select count() from v$process;--当前的数据库连接数selectcount(\ast )fromv$session ; --当前的session连接数
select count() from v$sessionwherestatus{=}^{\prime }ACTIV{E}^{\prime };--并发连接数selectvaluefromv$parameter where name =‘processes’; --数据库允许的最大连接数
select username,count(username) from v$session where username is not null group by username ; --查询各个用户名连接数

select object_name,machine,s.sid,s.serial# from v$locke{d}_{o}bjectl,db{a}_{o}bjectso,v$session s where l.object_id　=　o.object_id and l.session_id=s.sid;

alter system kill session ‘sid, serial#’; --(978, 11145)

查询表空间总量

SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;

查询表空间剩余

SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
FROM dba_free_space
GROUP BY tablespace_name;

清空回收站

purge recyclebin