Oracle Datafile Size and Creation Date

0

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
Share.

About Author

hahahahahaha......nothing here

發表迴響

error: Content is protected !!