OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » database size

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

database size [message #170509]

Thu, 04 May 2006 02:19

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

hello all

if someone asks that what is the size of your database
What does it mean?

size of all datafiles ........ or......

sum of (size of all datafile,controlfiles and redolog files).

Thanks
Have a nice time.

Report message to a moderator

Re: database size [message #170515 is a reply to message #170509]

Thu, 04 May 2006 03:35

saravanan mani
Messages: 12
Registered: April 2006
Location: chennai

Junior Member

its sga size and add control and datafile file size ,,,

-sarav-

Report message to a moderator

Re: database size [message #170529 is a reply to message #170509]

Thu, 04 May 2006 04:37

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SGA size has nothing to do here.
datafile size is what that matters.
To b accurate you can
sum of size all datafiles (allocated)
or
sum of actual space within the datafiles ( utilized).

Report message to a moderator

Re: database size [message #170572 is a reply to message #170509]

Thu, 04 May 2006 07:00

abs_amit
Messages: 59
Registered: January 2006
Location: delhi

Member

ok thanks mahesh

i think u mean

select sum(bytes)/1024/1024 "Size in MB" from dba_data_files;

am i right?

should i include temporary files also??

Report message to a moderator

Re: database size [message #170590 is a reply to message #170572]

Thu, 04 May 2006 07:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Yes. That is the allocated size.
You may also want to consider the actual database size (you allocate 1gb datafile. But the database may be using only 100m).

oracle@mutation#dbsize mutation

Size of the database    :    1,457.50 MB


Free space              :    1,224.81 MB


Used space              :      232.36 MB

oracle@mutation#tbs_usage mutation

TABLESPACE_NAME                total_size_mb    used_size_mb free_size_mb     used_%
------------------------------ ------------- --------------- ------------ ----------
SYSTEM                                   250          204.50      45.4375       81.8
UNDOTBS1                                 510           27.17     482.6875       5.33
USERS                                  687.5             .69       686.75         .1
TOOLS                                     10             .00       9.9375          0
mytbs1                                                   .00            0          0
INDX                                                     .00            0          0

Report message to a moderator

Previous Topic:	Same oracle login for 200+user..issue if any?
Next Topic:	How to create a new user from an existing user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 02:13:39 CDT 2025