1. The role of temporary table space:
The main purpose of temporary table space is to provide temporary computational spaces in the database, manage indexing, access, etc., which will automatically clean up when the operation is completed.
When the temporary table space is insufficient, it is expressed as slow operation speed, and the temporary table space grows rapidly to the maximum space (extension limit), and it will not be automatically cleaned.
2. Rapid growth:
The general reason is that the SQL algorithm is incorrect, which may result in Dikarji.
Another reason is the creation of the view (I am what is the problem you encounter!). When multi-tables in the Oracle database joint queries, the number of orders is 4, which will generally think 3! What should I do if I need more than 4 tables? You can build a sub-view:
Such as View0 (United Table0, Table1, Table2), View1 (United Table0, Table3, Table4), View2 (United Table0, Table5, Table6)
The view0, view1, view2 is then combined into a view.
This can solve the problem of rapid growth in temporary table space!
As mentioned above, if there is an incorrect place, you are welcome to correct!
Porgao@hotmail.com
