Job Seekers   Employers

dbapool: Authors | Submissions | Contact Us

Forgot password? | Sign up

Home

Discussion Forum

Articles

Interview Questions

FAQs

Scripts

Rewards

Analyzer

White Papers

Blog

Certification

Downloads

Tools

Query to see the Reserved, Used and Free space of your database By: Seju Thomas Sep 03 2007 Query to see the Reserved, Used and Free space of your database.   REM: Query to see the Reserved, Used and Free space of your database REM: REM:***************************************** REM: Author: Seju REM: Date Submitted: 3-Nov-2007 REM: REM: REM: NOTE: PLEASE TEST THIS SCRIPT BEFORE USE. REM: Author will not be responsible for any damage that may be cause by this script. REM:***************************************** SELECT r.tablespace_name, reserved_space "RESERVED_SPACE(MB)", reserved_space - free_space "USED_SPACE(MB)", free_space "FREE_SPACE(MB)" FROM (SELECT tablespace_name, SUM (BYTES) / (1024 * 1024) reserved_space FROM dba_data_files GROUP BY tablespace_name) r, (SELECT tablespace_name, SUM (BYTES) / (1024 * 1024) free_space FROM dba_free_space GROUP BY tablespace_name) f WHERE r.tablespace_name = f.tablespace_name ORDER BY r.tablespace_name;

About Us

Advertise

Terms of Use

Privacy

Newsletters

Contact Us

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads

Our Premium Sponsor