Shulou(Shulou.com)06/01 Report--

SELECT DECODE (file_name, 'file_nameFROM dba_tablespaces UNION SELECT dba_tablespaces.tablespace_name, tablespace_name, LPAD ('-- >', 5) | | file_name) tablespace_name FROM (SELECT * FROM (SELECT tablespace_name,'M' file_nameFROM dba_tablespaces UNION SELECT dba_tablespaces.tablespace_name, dba_data_files.file_name | |''| Allocated:' | | ROUND (bytes/ (1024 / 1024), 2) | |'MB) 'FROM dba_tablespaces Dba_data_files WHERE dba_tablespaces.tablespace_name = dba_data_files.tablespace_name) ORDER BY tablespace_name, file_name DESC)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.