OraFAQ Forum: Server Administration

Wed, 17 July 2002 09:17

Ashwin Kamath
Messages: 1
Registered: July 2002

Junior Member

Hi,
Can Some one please let me know as to how do we find the size of the database. Not the size of SGA

thanks
Ashwin

Wed, 17 July 2002 10:17

Grant
Messages: 578
Registered: January 2002

Senior Member

use the view dba_data_files.

select sum(bytes) from dba_datafiles;

Thu, 18 July 2002 01:11

Naresh
Messages: 27
Registered: March 2001

Junior Member

Try this sql
select sum( bytes/(1024*1024)) "filesize MB"
from dba_data_files
where status like 'AVAILABLE%'
;

Previous Topic:	Oracle 9i License
Next Topic:	Re: svrmgrl asks for password

Goto Forum:

]

Current Time: Thu Dec 26 07:04:38 CST 2024