Target file system capacity report

SELECT DISTINCT st.target_name, st.mountpoint,
                  ROUND ( (freeb / 1073741824), 2) AS "Free (GB)",
                  ROUND ( (sizeb / 1073741824), 2) AS "Size (GB)",
                  ROUND ( ( ( (sizeb - freeb) / sizeb) * 100), 2) AS "Used (%)"
    FROM MGMT$STORAGE_REPORT_LOCALFS st, mgmt$os_summary os
   WHERE  st.target_name = os.HOST
         AND st.mountpoint = '/usr/local/oracle'
         OR st.mountpoint LIKE '/databases%'
         OR st.mountpoint LIKE '/archive%'
         OR st.mountpoint LIKE '/app%'
ORDER BY 5 DESC;