SHARE
TWEET

Untitled

a guest Jun 20th, 2019 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. > SELECT NULL LINK, null, tablespace_name AS label, ROUND(
  2. > SUM(on_disk_size_mb ) / 1024 ) AS space_gb FROM
  3. > tab$database_tablespaces WHERE ( database_name, tablespace_name,
  4. > last_seen )
  5. >         IN (SELECT database_name, tablespace_name, MAX(last_seen) FROM tab$database_tablespaces
  6. >             GROUP BY database_name, tablespace_name)
  7. >        GROUP BY NULL, tablespace_name UNION ALL SELECT NULL LINK, null, 'Free' "Database", ROUND(MAX(on_disk_free_mb)/1024) AS "Space
  8. > (GB)" FROM tab$database_tablespaces WHERE (database_name,
  9. > tablespace_name, last_seen)
  10. >        IN (SELECT database_name, tablespace_name, MAX(last_seen) FROM tab$database_tablespaces
  11. >        GROUP BY NULL, database_name, tablespace_name)
  12.      
  13. SELECT 'f?p=' || :APP_ID || ':5:' || :APP_SESSION || '::NO:::' LINK,
  14. SUM( ON_DISK_SIZE_MB ), SUM( ON_DISK_FREE_MB ), TO_CHAR(TRUNC( LAST_SEEN), 'DD/MM/YYYY' ) FROM tab$database_tablespaces
  15. WHERE LAST_SEEN > SYSDATE - 180 AND Tablespace_name = 'CSP_DATA'
  16. GROUP BY TRUNC(LAST_SEEN)
  17. ORDER BY TRUNC(LAST_SEEN) ASC
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top