|
bsp; 1 3 1 256 52992 52992 395643160 3 6
1 4 4 1904 16384 4194302 395637154 3 2
1 6 5 39704 44320 4194302 395636096 3 2
1 7 6 128 5120 4194302 395636096 3 2
7 rows selected.
--//还是7条记录
SCOTT@book> SELECT file#,ts#,rfile#,name,blocks,bytes FROM v$datafile;
FILE# TS# RFILE# NAME BLOCKS BYTES
----- --- ------ -------------------------------- ------ ------------
1 0 1 /mnt/ramdisk/book/system01.dbf 97280 796917760
2 1 2 /mnt/ramdisk/book/sysaux01.dbf 120320 985661440
3 2 3 /mnt/ramdisk/book/undotbs01.dbf 110720 907018240
4 4 4 /mnt/ramdisk/book/users01.dbf 16384 134217728
5 6 5 /mnt/ramdisk/book/example01.dbf 44320 363069440
6 7 6 /mnt/ramdisk/book/tea01.dbf 5120 41943040
7 2 7 /mnt/ |