数据库会话查询.txt - 墨天轮文档

数据库会话查询.txt

1页

10次

2022-12-08

免费下载

查看表空间使用情况

select sum(bytes)/(1024*1024) as free_space,tablespace_name

from dba_free_space

group by tablespace_name;

---列出总的会话数量，激活的会话数量，非系统会话数量和系统会话数量

SELECT 'TOTAL SESSIONS NUM IS: '||COUNT(*) FROM v$session

UNION ALL

SELECT 'ACTIVE SESSIONS NUM IS: '||COUNT(*) FROM v$session WHERE status

='ACTIVE'

UNION ALL

SELECT 'USER SESSIONS NUM IS : '||COUNT(*) FROM V$SESSION WHERE TYPE='USER'

UNION ALL

SELECT 'BACKGROUND SESSIONS NUM IS: '||COUNT(*) FROM V$SESSION WHERE

TYPE='BACKGROUND';

select n.MACHINE,n.STATUS,COUNT(*)

FROM v$session n

GROUP BY n.MACHINE,n.STATUS

ORDER BY 3 DESC,1;

select sql_id,count(*) from v$session group by sql_id;

select count(*) from v$session;

select username,count(*) from v$session group by username; ---按用户查看当前会话数

select count(*) from v$session where status='ACTIVE';

select count(*) from v$process; ---当前进程

select value from v$parameter where name='processes'; ------数据库允许的最大连接数

select count(*) from v$session where status='ACTIVE'；-----查看活跃的连接会话

据库实例启动以来，连接数据库 session 曾经的最大值

select

SESSIONS_MAX,SESSIONS_WARNING,SESSIONS_CURRENT,SESSIONS_HIGHWATER,USERS_MAX from

v$license;

select username,machine,count(username) from v$session where username is not

null group by username,machine;

of 1

免费下载

关注