ramdisk/book/undotbs02.dbf 2048 16777216 8 2 8 /mnt/ramdisk/book/undotbs03.dbf 2048 16777216 8 rows selected. --//重启数据库看看: SYS@book> shutdown immediate ; Database closed. Database dismounted. ORACLE instance shut down.
SYS@book> startup ORACLE instance started. Total System Global Area 643084288 bytes Fixed Size 2255872 bytes Variable Size 205521920 bytes Database Buffers 427819008 bytes Redo Buffers 7487488 bytes Database mounted. Database opened.
SYS@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 395645171 3 2 1 1 2 107392 120320 4194302 395645171 3 2 1 2 1 2720 114816 664914 395645171 3 6 1 3 & |