Oracle Datafile 建立日期及現在大小(MB)
SQL :
select a.file_name, a.tablespace_name, TO_CHAR(b.creation_time,'MM-DD-YYYY'),Round(a.bytes/1024/1024,2) "Size (M)" from dba_data_files a, v$datafile b where a.file_name = b.name
Oracle Datafile Size and Creation Date
0
Share.
