Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

Oracle 11gXEr2 Base Datafile Size
-- 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 Datafile Size

-- 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));

Oracle 11gXEr2 Base Install Tablespace Size


Oracle 11gXEr2 Installation Steps

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: Spetember 13, 2014

  23430