-- Oracle 11gXEr2 Base Datafile Size SELECT banner database_info FROM v$version; SELECT file#, CAST(name as VARCHAR2(50)) file_name, bytes/1024/1024 size_mb from v$datafile; SELECT file#, CAST(REPLACE(name,'C:\ORACLEXE\APP','') as VARCHAR2(35)) file_name, bytes/1024/1024 size_mb , TO_CHAR(creation_time,'mm/dd/yyyy') creation_time from v$datafile; -- Oracle 11gXEr2 Base Install Tablespace Size SELECT CAST(t.tablespace_name AS VARCHAR2(20)) table_space, SUM(d.bytes)/1024/1024 ts_size, t.initial_extent initial_ext, t.next_extent, t.pct_increase "INCREASE%", t.status FROM dba_tablespaces t, dba_data_files d WHERE t.tablespace_name = d.tablespace_name GROUP BY CAST(t.tablespace_name AS VARCHAR2(20)), t.initial_extent, t.next_extent, t.pct_increase, t.status ORDER BY CAST(t.tablespace_name AS VARCHAR2(20));
23430