摘要：
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.tablespac... 阅读全文
posted @ 2015-12-02 15:38 徐正柱- 阅读(433) 评论(0) 推荐(0)
摘要：
SELECT * FROM V$SESSION WHERE USERNAME IS NOT NULL AND STATUS = 'ACTIVE' ORDER BY LOGON_TIME, SID;1.查询会话SELECT P.SPID, S.SID, S.OSUSER,... 阅读全文
posted @ 2015-12-02 15:37 徐正柱- 阅读(486) 评论(0) 推荐(0)
浙公网安备 33010602011771号