; 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/ramdisk/book/undotbs02.dbf 2048 16777216 7 rows selected.
SCOTT@book> select * from GV$FILESPACE_USAGE; INST_ID TABLESPACE_ID RFNO ALLOCATED_SPACE FILE_SIZE FILE_MAXSIZE CHANGESCN_BASE CHANGESCN_WRAP FLAG ------- ------------- ------------ --------------- ------------ ------------ -------------- -------------- ---- 1 0 1 96112 97280 4194302 395636096 3 2 1 1 2 107392 120320 4194302 395638024 3 2 1 2 1 2936 110720 664925 395639290 3 6 1 3 1 256 52992 52992 395639290 3 6 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 4 4 190 |