|
======查询锁内容
select s.SID,s.SERIAL#,a.owner,a.object_name,q.SQL_TEXT,s.paddr,p.SPID
from v$locked_object l,all_objects a,v$session s,v$sql q,v$process p
where l.OBJECT_ID=a.object_id
and s.SID=l.SESSION_ID
and q.ADDRESS=s.PREV_SQL_ADDR
and s.PADDR=p.ADDR
===查询objects大小
select segment_name,tablespace_name,sum(bytes/1024/1024) from dba_segments
group by segment_name,tablespace_name
order by 3 desc
===查询表空间使用
SELECT A.TS1"表空间",
(1-(B.SUM_B2/A.SUM_B1))*100 "已使用百分比",
(B.SUM_B2/A.SUM_B1)*100 "可使用百分比",
A.SUM_B1"表空间总大小",
A.SUM_B1 - B.SUM_B2 "表空间已使用大小",
B.SUM_B2"表空间剩余大小",
B.MAX_B2 "表空间最大可用块",
B.CNT_B2 "表空间块数量"
FROM
(SELECT TABLESPACE_NAME TS1,
SUM(BYTES) SUM_B1
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME) A,
(SELECT TABLESPACE_NAME TS2,
SUM(BYTES) SUM_B2,
MAX(BYTES) MAX_B2,
COUNT(BYTES) CNT_B2
FROM DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) B
WHERE A.TS1=B.TS2;
|
