winkstest@CCDB> SELECT name,ceil(bytes/1024/1024) MB,STATUS FROM v$datafile;
 
NAME                                                                 MB STATUS
------------------------------------------------------------ ---------- --------------
/oracle/oradata/ccdb/ccdb/system01.dbf                             1500 SYSTEM
/oracle/oradata/ccdb/ccdb/sysaux01.dbf                             1500 ONLINE
/oracle/oradata/ccdb/ccdb/undotbs01.dbf                            2985 ONLINE
/oracle/oradata/ccdb/ccdb/users01.dbf                               368 ONLINE
/oracle/oradata/ccdb/ccdb/example01.dbf                             100 ONLINE
/oracle/oradata/ccdb/ccdb/USER_DATA_01.DBF                            5 ONLINE
/oracle/oradata/ccdb/ccdb/WINKS_DATA_01.DBF                           5 ONLINE
/oracle/oradata/ccdb/ccdb/USER_DATA_01_WINKSTEST.DBF                  5 ONLINE
/oracle/oradata/ccdb/ccdb/WINKS_DATA_01_WINKSTEST.DBF                 5 ONLINE
/oracle/oradata/ccdb/ccdb/tq.dbf                                   4969 ONLINE
/oracle/oradata/ccdb/test/lmt_uniform.dbf                          8349 ONLINE
/oracle/oradata/ccdb/test/lmt_auto.dbf                             7138 ONLINE
 
已选择12行。

原创文章，转载请注明： 转载自TQ 试用 WP

本文链接地址: 第9篇 文章

Post Footer automatically generated by wp-posturl plugin for wordpress.

相关日志