The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Maxsl
By Guest on 14th March 2019 12:01:09 PM | Syntax: TEXT | Views: 5



New paste | Download | Show/Hide line no. | Copy text to clipboard
  1. SELECT MAX(nvl (100 * (bytes - free) / bytes, 100))
  2.   FROM (SELECT ddf.tablespace_name,
  3.                SUM(dfs.bytes) free,
  4.                ddf.bytes bytes
  5.           FROM (SELECT tablespace_name,
  6.                        SUM(bytes) bytes
  7.                   FROM dba_data_files
  8.                  GROUP BY tablespace_name) ddf,
  9.                dba_free_space dfs
  10.          WHERE ddf.tablespace_name = dfs.tablespace_name (+)
  11.          GROUP BY ddf.tablespace_name,
  12.                ddf.bytes)



  • Recent Pastes