Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted May 13, 2002

Listen Software's How To: Calculating Tablespace and Table Byte Sizes

By David Nishimoto

Tablespace Byte Sizes

select distinct 
       a.tablespace_name, 
sum(a.bytes) 
       as free_bytes,
sum(b.BYTES) 
       as Total_Bytes 
from dba_free_space a, 
     dba_data_files b 
Where a.tablespace_name = 
      b.tablespace_name 
group by a.tablespace_name

Table Byte Sizes

select segment_name,tablespace_name,bytes,blocks 
FROM DBA_SEGMENTS 
where segment_type='TABLE' AND TABLESPACE_NAME 
NOT IN('SYSTEM') order by bytes desc


Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date