OraFAQ Forum: Server Administration » How to find the Size of the Database?

Home » RDBMS Server » Server Administration » How to find the Size of the Database? - Urgent.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to find the Size of the Database? - Urgent. [message #372022]

Thu, 04 January 2001 12:34

nivetha
Messages: 2
Registered: January 2001
Location: chennai

Junior Member

Hi!

How to find the Size of the Database?.

Thanks
Nivetha

Report message to a moderator

Re: How to find the Size of the Database? - Urgent. [message #372027 is a reply to message #372022]

Thu, 04 January 2001 17:05

SD
Messages: 16
Registered: March 2000

Junior Member

This query would give you the total size allocated for the database

column total format 999,999,999,999
select sum(bytes) Total from sys.dba_Data_files ;

This query would give you the result of the total size allocated to the objects in the database

select sum(bytes) total from sys.dba_extents

For calculating space actually used I have pro*c program. If you need that let me know.

Report message to a moderator

Re: How to find the Size of the Database? - Urgent. [message #372028 is a reply to message #372022]

Thu, 04 January 2001 18:28

nivetha
Messages: 2
Registered: January 2001
Location: chennai

Junior Member

Thanx very much.

Report message to a moderator

Previous Topic:	grouping codes that are listed consecutively and assigning them...
Next Topic:	Distinct and Order by

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 02:47:33 CDT 2024