database size

[sri_purna]

Hi All,

help me to find out exact totall size of database.

Thanx

Sam

[gandolf989]

It depends on what you are looking for.

If you want to know the SGA size then log on to sqlplus as system and type "show sga".

If you want to know how much storage is allocated try the following:

-- megs allocated
SELECT ROUND(SUM(BYTES)/1024/1024) MB FROM DBA_EXTENTS;

-- megs by schema owner
SELECT OWNER, ROUND(SUM(BYTES)/1024/1024) MB
FROM DBA_EXTENTS
GROUP BY OWNER;

-- megs by tablespace
SELECT TABLESPACE_NAME, ROUND(SUM(BYTES)/1024/1024) MB
FROM DBA_EXTENTS
GROUP BY TABLESPACE_NAME;

-- total size of all files
SELECT ROUND(SUM(BYTES)/1024/1024) MB FROM DBA_DATA_FILES;

-- total size of each tablespaces
SELECT TABLESPACE_NAME, ROUND(SUM(BYTES)/1024/1024) MB
FROM DBA_DATA_FILES
GROUP BY TABLESPACE_NAME;

It really depends on what you are looking for. Hope this helps.

[sri_purna]

thanxs