Determine Tablespace Size

[Michael42]

Hey all,

Though this may seem like the dumbest question, what is the SQL used to determine the size of a tablespace?

I am NOT looking for the amount used but the entire allocated space for the tablespace,i.e. used space plus unused space.

I have been hunting here and on the web to find this without success.

Thanks,

Michael42

 

[BJCooperIT]

select * from sys.user_tablespaces
where TABLESPACE_NAME = 'Your Tablespace'

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus

 

[Michael42]

>> size of a tablespace

In bytes, sorry I should have specified this.

Thanks,

Michael42

 

[SantaMufasa]

Michael,

Try this code:

col a heading "Sum In Bytes|of Tablespace|Files" format 999,999,999,999
select sum(bytes) a,tablespace_name from dba_data_files
group by tablespace_name;

    Sum In Bytes
   of Tablespace
           Files TABLESPACE_NAME
---------------- ----------------
     251,658,240 DATA1
     241,172,480 DATA2
      20,971,520 RBS
     163,577,856 SYSTEM
      10,485,760 TEMP

Let us know if this is what you wanted. (If you want my favourite script, search for "@freespace" in the Advanced Search option of Tek-Tips.)

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.