Note for using temporary Oracle tablespace

Note:
1. Temporary tablespace is used to store temporary data during sorting operations (such as large queries, index creation, and joint queries)
Each user has a temporary tablespace.
2. For large operations (large queries, large-scale classified queries, large-scale statistical analysis, etc.), a separate temporary tablespace should be specified to facilitate management.

3. assign a separate temporary tablespace to the user. It is generally used for large product databases, OLTP databases, and database warehouses.
For small products, you do not need to create temporary tablespace separately. Use the default temporary tablespace.

Note: If the temporary tablespace is abnormally increasing rapidly, you need to consider whether the SQL statement used generates the flute product. You can use stactpack for analysis to find out the problem, so as to ensure the normal operation of the database.