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

This article is about how database tablespaces are monitored. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Judge the attributes of the tables in the tablespace in the database. The query methods for all tablespaces are as follows:

Select contents,tablespace_name from dba_tablespaces

View the value of the field of conntents

2) if the attribute of contents is TEMPORARY, it represents the temporary tablespace

If the attribute of contents is UNDO, it represents the backup tablespace

If the attribute of contents is PERMANENT, it represents a permanent tablespace

There is no need to monitor the database tablespaces where TEMPORARY,UNDO belongs to ORACLE automatic recycling space, but for PERMANENT to be permanent tablespaces, it needs to be monitored.

Thank you for reading! This is the end of the article on "how to monitor database tablespaces". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it for more people to see!

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.