发现磁盘空间写的有点满,闲着无事,看哪个表空间写的数据比较多,进入到oracle的datafile目录
[root@06RZRQ-YLY fstest]# ll -h
?荤.?.5.2G —乱码,语言的问题,先不管
-rw-r----- 1 oracle dba 6.8M 5?.14 14:57 control01.ctl
-rw-r----- 1 oracle dba 6.8M 5?.14 14:57 control02.ctl
-rw-r----- 1 oracle dba 6.8M 5?.14 14:57 control03.ctl
-rw-r----- 1 oracle dba 51M 5?.14 14:54 redo01.log
-rw-r----- 1 oracle dba 51M 5?.14 14:57 redo02.log
-rw-r----- 1 oracle dba 51M 5?.13 12:09 redo03.log
-rw-r----- 1 oracle dba 551M 5?.14 11:55 sysaux01.dbf
-rw-r----- 1 oracle dba 1.1G 5?.14 14:41 system01.dbf
-rw-r----- 1 oracle dba 165M 5?. 1 22:00 temp01.dbf
-rw-r----- 1 oracle dba 3.3G 5?.14 14:55 undotbs01.dbf
-rw-r----- 1 oracle dba 5.1M 5?.14 11:51 users01.dbf
sqlplus进入
SQL> set wrap off -- 查询返回的纪录每行超过默认宽度时,可选择换行(on )或不换行(off),默认为换行;
SQL> select * from v$datafile;truncating (as requested) before column CHECKPOINT_CHANGE#
rows will be truncated
FILE# CREATION_CHANGE# CREATION_ TS# RFILE# STATUS ENABLED C
---------- ---------------- --------- ---------- ---------- ------- ---------- -
1 9 30-JUN-05 0 1 SYSTEM READ WRITE 1
2 444079 30-JUN-05 1 2 ONLINE READ WRITE 1
3 6609 30-JUN-05 2 3 ONLINE READ WRITE 1
4 10566 30-JUN-05 4 4 ONLINE READ WRITE 1
5 8967911909 20-MAY-10 6 5 ONLINE READ WRITE 1
6 8967911945 20-MAY-10 7 6 ONLINE READ WRITE 1
7 8967912008 20-MAY-10 8 7 ONLINE READ WRITE 1
8 8967912057 20-MAY-10 9 8 ONLINE READ WRITE 1