Database Size

[Former Member]

Hi All,

We are using SAP Ecc5.0. Database is Oracle 9.2 and the operating system is IBM-AIX. How can we find the total database size used and the available disk space both in production server and development server.

Regards

Shiva

[Former Member · Accepted solution]

Hi

Use DB02 transacton code it will give you detailed information.

It will help you

regards

kiran kumar.v

[Former Member]

Dear Iyer

One more approach ...

The majority of the size comes from the datafiles. To find out how many

megabytes are allocated by ALL tablespaces, type:

select sum(bytes)/1024/1024 from dba_data_files;

select sum(bytes/1048576)from dba_extents;

Add to this the size (in megabytes) of your redo logs:

select sum(bytes)/1024/1024 from v$log;

The above two queries will show you how large your database is. Also, if

you are in archivelog mode, you will generate files in your archivelog

destination. Issue the following query to see where your archived redo

logs get placed:

select * from v$parameter where name = 'log_archive_dest';

OS disk space details df -k

du -sk directory

du -h etc....

Vinod

[Former Member]

size for all tablespace (oracle)

set lines 140

set pages 200

SELECT D.TABLESPACE_NAME "TBS",D.STATUS "Status",ROUND((A.BYTES/1024/1024),2) "TAille"

,ROUND(((A.BYTES-DECODE(F.BYTES,NULL,0 ,F.BYTES))/1024/1024),2) "Util"

, ROUND(((A.BYTES/1024/1024)-(A.BYTES-DECODE(F.BYTES,NULL,0,F.BYTES))/1024/1024),2) "Libre"

,ROUND((((A.BYTES/1024/1024)-(A.BYTES-DECODE(F.BYTES,NULL,0,F.BYTES))/1024/1024)/(A.BYTES/1024/1024))*100.0,2) "%libre"

FROM SYS.DBA_TABLESPACES D,SYS.SM$TS_AVAIL A,SYS.SM$TS_FREE F WHERE D.TABLESPACE_NAME = A.TABLESPACE_NAME AND F.TABLESPACE_NAME(+)=D.TABLESPACE_NAME

/

or you can try this request for size for database:

select to_char(tb1.tot_dat/1048576,'999,999,999,990.000') "TOTAL BASE (en Mo)",

to_char(tb2.tot_free/1048576,'999,999,999,990.000') "ESPACE LIBRE (en Mo)",

to_char(tb1.tot_dat/1048576-tb2.tot_free/1048576,'999,999,999,990.000') "UTILISE"

from (select sum(bytes) tot_dat from dba_data_files) tb1,

(select sum(bytes) tot_free from dba_free_space) tb2;

[Former Member]

To see the available disk space at OS level you can use the command "df" ( disk free ) it will show you the available space and used space

[Former Member]

Hi,

You can check your database size,current free size,errors and everything using the transaction <b>DB02</b>

Go to DB02 and click space statistics to view DB size or u can very well see it on the side of that particular screen.

kindly let me know in case of any issues.

regards

jag