常用查询视图

会话按状态分组统计数
SYS@hx1> select status,count(*) from v$session d group by d.status;

STATUS     COUNT(*)
-------- ----------
ACTIVE           43
INACTIVE          3


表按用户分组统计数
SYS@hx1> select owner,count(*) from dba_tables d where d.owner in ('QIJI','BEDC') group by d.owner;

OWNER                            COUNT(*)
------------------------------ ----------
QIJI                                    2
BEDC                                   75

select * from gv$session d where d.machine not in ('rac6n1','rac6n2');