database size

[smruti123]

Hi
how can I find database size? Please show me syntax.

smruti123

[davey23uk]

in terms of pure data or the sum of all the database files?

[jaingaurav]

If you want the size in terms of database files then you can use the query:
select sum(bytes)/1024/1024 from dba_data_files;
as data files constitute 90% of the database size.

Also to this you can add the size given by this query:
select sum(bytes)/1024/1024 from v$log;
this gives the size of the redo log files......as these mainly constitute the remaining size left over after the data files

[davey23uk]

add dba_temp_files to that and you are just about there

[OracleDoc]

What ever happened to "can you tell me where I might find?" or "any help would be appreciated"?

It's down to demands now instead of requests?

[smruti123]

in terms of pure data or the sum of all the database files?

Hi davey

Thanks for quick response. I am not sure its pure data or the sum of all the database files, but if somebody want to know how big is your database?, Can you tell me where I might find?

Smruti123

[marist89]

Thanks for quick response. I am not sure its pure data or the sum of all the database files, but if somebody want to know how big is your database?, Can you tell me where I might find?

Dude, that's the question. Define "size". What are you looking for?