OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » DATABASE SPACE

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

DATABASE SPACE [message #151390]

Wed, 14 December 2005 10:34

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Hi

I need to have an approximate idea how much we might need space for database, From the existing system i got the space allocated for tablespaces, indexes, users, temp and undo and got this figure 145109(M),

By this value i can say that we are using 145109/1024= 141 GB am i right, Can i say approximately we are currently using 141 GB of space for Oracle database, apart from other O/s and other applications i am only ask to say for Oracle database.

I know for future growth we might have to consider many things but just want to know what are the things to be taken down while taking the sapce used by database ..,

Thanks

Report message to a moderator

Re: DATABASE SPACE [message #151395 is a reply to message #151390]

Wed, 14 December 2005 11:15

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Use the script below .. it will give you the space used / freee/ allocated metrics ..and finally the space used by database ..

column dummy noprint
column  pct_used format 999.9       heading "%|Used"
column  name    format a16      heading "Tablespace Name"
column  Mbytes   format 999,999,999    heading "Mbytes"
column  used    format 999,999,999   heading "Used"
column  free    format 999,999,999  heading "Free"
column  largest    format 999,999,999  heading "Largest"
break   on report
compute sum of Mbytes on report
compute sum of free on report
compute sum of used on report

select nvl(b.tablespace_name,
             nvl(a.tablespace_name,'UNKOWN')) name,
       Mbytes_alloc Mbytes,
       Mbytes_alloc-nvl(Mbytes_free,0) used,
       nvl(Mbytes_free,0) free,
       ((Mbytes_alloc-nvl(Mbytes_free,0))/
                          Mbytes_alloc)*100 pct_used
from ( select sum(bytes)/1024/1024 Mbytes_free,
              tablespace_name
       from  sys.dba_free_space
       group by tablespace_name ) a,
     ( select sum(bytes)/1024/1024 Mbytes_alloc,
              tablespace_name
       from sys.dba_data_files
       group by tablespace_name )b
where a.tablespace_name (+) = b.tablespace_name
order by 1
/

-Sai Jeedigunta

Report message to a moderator

Re: DATABASE SPACE [message #151400 is a reply to message #151395]

Wed, 14 December 2005 11:48

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Thanks Sai Jeedigunta

Report message to a moderator

Previous Topic:	Database Shutdown/Startup Procedure
Next Topic:	Import to another tablespace oracle10G

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 16:59:15 CST 2025