磁盘多大的啊?开归档了吗? 这个不好查--你通过下面的语句去查查 是哪个表空间在一直增加 --看看警告日志里什么情况 select Total.Tname "表空间名称", Total.Total_Size "表空间大小", Total.Total_Size - Used.free_size as "已使用大小", Used.Free_size as 表空间剩余大小, Round((Total.Total_Size - Used.free_size) / Total.Total_Size,4)* 100 || '%' as 表空间使用率 from ( -- 表空间数据文件的大小 select tablespace_name as TName, round(sum(user_bytes)/(1024*1024),1) as Total_size from dba_data_files group by tablespace_name ) Total, ( -- 表空间剩余的大小 select tablespace_name as TName, round(sum(bytes)/(1024*1024),1) as Free_size from dba_free_space group by tablespace_name ) Used where Total.TName = Used.TName(+)
没有开归档日志。我用的select sql_text,first_load_time from v$sql order by first_load_time desc; 我的是磁盘满了,
如下面的语句可以查询当前在运行的sql语句: select a.serial#,b.address, b.sql_text from v$session a, v$sql b where a.sql_id=b.sql_id
这个不好查--你通过下面的语句去查查 是哪个表空间在一直增加
--看看警告日志里什么情况
select Total.Tname "表空间名称",
Total.Total_Size "表空间大小",
Total.Total_Size - Used.free_size as "已使用大小",
Used.Free_size as 表空间剩余大小,
Round((Total.Total_Size - Used.free_size) / Total.Total_Size,4)* 100 || '%' as 表空间使用率
from
(
-- 表空间数据文件的大小
select tablespace_name as TName,
round(sum(user_bytes)/(1024*1024),1) as Total_size
from dba_data_files
group by tablespace_name
) Total,
(
-- 表空间剩余的大小
select tablespace_name as TName,
round(sum(bytes)/(1024*1024),1) as Free_size
from dba_free_space
group by tablespace_name
) Used
where Total.TName = Used.TName(+)
我的是磁盘满了,
select a.serial#,b.address, b.sql_text from v$session a, v$sql b
where a.sql_id=b.sql_id