| database size [message #59805] |
Wed, 24 December 2003 03:07  |
Abhishek Ranjan
Messages: 5
Registered: December 2003
|
Junior Member |
|
|
Hi ,
pl help me.
can u please tell me how to find the size of the oracle database.
its very imp.
regards
Abhishek
|
|
|
|
| Re: database size [message #59806 is a reply to message #59805] |
Wed, 24 December 2003 03:40  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
you can get in different ways if your calculating the database size on extents used in database then you can get information by querying DBA_EXTENTS data dictionary view
select sum(bytes)from dba_extents
convert the output either in mb/kb
or if you want to calculate the size if database on tablespace/datafiles(sizes)
then query select sum(bytes) from dba_data_files
it will help u but be sure that how u will calculate the size of database
|
|
|
|
| Re: database size [message #59810 is a reply to message #59805] |
Wed, 24 December 2003 05:19 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Total (data + temp) allocated size :
select a.data_size+b.temp_size "total_size" from ( select sum(bytes) data_size from dba_data_files) a,
(select sum(bytes) temp_size from dba_temp_files) b;
Total size of all segments(allocated ) :
select sum(bytes) from dba_segments;
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
