Analytics Resources: Insights, Best Practices,

Case Studies and More

Determine free space in tablespace

Performance Tuning Oracle DB

close
Written by Hemanta Banerjee
on November 14, 2013

Determine free space in tablespace

select tablespace_name, SizeMb, FreeMb, (FreeMb/SizeMb)*100 PercentFree from ( select b.tablespace_name, tbs_size SizeMb, a.free_space FreeMb from (select tablespace_name, round(sum(bytes)/1024/1024 ,2) as free_space from dba_free_space group by tablespace_name) a, (select tablespace_name, sum(bytes)/1024/1024 as tbs_size from dba_data_files group by tablespace_name) b where a.tablespace_name(+)=b.tablespace_name and a.tablespace_name = 'SCB_CRO'

 

Posts by Tag

You may also like:

Performance Tuning Mobile Analytics Exalytics OBIEE 12c

Oracle BI - Insights delivered Pervasively

The new release of Oracle Business Intelligence Foundation Suite 11g, Release 11.1.1.7.0, features more than two hundred...

Performance Tuning OBIEE 12c

Prevent the FETCH FIRST XXX ROWS ONLY from Applying

SUBSCRIBE TO OUR BLOGS
 
Get all News Updates to your inbox.
Easy email reminders who count on the weekly recap.
logo2

Quick link

Singapore

10 Changi Business Park Central 2, #04-11, Hansapoint@CBP
Singapore 486030

+65 6100 6631

Vietnam

Fl 8-Unit 802, Beautiful Saigon building, 2 Nguyen Khac Vien street, Tan Phu ward, Dist. 7, HCMC, Vietnam

© 2020 Just Analytics (Terms of use and Privacy Policy)