1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

ORACLE Tutorials

This code displays the tablespace usage in MB.

Code:

SELECT Total.name "Tablespace Name", total_space "Total Space",
nvl(Free_space, 0) "Free Space",
nvl(total_space-Free_space, 0) "Used Space",
((free_space/total_space)*100) "Percent Free"
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) Total_Space
from v$datafile a, v$tablespace B
where a.ts# = b.ts#
group by b.name
) Total
WHERE Free.Tablespace_name(+) = Total.name and (free_space/total_space)*100<10
ORDER BY Total.name
/

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy