how to get the database size of several system

[Former Member]

Hi

We've got a lot of database system on our landscape. I want to make a simple report to get the size the all our database on a weekly base.

I try to get a RZ20 value on it without succes.

Do you know a sql request that i could launch on all my database to get this information ? i did'nt find any V$^view with this information.

thanks for your help

florent

[Former Member]

Hi,

The following SQL statement gives you the size of all the datafiles including temp and undo on Gigabytes from an Oracle database.

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

Hopefully this help,

Zareh

[Former Member]

Hi

thanks for the select cmd.

it work fine but this views doesnt count the tmp datafile which are located in the view dba_temp_files.

do you if i could make a single sql request to sum the 2 views to get the whole database size ?

thanks

[Former Member]

Hi,

Use DB02 and check the total size of your tablespaces, this will also include your PSATEMP and PSAPUNDO.

Regards,

Nilesh

[markus_doehr2]

"The database size" can be

- the total size

- the filled size

- the filled size without undo/temp

You can use DBACOCKPIT to centrally manage multiple instance and check the sizes.

Markus