Shulou(Shulou.com)05/31 Report--

This article mainly introduces "how to check the use of oracle tablespaces". In the daily operation, I believe many people have doubts about how to view the usage of oracle tablespaces. The editor consulted all kinds of data and sorted out simple and easy-to-use methods of operation. I hope it will be helpful to answer the doubts of "how to check the usage of oracle tablespaces". Next, please follow the editor to study!

Select * from (Select a.tablespace_name, to_char (a.bytes1024) total_bytes, to_char (b.bytes1024) free_bytes, to_char (a.bytes/1024/1024-b.bytespact 1024) use_bytes, to_char ((1-b.bytes/a.bytes) * 100 quotation 99.99) |'% 'use from (select tablespace_name) Sum (bytes) bytes from dba_data_files group by tablespace_name) a, (select tablespace_name, sum (bytes) bytes from dba_free_space group by tablespace_name) b where a.tablespace_name = b.tablespace_name union allselect c.tablespace_name, to_char (c. Bytesmore 1024) total_bytes, to_char ((c.bytes-d.bytes_used) / 1024) free_bytes, to_char (d.bytes_used/1024/1024) '99999.999') use_bytes, to_char (d.bytesoriginused100According to c.bytes) | |%' use from (select tablespace_name,sum (bytes) bytes from dba_temp_files group by tablespace_name) c, (select tablespace_name,sum (bytes_cached) bytes_used from v$temp_extent_pool group by tablespace_name) d where c.tablespace_name = d.tablespace_name) so far The study on "how to view the usage of oracle tablespaces" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.